[Home] [Help]
396: wdj.status_type status_id,
397: null status_code,
398: we.organization_id org_id
399: from
400: csd_repairs dra,
401: wip_discrete_jobs wdj,
402: wip_entities we,
403: ORG_ORGANIZATION_DEFINITIONS orgd,
404: csd_repair_job_xref xref
694: 'SR' document_type,
695: inc.incident_status_id status_id,
696: null status_code
697: from
698: csd_repairs dra,
699: ORG_ORGANIZATION_DEFINITIONS orgd,
700: cs_incidents_all_b inc
701: where
702: dra.incident_id = inc.incident_id and
990: null status_code
991: from cs_sr_tasks_v tsk,
992: cs_incidents_all_b inc,
993: ORG_ORGANIZATION_DEFINITIONS orgd,
994: csd_repairs dra
995: where
996: tsk.source_object_type_code = 'SR' and
997: dra.incident_id = inc.incident_id and
998: dra.incident_id = tsk.source_object_id and
1293: 'PR' document_type,
1294: null status_id,
1295: porh.authorization_status status_code
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
1615: 'IR' document_type,
1616: null status_id,
1617: porh.authorization_status status_code
1618: from
1619: csd_repairs dra,
1620: po_requisition_headers_all porh,
1621: csd_product_transactions dpt
1622: where
1623: dra.repair_line_id = dpt.repair_line_id and
1928: lv.lookup_code status_code
1929: from oe_order_lines_all oel,
1930: oe_order_headers_all oeh,
1931: csd_product_transactions dpt,
1932: csd_repairs dra,
1933: fnd_lookup_values lv
1934: where oeh.header_id = oel.header_id
1935: and dpt.order_line_id = oel.line_id
1936: and dpt.repair_line_id = dra.repair_line_id
2232: from oe_order_lines_all oel,
2233: oe_order_headers_all oeh,
2234: csd_product_transactions dpt,
2235: cs_estimate_details edt,
2236: csd_repairs dra,
2237: fnd_lookup_values lv
2238: where oeh.header_id = oel.header_id
2239: and dpt.estimate_detail_id = edt.estimate_detail_id
2240: and edt.order_line_id = oel.line_id
2534: from oe_order_lines_all oel,
2535: oe_order_headers_all oeh,
2536: csd_product_transactions dpt,
2537: cs_estimate_details edt,
2538: csd_repairs dra,
2539: fnd_lookup_values lv
2540: where oeh.header_id = oel.header_id
2541: and dpt.estimate_detail_id = edt.estimate_detail_id
2542: and edt.order_line_id = oel.line_id
2838: from oe_order_lines_all oel,
2839: oe_order_headers_all oeh,
2840: csd_product_transactions dpt,
2841: cs_estimate_details edt,
2842: csd_repairs dra,
2843: fnd_lookup_values lv
2844: where oeh.header_id = oel.header_id
2845: and dpt.estimate_detail_id = edt.estimate_detail_id
2846: and edt.order_line_id = oel.line_id
3142: from oe_order_lines_all oel,
3143: oe_order_headers_all oeh,
3144: csd_product_transactions dpt,
3145: cs_estimate_details edt,
3146: csd_repairs dra,
3147: fnd_lookup_values lv
3148: where oeh.header_id = oel.header_id
3149: and dpt.estimate_detail_id = edt.estimate_detail_id
3150: and edt.order_line_id = oel.line_id
3449: oe_order_lines_all oel,
3450: csd_product_transactions dpt,
3451: cs_estimate_details edt,
3452: ORG_ORGANIZATION_DEFINITIONS orgd,
3453: csd_repairs dra
3454: where
3455: oel.line_id = wdd.source_line_id AND
3456: wdd.delivery_detail_id = wda.delivery_detail_id AND
3457: wdd.source_code = 'OE' AND