MTL_SYSTEM_ITEMS_B: Table used by Oracle R12 for storing the Item information. Or in other words, it is R12 equivalent of EGP_SYSTEM_ITEMS_B table in Oracle Fusion. Slight difference is that MTL_SYSTEM_ITEMS_B table stores the item number in segment1 field. And since the item is defined at Inventory Org level, Combination of Inventory_item_Id and Organization_Id will give… Continue reading MTL_SYSTEM_ITEMS_B: Columns, Indexes & Few Tricks
Category: Table Structure
QP_PRICE_LISTS_TL: Columns, Indexes and Few Tricks
QP_PRICE_LISTS_TL: Translation table of Price List information in Oracle Fusion. Post to provide details of Index, columns and a few tricks.
QP_PRICE_LISTS_ALL_B: Columns, Indexes & Imp Points
QP_PRICE_LISTS_ALL_B: Table structure, Index and salient points of the table used as base table of price list.
QP_PRICE_LIST_ITEMS: Columns, Index and Imp Points
QP_PRICE_LIST_ITEMS: relationship of Item and Price List In Fusion, table structure and Index details along with salient points
INV_MATERIAL_TXNS: Table Structure and Indexes
Inv_material_txns: Table structure, Indexes & salient points.