CST_NEGINV_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
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

Query

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'