SQL to fetch vendor site code, procurement BU, alternate site name, customer number, purchasing site flag, pay site flag, document category etc
Blog
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.
Subinventory Table INV_SECONDARY_INVENTORIES
Table structure, constraints & indexes on table inv_secondary_inventories to help the fine tune the queries.
Subinventory Query in Oracle Fusion
Query to fetch the subinventory details like inventory, picking Order, material status, depreciable, locator control, locator structure