VIEW: APPS.CSD_ESTIMATES_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 (1,3) AND XREF.wip_entity_id NOT IN ( SELECT DISTINCT CREL.est_line_source_id1 FROM CSD_REPAIR_ESTIMATE_LINES CREL, CSD_REPAIR_ESTIMATE CRE WHERE CRE.repair_line_id = XREF.repair_line_id AND CREL.repair_estimate_id = CRE.repair_estimate_id AND CREL.est_line_source_type_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 (1
, 3)
AND XREF.WIP_ENTITY_ID NOT IN ( SELECT DISTINCT CREL.EST_LINE_SOURCE_ID1
FROM CSD_REPAIR_ESTIMATE_LINES CREL
, CSD_REPAIR_ESTIMATE CRE
WHERE CRE.REPAIR_LINE_ID = XREF.REPAIR_LINE_ID
AND CREL.REPAIR_ESTIMATE_ID = CRE.REPAIR_ESTIMATE_ID
AND CREL.EST_LINE_SOURCE_TYPE_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 )