CST_DEPQTY_REMAIN_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
DEP_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE ORIG_QUANTITY QUANTITY_DEPLETED QUANTITY_REMAIN

Query

SQL_Statement

SELECT CT.TRANSACTION_ID AS DEP_TRXN_ID ,CT.COST_ORG_ID ,CT.COST_BOOK_ID ,CT.INVENTORY_ITEM_ID ,CT.VAL_UNIT_ID ,CT.COST_DATE ,CT.QUANTITY AS ORIG_QUANTITY , NVL(DEP.QUANTITY_DEPLETED,0) AS QUANTITY_DEPLETED , CT.QUANTITY - NVL(DEP.QUANTITY_DEPLETED,0) AS QUANTITY_REMAIN FROM CST_TRANSACTIONS CT LEFT OUTER JOIN CST_DEPQTY_V DEP ON CT.TRANSACTION_ID = DEP.DEP_TRXN_ID WHERE CT.POSTED_FLAG = 'N' AND CT.COST_TRANSACTION_TYPE = 'ISSUE'