DBA Data[Home] [Help]

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' --Bugfix 12771425
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 2417: FROM oe_order_lines_all WHERE line_id = x_Key_rec.oe_line_id;

2413: ordered_item_id customer_item_id,inventory_item_id,header_id,
2414: ship_from_org_id,rla_schedule_type_code,authorized_to_ship_flag,
2415: ordered_quantity,ordered_item,item_identifier_type,item_type_code,
2416: customer_line_number,blanket_number
2417: FROM oe_order_lines_all WHERE line_id = x_Key_rec.oe_line_id;
2418:
2419: CURSOR c_order IS
2420: SELECT line_id,customer_production_line,customer_dock_code,request_date,
2421: schedule_ship_date,cust_po_number,item_revision customer_item_revision,

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

2432: ordered_item_id customer_item_id,inventory_item_id,header_id,
2433: ship_from_org_id,rla_schedule_type_code,authorized_to_ship_flag,
2434: ordered_quantity,ordered_item,item_identifier_type,item_type_code,
2435: customer_line_number,NULL
2436: FROM oe_order_lines_all WHERE line_id = x_Key_rec.oe_line_id;
2437:
2438: BEGIN
2439: --
2440: IF (l_debug <> -1) THEN

Line 7295: FROM oe_order_lines_all

7291: x_Group_rec.schedule_type_three)
7292: THEN
7293: --
7294: SELECT line_number INTO v_line_num
7295: FROM oe_order_lines_all
7296: WHERE line_id = c_PreHorizonDisp_rec.line_id;
7297: --
7298: rlm_message_sv.app_error(
7299: x_ExceptionLevel => rlm_message_sv.k_warn_level,

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

9227: x_sched_rec.schedule_type ||''',''CUST'' item_identifier_type,'||
9228: 'r.customer_item_ext,r.agreement_id,r.price_list_id,'||
9229: x_Sched_rec.schedule_header_id ||
9230: ',r.schedule_line_id,r.process_status,r.uom_code,r.cust_po_line_num,r.blanket_number ' ||
9231: 'FROM oe_order_lines_all o,rlm_interface_lines r ';
9232:
9233: w_Select_Clause1 :=
9234:
9235: 'SELECT TO_NUMBER(NULL),TO_NUMBER(NULL),TO_CHAR(NULL),'||

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

10126:
10127: -- subquery
10128: w_select_clause2 :=
10129: '(SELECT ''X'' ' ||
10130: 'FROM oe_order_lines_all o,rlm_interface_lines r ' ||
10131: v_where_clause1 ||
10132: v_where_clause2 ||
10133: ' AND r1.line_id = r.line_id) ';
10134:

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

10148: v_where_clause2 ||
10149: ' UNION ALL ' || x_Sql2;
10150:
10151: x_Sum_Sql := 'SELECT r.line_id, SUM(NVL(o.ordered_quantity,0)-NVL(o.shipped_quantity,0)), COUNT(1), MIN(o.line_id) ' ||
10152: 'FROM rlm_interface_lines r, oe_order_lines_all o ' ||
10153: v_where_clause1 ||
10154: v_where_clause2 ||
10155: ' GROUP BY r.line_id ORDER BY line_id';
10156: