[Home] [Help]
1571: CURSOR c_get_order_header_id(c_requisition_header_id NUMBER,
1572: c_repair_line_id NUMBER) IS
1573: SELECT distinct
1574: order_header_id
1575: FROM csd_product_transactions
1576: WHERE req_header_id = c_requisition_header_id and
1577: repair_line_id = c_repair_line_id;
1578:
1579: BEGIN
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
1624: dpt.action_type is null and
1625: dpt.req_header_id = porh.requisition_header_id and
1927: null status_id,
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
2230: null status_id,
2231: lv.lookup_code status_code
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
2532: null status_id,
2533: lv.lookup_code status_code
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
2836: null status_id,
2837: lv.lookup_code status_code
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
3140: null status_id,
3141: lv.lookup_code status_code
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
3446: from wsh_delivery_details wdd,
3447: wsh_delivery_assignments_v wda,
3448: wsh_new_deliveries wnd,
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