CST_WO_ONHAND_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
WIP_REC_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID CST_WORK_ORDER_ID CST_WORK_ORDER_OPERATION_ID OPERATION_SEQ_NUMBER TRANSACTION_DATE WIP_ITEM_TYPE QUANTITY_ONHAND UOM_CODE

Query

SQL_Statement

SELECT CWTL.WIP_REC_TRXN_ID , CWTL.COST_ORG_ID , CWTL.COST_BOOK_ID , CWTL.INVENTORY_ITEM_ID , CWTL.CST_WORK_ORDER_ID , CWTL.CST_WORK_ORDER_OPERATION_ID , CWTL.OPERATION_SEQ_NUMBER , CT.TRANSACTION_DATE, DECODE(CTSA.EXTERNAL_TXN_TYPE, 'WIP_MATERIAL_ISSUE', 'COMPONENT', 'WIP_NEGATIVE_ISSUE', 'NEG_COMPONENT', 'PRODUCT') WIP_ITEM_TYPE, SUM (CWTL.QUANTITY) QUANTITY_ONHAND , CWTL.UOM_CODE FROM CST_WO_TRANSACTION_LAYERS CWTL, CST_TRANSACTIONS CT, CST_TXN_SOURCE_ACTIONS CTSA WHERE CTSA.EXTERNAL_TXN_TYPE IN ('WIP_MATERIAL_ISSUE', 'WIP_PRODUCT_COMPLETION', 'WIP_NEGATIVE_ISSUE') AND CT.BASE_TXN_SOURCE_TYPE_ID = CTSA.BASE_TXN_SOURCE_TYPE_ID AND CT.BASE_TXN_ACTION_ID = CTSA.BASE_TXN_ACTION_ID AND CT.TRANSACTION_ID = CWTL.WIP_REC_TRXN_ID GROUP BY CWTL.COST_ORG_ID, CWTL.COST_BOOK_ID, CWTL.WIP_REC_TRXN_ID, CWTL.INVENTORY_ITEM_ID, CWTL.CST_WORK_ORDER_ID, CWTL.CST_WORK_ORDER_OPERATION_ID, CWTL.OPERATION_SEQ_NUMBER, CT.TRANSACTION_DATE, DECODE(CTSA.EXTERNAL_TXN_TYPE, 'WIP_MATERIAL_ISSUE', 'COMPONENT', 'WIP_NEGATIVE_ISSUE', 'NEG_COMPONENT', 'PRODUCT'), CWTL.UOM_CODE