View: CSD_ACTUALS_FROM_WIP_V

Product:	CSD - Depot Repair
Description:	View to fetch all WIP jobs for Repair Order that are not shared and have the following statuses - Complete, Complete - No Charge and Closed.
Implementation/DBA Data:	APPS.CSD_ACTUALS_FROM_WIP_V

View Text

SELECT XREF.WIP_ENTITY_ID
, XREF.INVENTORY_ITEM_ID
, XREF.ORGANIZATION_ID
, XREF.REPAIR_LINE_ID
, WENT.WIP_ENTITY_NAME JOB_NAME
FROM CSD_REPAIR_JOB_XREF XREF
, WIP_ENTITIES WENT
, WIP_DISCRETE_JOBS DJOB
WHERE WENT.WIP_ENTITY_ID = XREF.WIP_ENTITY_ID
AND DJOB.WIP_ENTITY_ID = WENT.WIP_ENTITY_ID
AND DJOB.STATUS_TYPE IN (4
, 5
, 12)
AND XREF.WIP_ENTITY_ID NOT IN ( SELECT DISTINCT CRAL.ACTUAL_SOURCE_ID
FROM CSD_REPAIR_ACTUAL_LINES CRAL
, CSD_REPAIR_ACTUALS CRA
WHERE CRA.REPAIR_LINE_ID = XREF.REPAIR_LINE_ID
AND CRAL.REPAIR_ACTUAL_ID = CRA.REPAIR_ACTUAL_ID
AND CRAL.ACTUAL_SOURCE_CODE = 'WIP' )
AND NOT EXISTS ( SELECT 'X'
FROM CSD_REPAIR_JOB_XREF RJOB
WHERE RJOB.WIP_ENTITY_ID = XREF.WIP_ENTITY_ID HAVING COUNT(*) > 1 )

Columns