APPS.RLM_RD_SV dependencies on OE_ORDER_LINES_ALL

Line 248: FROM oe_order_lines_all

244: DECODE(rla_schedule_type_code,
245: x_Group_rec.schedule_type_one, 1,
246: x_Group_rec.schedule_type_two, 2,
247: x_Group_rec.schedule_type_three, 3) schedule_hierarchy
248: FROM oe_order_lines_all
249: WHERE header_id = x_Group_rec.order_header_id
250: AND open_flag = 'Y'
251: AND ship_from_org_id = DECODE(g_ATP, k_ATP, ship_from_org_id, x_Group_rec.ship_from_org_id)
252: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 2252: FROM oe_order_lines_all WHERE line_id = x_Key_rec.oe_line_id;

2248: ordered_item_id customer_item_id,inventory_item_id,header_id,
2249: ship_from_org_id,rla_schedule_type_code,authorized_to_ship_flag,
2250: ordered_quantity,ordered_item,item_identifier_type,item_type_code,
2251: customer_line_number,blanket_number
2252: FROM oe_order_lines_all WHERE line_id = x_Key_rec.oe_line_id;
2253:
2254: CURSOR c_order IS
2255: SELECT line_id,customer_production_line,customer_dock_code,request_date,
2256: schedule_ship_date,cust_po_number,item_revision customer_item_revision,

Line 2271: FROM oe_order_lines_all WHERE line_id = x_Key_rec.oe_line_id;

2267: ordered_item_id customer_item_id,inventory_item_id,header_id,
2268: ship_from_org_id,rla_schedule_type_code,authorized_to_ship_flag,
2269: ordered_quantity,ordered_item,item_identifier_type,item_type_code,
2270: customer_line_number,NULL
2271: FROM oe_order_lines_all WHERE line_id = x_Key_rec.oe_line_id;
2272:
2273: BEGIN
2274: --
2275: IF (l_debug <> -1) THEN

Line 7130: FROM oe_order_lines_all

7126: x_Group_rec.schedule_type_three)
7127: THEN
7128: --
7129: SELECT line_number INTO v_line_num
7130: FROM oe_order_lines_all
7131: WHERE line_id = c_PreHorizonDisp_rec.line_id;
7132: --
7133: rlm_message_sv.app_error(
7134: x_ExceptionLevel => rlm_message_sv.k_warn_level,

Line 9057: 'FROM oe_order_lines_all o,rlm_interface_lines r ';

9053: x_sched_rec.schedule_type ||''',''CUST'' item_identifier_type,'||
9054: 'r.customer_item_ext,r.agreement_id,r.price_list_id,'||
9055: x_Sched_rec.schedule_header_id ||
9056: ',r.schedule_line_id,r.process_status,r.uom_code,r.cust_po_line_num,r.blanket_number ' ||
9057: 'FROM oe_order_lines_all o,rlm_interface_lines r ';
9058:
9059: w_Select_Clause1 :=
9060:
9061: 'SELECT TO_NUMBER(NULL),TO_NUMBER(NULL),TO_CHAR(NULL),'||

Line 9956: 'FROM oe_order_lines_all o,rlm_interface_lines r ' ||

9952:
9953: -- subquery
9954: w_select_clause2 :=
9955: '(SELECT ''X'' ' ||
9956: 'FROM oe_order_lines_all o,rlm_interface_lines r ' ||
9957: v_where_clause1 ||
9958: v_where_clause2 ||
9959: ' AND r1.line_id = r.line_id) ';
9960:

Line 9978: 'FROM rlm_interface_lines r, oe_order_lines_all o ' ||

9974: v_where_clause2 ||
9975: ' UNION ALL ' || x_Sql2;
9976:
9977: x_Sum_Sql := 'SELECT r.line_id, SUM(NVL(o.ordered_quantity,0)-NVL(o.shipped_quantity,0)), COUNT(1), MIN(o.line_id) ' ||
9978: 'FROM rlm_interface_lines r, oe_order_lines_all o ' ||
9979: v_where_clause1 ||
9980: v_where_clause2 ||
9981: ' GROUP BY r.line_id ORDER BY line_id';
9982: