CST_INTRANSIT_QTYS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
TRANSFER_CST_INV_TXN_ID COST_ORG_ID COST_BOOK_ID QUANTITY |
問合せ
| 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 |