CST_NEGINV_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
DEP_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ORG_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE ORIG_QTY NEG_INV_QTY ORIG_NEG_QTY |
問合せ
| SQL_Statement |
|---|
|
SELECT /*+ index(ct cst_transactions_n1) */ CTL.DEP_TRXN_ID, CT.COST_ORG_ID, CT.COST_BOOK_ID, CT.INVENTORY_ORG_ID, CT.INVENTORY_ITEM_ID, CT.VAL_UNIT_ID, CTL.COST_DATE, CT.QUANTITY ORIG_QTY, CT.QUANTITY-CT.QUANTITY_DEPLETED NEG_INV_QTY, CTL.QUANTITY ORIG_NEG_QTY FROM CST_TRANSACTION_LAYERS CTL, CST_TRANSACTIONS CT WHERE CTL.REC_TRXN_ID = CT.TRANSACTION_ID AND CTL.DEP_TRXN_ID = CT.TRANSACTION_ID AND CTL.TRANSACTION_ID = CT.TRANSACTION_ID AND CT.COST_METHOD_CODE IN ('PERPETUAL_AVERAGE', 'ACTUAL', 'STANDARD') AND CT.POSTED_FLAG = 'I' |