400: csd_repairs dra,
401: wip_discrete_jobs wdj,
402: wip_entities we,
403: ORG_ORGANIZATION_DEFINITIONS orgd,
404: csd_repair_job_xref xref
405: where
406: xref.wip_entity_id = wdj.wip_entity_id and
407: xref.wip_entity_id = we.wip_entity_id and
408: xref.repair_line_id = dra.repair_line_id and
1296: from
1297: csd_repairs dra,
1298: wip_entities we,
1299: po_requisition_headers_all porh,
1300: csd_repair_job_xref xref,
1301: po_requisition_lines_all porl
1302: where
1303: dra.repair_line_id = xref.repair_line_id and
1304: porh.type_lookup_code = 'PURCHASE' and