機械翻訳について

CST_INTRANSIT_COSTS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CST

• オブジェクト・タイプ: VIEW

列

名前
TRANSFER_CST_INV_TXN_ID COST_ORG_ID COST_BOOK_ID COST_ELEMENT_ID UNIT_COST CURRENCY_CODE

問合せ

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