WIE_MATERIAL_ORG_ON_HAND_QTY_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ORGANIZATION_ID ON_HAND_QTY

Query

SQL_Statement
select item.inventory_item_id, item.organization_id, sum(nvl(primary_transaction_quantity,0)) as On_Hand_Qty from egp_system_items_vl item, inv_onhand_quantities_detail itemonhand where item.inventory_item_id = itemonhand.inventory_item_id(+) and item.organization_id = itemonhand.organization_id(+) group by item.inventory_item_id, item.organization_id