CST_RUNTOTAL_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSACTION_ID REC_TRXN_ID DEP_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE COST_TRANSACTION_TYPE QUANTITY QTY_RUN_TOTAL UOM_CODE

Query

SQL_Statement

SELECT CT.TRANSACTION_ID ,CT.REC_TRXN_ID ,CT.DEP_TRXN_ID ,CT.COST_ORG_ID , CT.COST_BOOK_ID , CT.INVENTORY_ITEM_ID , CT.VAL_UNIT_ID , CT.COST_DATE , CT.COST_TRANSACTION_TYPE , CT.QUANTITY , SUM(CT.QUANTITY) OVER (PARTITION BY CT.COST_ORG_ID, CT.COST_BOOK_ID, CT.VAL_UNIT_ID, CT.INVENTORY_ITEM_ID ORDER BY CT.INVENTORY_ITEM_ID, CT.COST_DATE, CT.TRANSACTION_ID ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING) QTY_RUN_TOTAL , CT.UOM_CODE FROM CST_TRANSACTION_LAYERS CT