View: CSI_WIP_ASSEMBLIES_V

Product:	CSI - Install Base
Description:
Implementation/DBA Data:	APPS.CSI_WIP_ASSEMBLIES_V

View Text

SELECT CTL .INSTANCE_ID INSTANCE_ID
, CTL.QUANTITY QUANTITY
, CTL.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CTL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CTL.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CTL.SERIAL_NUMBER SERIAL_NUMBER
, CTL.LOT_NUMBER LOT_NUMBER
, CTL.INSTANCE_STATUS_ID INSTANCE_STATUS_ID
, CTL.LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, CTL.LOCATION_ID LOCATION_ID
, CTT.SOURCE_TRANSACTION_ID LAST_WIP_JOB_ID
, CTL.CREATED_BY CREATED_BY
, CTL.CREATION_DATE CREATION_DATE
, CTL.LAST_UPDATED_BY LAST_UPDATED_BY
, CTL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CTL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CTL.MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG
, CTL.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, CTL.SOURCE_TRANSACTION_FLAG SOURCE_TRANSACTION_FLAG
, CTL.PROCESSING_STATUS PROCESSING_STATUS
, CTL.TRANSACTION_LINE_ID TRANSACTION_LINE_ID
, CTL.TXN_LINE_DETAIL_ID TXN_LINE_DETAIL_ID
FROM CSI_T_TRANSACTION_LINES CTT
, CSI_T_TXN_LINE_DETAILS CTL
WHERE CTT.TRANSACTION_LINE_ID = CTL.TRANSACTION_LINE_ID
AND CTT.SOURCE_TRANSACTION_TABLE = 'WIP_ENTITIES'
AND CTL.SOURCE_TRANSACTION_FLAG = 'Y' UNION SELECT INSTANCE_ID INSTANCE_ID
, QUANTITY QUANTITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LAST_VLD_ORGANIZATION_ID INV_ORGANIZATION_ID
, SERIAL_NUMBER SERIAL_NUMBER
, LOT_NUMBER LOT_NUMBER
, INSTANCE_STATUS_ID INSTANCE_STATUS_ID
, LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, LOCATION_ID LOCATION_ID
, LAST_WIP_JOB_ID LAST_WIP_JOB_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, 'Y' SOURCE_TRANSACTION_FLAG
, TO_CHAR(NULL) PROCESSING_STATUS
, TO_NUMBER(NULL) TRANSACTION_LINE_ID
, TO_NUMBER(NULL) TXN_LINE_DETAIL_ID
FROM CSI_ITEM_INSTANCES CII
WHERE NOT EXISTS (SELECT 'X'
FROM CSI_T_TXN_LINE_DETAILS CTT
, CSI_T_TRANSACTION_LINES CTL
WHERE CTT.TRANSACTION_LINE_ID = CTL.TRANSACTION_LINE_ID
AND CTL.SOURCE_TRANSACTION_TABLE = 'WIP_ENTITIES' AND CTL.SOURCE_TRANSACTION_ID = CII.LAST_WIP_JOB_ID
AND CTT.SOURCE_TRANSACTION_FLAG = 'Y'
AND CTT.INSTANCE_ID = CII.INSTANCE_ID)

Columns