[Home] [Help]
182: and nvl(end_date_active, sysdate + 1);
183:
184: CURSOR c_req_header_name(c_auth_status_code VARCHAR2) IS
185: select meaning
186: from fnd_lookup_values
187: where lookup_type = 'AUTHORIZATION STATUS'
188: AND LOOKUP_CODE = NVL(c_auth_status_code,'INCOMPLETE')
189: AND LANGUAGE = USERENV('LANG')
190: and enabled_flag = 'Y'
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
1937: and dpt.action_type is null
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
2241: and dpt.repair_line_id = dra.repair_line_id
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
2543: and dpt.repair_line_id = dra.repair_line_id
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
2847: and dpt.repair_line_id = dra.repair_line_id
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
3151: and dpt.repair_line_id = dra.repair_line_id