POR_REQUISITION_LINES_ALL Holds the Requisition line details. This post talks about Table structure, index and constraint details.
Category: Oracle Fusion
Value Sets: Related Tables and Query to Fetch the Details
Query to fetch the value set details such as Value Set Name, Value, Description and associated tables in Oracle.
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
Item Catalog – Category Assignment in Fusion
Tables and queries needed to fetch item catalog and category & relationship between Catalog and categories.