Home/ Questions/Q 82442
Next
Answered
Question
albert
  • 0
Explorer
Asked: 2023-06-03T14:00:56+03:00 In: ,

What is Inventory Item Table in Oracle Fusion

  • 0

What are the key columns and their corresponding data types in the Inventory Item table in Oracle Fusion?

Share

    Related Questions

    1 Answer

    1. Best Answer
      Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
      This answer was edited.

      The table containing inventory item details in Oracle Fusion is “EGP_SYSTEM_ITEMS_B“. It has one composite primary key (INVENTORY_ITEM_ID, ORGANIZATION_ID). and here you can find a sample query to get the most used information about items in Oracle Fusion:

      Query Inventory Item in Oracle Fusion

      SELECT ITEM_NUMBER
,INVENTORY_ITEM_ID
,FULL_LEAD_TIME
,PLANNER_CODE
,DECODE (MRP_PLANNING_CODE, 3, 'MRP Planned', 4, 'MPS Planned', 6, 'Not Planned', 7, 'MRP/MPP Planned', 8, 'MPS/MPP Planned', 9, 'MPP Planned', NULL)
MRP_PLANNING_CODE
,INVENTORY_ITEM_STATUS_CODE
,MINIMUM_ORDER_QUANTITY
,MAXIMUM_ORDER_QUANTITY
,FIXED_ORDER_QUANTITY
,FIXED_LOT_MULTIPLIER
,DECODE (INVENTORY_PLANNING_CODE, 6, 'Not Planned', 2, 'Min-Max', 1, 'Reorder Point', 7, 'Vendor Managed') INVENTORY_PLANNING_CODE
,MIN_MINMAX_QUANTITY
,MAX_MINMAX_QUANTITY
,MTL_TRANSACTIONS_ENABLED_FLAG
,CUSTOMER_ORDER_ENABLED_FLAG
,SO_TRANSACTIONS_FLAG
,PRIMARY_UOM_CODE
,UNIT_LENGTH
,UNIT_WIDTH
,UNIT_HEIGHT
,UNIT_WEIGHT
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
FROM EGP_SYSTEM_ITEMS_B
WHERE ORGANIZATION_ID = NVL(:INV_ORG_ID,ORGANIZATION_ID);

      In the above query, we have one parameter, “:P_INV_ORG_ID” to get the item information in a specific inventory organization.

      You can refer to the Oracle doc to know all columns in this table.

      Hope this help.

      • 0

    Leave an answer

    You must login to add an answer.

    Need An Account,