Item categories table in oracle fusion

Item categories table in oracle fusion

In this table , we will be discuss about, Item categories table in oracle fusion. Item Category helps to bifurcate the Item in terms of use in oracle apps. Item categories table in oracle fusion , help to store the Categories information which we do attach to the Inventory item. Here below i will share the Detail Item category table list in oracle fusion and the sql query to extract the item category information.

Most Important Item categories 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

SQL Query using Item categories 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 ) )