POR_REQUISITION_LINES_ALL Holds the Requisition line details. This post talks about Table structure, index and constraint details.
Category: indexes
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
Subinventory Table INV_SECONDARY_INVENTORIES
Table structure, constraints & indexes on table inv_secondary_inventories to help the fine tune the queries.