CST_DEPQTY_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
DEP_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE QUANTITY_DEPLETED

Query

SQL_Statement
SELECT CTL.DEP_TRXN_ID ,CTL.COST_ORG_ID ,CTL.COST_BOOK_ID ,CTL.INVENTORY_ITEM_ID ,CTL.VAL_UNIT_ID ,MAX(CTL.COST_DATE) AS COST_DATE ,SUM (CTL.QUANTITY) AS QUANTITY_DEPLETED FROM CST_TRANSACTION_LAYERS CTL WHERE CTL.DEP_TRXN_ID >0 GROUP BY CTL.DEP_TRXN_ID ,CTL.COST_ORG_ID ,CTL.COST_BOOK_ID ,CTL.INVENTORY_ITEM_ID ,CTL.VAL_UNIT_ID