CST_INTRANSIT_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSFER_CST_INV_TXN_ID COST_ORG_ID COST_BOOK_ID COST_ELEMENT_ID UNIT_COST CURRENCY_CODE

Query

SQL_Statement
SELECT CT.TRANSFER_CST_INV_TXN_ID, CT.COST_ORG_ID, CT.COST_BOOK_ID, CTXC.COST_ELEMENT_ID, SUM(ctxc.quantity * CTXC.UNIT_COST) AS UNIT_COST , CTXC.CURRENCY_CODE FROM CST_TRANSFER_COSTS CTXC, CST_TRANSACTIONS CT WHERE ctxC.transaction_id = CT.TRANSACTION_ID GROUP BY CT.TRANSFER_CST_INV_TXN_ID, CT.COST_ORG_ID, CT.COST_BOOK_ID, CTXC.COST_ELEMENT_ID, CTXC.CURRENCY_CODE