VIEW: APPS.CSD_ACTUALS_FROM_WIP_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )