eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_RD_SV dependencies on OE_ORDER_LINES

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 816: FROM oe_order_lines

812: IS
813:
814: CURSOR c_PreHorizonNATS IS
815: SELECT line_id
816: FROM oe_order_lines
817: WHERE header_id = x_Group_rec.order_header_id
818: --global_atp
819: AND ship_from_org_id =
820: DECODE(g_ATP, k_ATP, ship_from_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 2655: v_select_clause := v_select_clause || 'blanket_number FROM oe_order_lines';

2651: 'order_quantity_uom,';
2652:
2653: IF x_Group_rec.setup_terms_rec.blanket_number IS NOT NULL THEN
2654: --
2655: v_select_clause := v_select_clause || 'blanket_number FROM oe_order_lines';
2656: --
2657: ELSE
2658: --
2659: v_select_clause := v_select_clause || 'NULL FROM oe_order_lines';

Line 2659: v_select_clause := v_select_clause || 'NULL FROM oe_order_lines';

2655: v_select_clause := v_select_clause || 'blanket_number FROM oe_order_lines';
2656: --
2657: ELSE
2658: --
2659: v_select_clause := v_select_clause || 'NULL FROM oe_order_lines';
2660: --
2661: END IF;
2662:
2663: -- Mandatory Match Attributes

Line 7234: FROM oe_order_lines

7230: IS
7231:
7232: CURSOR c_PreHorizonDisp (x_OffsetDays NUMBER) IS
7233: SELECT line_id, rla_schedule_type_code
7234: FROM oe_order_lines
7235: WHERE header_id = x_Group_rec.order_header_id
7236: --global_atp
7237: AND ship_from_org_id =
7238: DECODE(g_ATP, k_ATP, ship_from_org_id,

Line 7258: v_line_num oe_order_lines.line_number%TYPE;

7254:
7255: v_Key_rec t_Key_rec;
7256: v_DeleteQty NUMBER;
7257: x_progress VARCHAR2(3) := '010';
7258: v_line_num oe_order_lines.line_number%TYPE;
7259:
7260: BEGIN
7261: --
7262: 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 7444: FROM oe_order_lines

7440: DECODE(rla_schedule_type_code,
7441: x_Group_rec.schedule_type_one, 1,
7442: x_Group_rec.schedule_type_two, 2,
7443: x_Group_rec.schedule_type_three, 3)) schedule_hierarchy
7444: FROM oe_order_lines
7445: WHERE header_id = x_Group_rec.order_header_id
7446: AND open_flag = 'Y' /*2263270*/
7447: --global_atp
7448: AND ship_from_org_id =

Line 7502: v_line_num oe_order_lines.line_number%type;

7498: v_line_id RLM_INTERFACE_LINES.LINE_ID%TYPE;
7499: c_consume_ref t_Cursor_ref;
7500: v_consume_line_tab t_consume_tab;
7501: x_progress VARCHAR2(3) := '010';
7502: v_line_num oe_order_lines.line_number%type;
7503: e_WrongSchedType EXCEPTION;
7504: c_OldDemand_rec t_OEDemand_rec;
7505: v_ATS_start_date DATE;
7506: v_NATS_start_date DATE;

Line 8561: FROM oe_order_lines

8557: --
8558: WHEN e_WrongSchedType THEN
8559: --
8560: SELECT line_number INTO v_line_num
8561: FROM oe_order_lines
8562: WHERE line_id = c_OldDemand_rec.line_id;
8563: --
8564: IF (l_debug <> -1) THEN
8565: rlm_core_sv.dlog(k_DEBUG,'line_id', c_OldDemand_rec.line_id);

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:

Line 10565: FROM oe_order_lines oel

10561:
10562: BEGIN
10563: SELECT SUM(nvl(ordered_quantity,0)) ,SUM(nvl(shipped_quantity,0))
10564: INTO v_total_ordered_qty, v_total_partial_shipped_qty
10565: FROM oe_order_lines oel
10566: WHERE oel.line_set_id IN
10567: (SELECT ol.line_set_id
10568: FROM oe_order_lines ol
10569: WHERE ol.line_id = v_line_id_tmp);

Line 10568: FROM oe_order_lines ol

10564: INTO v_total_ordered_qty, v_total_partial_shipped_qty
10565: FROM oe_order_lines oel
10566: WHERE oel.line_set_id IN
10567: (SELECT ol.line_set_id
10568: FROM oe_order_lines ol
10569: WHERE ol.line_id = v_line_id_tmp);
10570: --
10571: IF (l_debug <> -1) THEN
10572: rlm_core_sv.dlog(k_DEBUG,' Total Order Quantity', v_total_ordered_qty);