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'
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 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 2490: v_select_clause := v_select_clause || 'blanket_number FROM oe_order_lines';

2486: 'order_quantity_uom,';
2487:
2488: IF x_Group_rec.setup_terms_rec.blanket_number IS NOT NULL THEN
2489: --
2490: v_select_clause := v_select_clause || 'blanket_number FROM oe_order_lines';
2491: --
2492: ELSE
2493: --
2494: v_select_clause := v_select_clause || 'NULL FROM oe_order_lines';

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

2490: v_select_clause := v_select_clause || 'blanket_number FROM oe_order_lines';
2491: --
2492: ELSE
2493: --
2494: v_select_clause := v_select_clause || 'NULL FROM oe_order_lines';
2495: --
2496: END IF;
2497:
2498: -- Mandatory Match Attributes

Line 7069: FROM oe_order_lines

7065: IS
7066:
7067: CURSOR c_PreHorizonDisp (x_OffsetDays NUMBER) IS
7068: SELECT line_id, rla_schedule_type_code
7069: FROM oe_order_lines
7070: WHERE header_id = x_Group_rec.order_header_id
7071: --global_atp
7072: AND ship_from_org_id =
7073: DECODE(g_ATP, k_ATP, ship_from_org_id,

Line 7093: v_line_num oe_order_lines.line_number%TYPE;

7089:
7090: v_Key_rec t_Key_rec;
7091: v_DeleteQty NUMBER;
7092: x_progress VARCHAR2(3) := '010';
7093: v_line_num oe_order_lines.line_number%TYPE;
7094:
7095: BEGIN
7096: --
7097: 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 7279: FROM oe_order_lines

7275: DECODE(rla_schedule_type_code,
7276: x_Group_rec.schedule_type_one, 1,
7277: x_Group_rec.schedule_type_two, 2,
7278: x_Group_rec.schedule_type_three, 3)) schedule_hierarchy
7279: FROM oe_order_lines
7280: WHERE header_id = x_Group_rec.order_header_id
7281: AND open_flag = 'Y' /*2263270*/
7282: --global_atp
7283: AND ship_from_org_id =

Line 7337: v_line_num oe_order_lines.line_number%type;

7333: v_line_id RLM_INTERFACE_LINES.LINE_ID%TYPE;
7334: c_consume_ref t_Cursor_ref;
7335: v_consume_line_tab t_consume_tab;
7336: x_progress VARCHAR2(3) := '010';
7337: v_line_num oe_order_lines.line_number%type;
7338: e_WrongSchedType EXCEPTION;
7339: c_OldDemand_rec t_OEDemand_rec;
7340: v_ATS_start_date DATE;
7341: v_NATS_start_date DATE;

Line 8387: FROM oe_order_lines

8383: --
8384: WHEN e_WrongSchedType THEN
8385: --
8386: SELECT line_number INTO v_line_num
8387: FROM oe_order_lines
8388: WHERE line_id = c_OldDemand_rec.line_id;
8389: --
8390: IF (l_debug <> -1) THEN
8391: rlm_core_sv.dlog(k_DEBUG,'line_id', c_OldDemand_rec.line_id);

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:

Line 10391: FROM oe_order_lines oel

10387:
10388: BEGIN
10389: SELECT SUM(nvl(ordered_quantity,0)) ,SUM(nvl(shipped_quantity,0))
10390: INTO v_total_ordered_qty, v_total_partial_shipped_qty
10391: FROM oe_order_lines oel
10392: WHERE oel.line_set_id IN
10393: (SELECT ol.line_set_id
10394: FROM oe_order_lines ol
10395: WHERE ol.line_id = v_line_id_tmp);

Line 10394: FROM oe_order_lines ol

10390: INTO v_total_ordered_qty, v_total_partial_shipped_qty
10391: FROM oe_order_lines oel
10392: WHERE oel.line_set_id IN
10393: (SELECT ol.line_set_id
10394: FROM oe_order_lines ol
10395: WHERE ol.line_id = v_line_id_tmp);
10396: --
10397: IF (l_debug <> -1) THEN
10398: rlm_core_sv.dlog(k_DEBUG,' Total Order Quantity', v_total_ordered_qty);