CST_ONHAND_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
REC_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE QUANTITY_ONHAND UOM_CODE

Query

SQL_Statement
SELECT CTL.REC_TRXN_ID ,CTL.COST_ORG_ID ,CTL.COST_BOOK_ID ,CTL.INVENTORY_ITEM_ID ,CTL.VAL_UNIT_ID ,CTL.COST_DATE ,CTL.REC_ONHAND QUANTITY_ONHAND ,CTL.UOM_CODE FROM CST_TRANSACTION_LAYERS CTL WHERE CTL.COST_TRANSACTION_TYPE = 'RECEIPT' AND CTL.REC_ONHAND_AVAIL_FLAG = 'Y'