CST_INTRANSIT_QTYS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSFER_CST_INV_TXN_ID COST_ORG_ID COST_BOOK_ID QUANTITY

Query

SQL_Statement
SELECT CT.TRANSFER_CST_INV_TXN_ID, CT.COST_ORG_ID, CT.COST_BOOK_ID, SUM(CTX.quantity) FROM CST_TRANSFERS CTX, CST_TRANSACTIONS CT WHERE CTX.POSTED_FLAG = 'Y' AND ctx.transaction_id = CT.TRANSACTION_ID GROUP BY CT.TRANSFER_CST_INV_TXN_ID, CT.COST_ORG_ID, CT.COST_BOOK_ID