Item Number table in oracle fusion

Item number table in oracle fusion

In this post , We will be discuss about the Item number table in oracle fusion. Item number tables in oracle fusion , helps to store the Item code or item number , item description informations. Item number is the item code. I will try to share the Inventory Item tables which do store the item number information in oracle fusion. Here below is the detail item number table in oracle fusion .

Important Item number table in oracle fusion

1.EGP_SYSTEM_ITEMS_B

2.EGP_SYSTEM_ITEMS_TL

3.EGP_ITEM_REVISIONS_B

SQL Query Using Item number table in oracle fusion

select ESIB.ITEM_NUMBER,ESIB.INVENTORY_ITEM_STATUS_CODE,ESIB.INVENTORY_ORGANIZATION_ID,
ESIT.DESCRIPTION,ESIB.MASTER_ORG_ID,
EIRB.REVISION,EIRB.REVISION_REASON
from EGP_SYSTEM_ITEMS_B ESIB,
 EGP_SYSTEM_ITEMS_TL ESIT,
EGP_ITEM_REVISIONS_B EIRB
WHERE ESIB.INVENTORY_ITEM_ID=ESIT.INVENTORY_ITEM_ID
AND ESIB.INVENTORY_ITEM_ID=EIRB.INVENTORY_ITEM_ID