CST_COSTED_ONHAND_QTY_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID VAL_UNIT_ID INVENTORY_ITEM_ID UOM_CODE ONHAND_QUANTITY

Query

SQL_Statement
SELECT cost_org_id, cost_book_id, val_unit_id, inventory_item_id, uom_code, SUM(quantity) OnHand_Quantity FROM CST_COSTED_ONHAND_DAILY WHERE sysdate BETWEEN snapshot_date AND eff_to_date GROUP BY cost_org_id, cost_book_id, val_unit_id, inventory_item_id, uom_code