PJB_XLA_WAREHOUSE_ITEM_V

Details

• Schema: FUSION

• Object owner: PJB

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID WAREHOUSE_BU_ID WAREHOUSE_BU_NAME INVENTORY_ITEM_NUMBER WAREHOUSE_ITEM_SALES_ACCT_ID

Query

SQL_Statement
SELECT Item.Inventory_item_id INVENTORY_ITEM_ID, Item.Organization_id WAREHOUSE_BU_ID, Item.Organization_id WAREHOUSE_BU_NAME, Item.Item_Number INVENTORY_ITEM_NUMBER, Item.Sales_account WAREHOUSE_ITEM_SALES_ACCT_ID FROM EGP_SYSTEM_ITEMS_B Item