POR_REQUISITION_LINES_ALL Holds the Requisition line details. This post talks about Table structure, index and constraint details.
Category: Table Structure
HZ_PARTY_SITES: Table Structure, Index, Constraints
HZ_PARTY_SITES: Post to share the column names, indexes and constraints of the table
DOO_FULFILL_LINES_ALL: Columns, Indexes & Imp Points
doo_fulfill_lines_all: column, index and constraint details : the table which holds the fulfilment details of Sales Order Line
Item Catalog Category Table Details
Table structure of item catalog categories table like egp_category_sets_b, egp_categories_tl, egp_item_categories, egp_categories_b etc
Inv_Org_Parameters: Inventory Table In Fusion
Inv_org_parameters table is one of the most important table if you have implemented inventory module in Oracle Fusion. Anywhere there has to be a linkage with inventory org, this table will come into the game. Example is querying egp_system_items_b table for a particular item_number. In the image below you can see the place of inventory… Continue reading Inv_Org_Parameters: Inventory Table In Fusion