Item catalog table in Oracle Fusion

Item catalog table in Oracle Fusion

In this post , We will be discuss about the Item catalog table in Oracle Fusion. Item catalog helps to group the inventory items based on its characteristics. Item catalog table , help to store the Item catalog informations in oracle fusion. I will share the detail list of the Item catalog table in oracle fusion. Please find below the Item catalog table in Oracle Fusion.

Most Important Item catalog table in Oracle Fusion

1.egp_item_cat_assignments

2.egp_category_sets_b

3.egp_system_items_b

4.inv_org_parameters

5.EGP_CATEGORIES_TL

Detail SQL query using Item catalog table in Oracle Fusion

SELECT ITEMS.ITEM_NUMBER,

ITEMCATS.category_id,

ITEMCATS.sequence_number,

ITEMCATS.alt_item_cat_code,

ECT.DESCRIPTION,

ECT.CATEGORY_NAME

FROM egp_item_cat_assignments ITEMCATS,

egp_category_sets_b CATSETS,

egp_system_items_b ITEMS,

inv_org_parameters ORG,
EGP_CATEGORIES_TL ECT

WHERE CATSETS.category_set_id = ITEMCATS.category_set_id

AND ITEMS.inventory_item_id = ITEMCATS.inventory_item_id

AND ORG.organization_id = ITEMS.organization_id

AND ITEMCATS.category_id=ECT.category_id

AND ( ( CATSETS.control_level = 1

AND ITEMCATS.organization_id = ORG.master_organization_id )

OR ( CATSETS.control_level = 2

AND ITEMCATS.organization_id = ORG.organization_id ) )