APPS.QA_PLAN_ELEMENT_API dependencies on OE_ORDER_HEADERS_ALL

Line 1263: FROM oe_order_headers_all oeh,

1259: */
1260:
1261: CURSOR c (h_id IN VARCHAR2) IS
1262: SELECT oel.line_id
1263: FROM oe_order_headers_all oeh,
1264: oe_order_lines_all oel,
1265: mtl_sales_orders mso,
1266: oe_transaction_types_tl ot
1267: WHERE mso.segment1 = oeh.order_number

Line 2955: 'from oe_order_lines_all oel, oe_order_headers_all oeha '||

2951: -- x_ref := NULL;
2952: wild := value;
2953: sql_string := 'select distinct to_char(oel.line_number) ,''Sales Order: ''|| '||
2954: 'oeha.order_number || '';'' || ''Item: '' || oel.ordered_item description '||
2955: 'from oe_order_lines_all oel, oe_order_headers_all oeha '||
2956: 'where oel.header_id = oeha.header_id '||
2957: 'and oeha.order_number = :1 ' ||
2958: 'and to_char(oel.line_number) like :2 ' ||
2959: 'order by description, line_number ';