[Home] [Help]
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
1411:
1412: CURSOR C(v VARCHAR2) IS
1413: SELECT sh.header_id
1414: FROM so_order_types sot,
1415: oe_order_headers sh,
1416: qa_customers_lov_v rc
1417: WHERE sh.order_type_id = sot.order_type_id and
1418: sh.sold_to_org_id = rc.customer_id and
1419: sh.order_category_code in ('RETURN', 'MIXED') and
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 ';
3140: wild := value;
3141:
3142: sql_string := 'SELECT sh.order_number, sot.name
3143: FROM so_order_types sot,
3144: oe_order_headers sh,
3145: qa_customers_lov_v rc
3146: WHERE sh.order_type_id = sot.order_type_id and
3147: sh.sold_to_org_id = rc.customer_id and
3148: sh.order_category_code in (''RETURN'', ''MIXED'') and
3171: wild := value;
3172:
3173: sql_string := 'select distinct to_char(oel.line_number),
3174: ''RMA Number: '' || sh.order_number || '';'' || ''Item: '' || oel.ordered_item description
3175: from oe_order_lines oel, so_order_types sot, oe_order_headers sh
3176: where sh.order_type_id = sot.order_type_id and oel.header_id = sh.header_id and
3177: oel.line_category_code in (''RETURN'', ''MIXED'') and
3178: sh.order_number = :1 and
3179: to_char(oel.line_number) like :2