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 RLM_INTERFACE_LINES

Line 668: FROM rlm_interface_lines

664: WHEN e_SetupAPIFailed THEN
665: --
666: SELECT line_id
667: INTO v_InterfaceLineId
668: FROM rlm_interface_lines
669: WHERE header_id = x_Sched_rec.header_id
670: AND ship_from_org_id = x_Group_rec.ship_from_org_id
671: AND ship_to_address_id = x_Group_rec.ship_to_address_id
672: AND customer_item_id = x_Group_rec.customer_item_id

Line 3556: rlm_interface_lines_all ril

3552: --ril.order_header_id,
3553: --ril.blanket_number
3554: --ril.cust_production_seq_num
3555: FROM rlm_interface_headers rih,
3556: rlm_interface_lines_all ril
3557: WHERE rih.header_id = x_Sched_rec.header_id
3558: AND rih.org_id = ril.org_id
3559: AND ril.header_id = rih.header_id
3560: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 3714: FROM rlm_interface_lines

3710: schedule_line_id,
3711: process_status,
3712: uom_code,
3713: cust_po_line_num
3714: FROM rlm_interface_lines
3715: WHERE header_id = x_Sched_rec.header_id
3716: AND ship_from_org_id = x_Group_rec.ship_from_org_id
3717: AND industry_attribute15 = x_Group_rec.industry_attribute15
3718: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 3813: FROM rlm_interface_lines

3809: schedule_line_id,
3810: process_status,
3811: uom_code,
3812: cust_po_line_num
3813: FROM rlm_interface_lines
3814: WHERE header_id = x_Sched_rec.header_id
3815: AND ship_from_org_id = x_Group_rec.ship_from_org_id
3816: AND industry_attribute15 = x_Group_rec.industry_attribute15
3817: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 3965: FROM rlm_interface_lines il,

3961: --
3962: --
3963: SELECT COUNT(*)
3964: INTO v_cumDiscrete
3965: FROM rlm_interface_lines il,
3966: rlm_schedule_lines_all sl
3967: WHERE il.header_id = x_Sched_rec.header_id
3968: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
3969: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id

Line 7497: v_newref_line_id RLM_INTERFACE_LINES.LINE_ID%TYPE;

7493: v_Qty_rec t_Qty_rec;
7494: v_qty NUMBER;
7495: v_consume_quantity NUMBER;
7496: v_newref_qty NUMBER;
7497: v_newref_line_id RLM_INTERFACE_LINES.LINE_ID%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';

Line 7498: v_line_id RLM_INTERFACE_LINES.LINE_ID%TYPE;

7494: v_qty NUMBER;
7495: v_consume_quantity NUMBER;
7496: v_newref_qty NUMBER;
7497: v_newref_line_id RLM_INTERFACE_LINES.LINE_ID%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;

Line 7598: FROM rlm_interface_lines_all -- Bug 5223933

7594: firm demand is never replaced by forecast data */
7595: --
7596: OPEN c_NewReq_ref FOR
7597: SELECT line_id, primary_quantity
7598: FROM rlm_interface_lines_all -- Bug 5223933
7599: WHERE header_id = x_Sched_rec.header_id
7600: --global_atp
7601: AND ship_from_org_id = x_Group_rec.ship_from_org_id
7602: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 8029: FROM rlm_interface_lines

8025: already and then consume the demand as it comes in. */
8026: --
8027: OPEN c_consume_ref FOR
8028: SELECT line_id, primary_quantity
8029: FROM rlm_interface_lines
8030: WHERE header_id = x_Sched_rec.header_id
8031: --global_atp
8032: AND ship_from_org_id = x_Group_rec.ship_from_org_id
8033: AND ship_to_org_id = x_Group_rec.ship_to_org_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 9263: 'FROM rlm_interface_lines r1 ';

9259: x_sched_rec.schedule_type ||''',''CUST'' item_identifier_type,'||
9260: 'r1.customer_item_ext,r1.agreement_id,r1.price_list_id,'||
9261: x_Sched_rec.schedule_header_id ||
9262: ',r1.schedule_line_id,r1.process_status,r1.uom_code,r1.cust_po_line_num,r1.blanket_number ' ||
9263: 'FROM rlm_interface_lines r1 ';
9264:
9265: --
9266: v_where_clause1 :=
9267:

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 10249: FROM rlm_interface_lines il,

10245: --Bug 3549475 jckwok
10246: --
10247: SELECT COUNT(*)
10248: INTO v_ActualCount
10249: FROM rlm_interface_lines il,
10250: rlm_schedule_lines_all sl
10251: WHERE il.header_id = x_Sched_rec.header_id
10252: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
10253: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id

Line 10270: FROM rlm_interface_lines

10266: IF (v_ActualCount > 0 ) THEN
10267: --
10268: SELECT TO_CHAR(TRUNC(min(request_date)), 'RRRR/MM/DD HH24:MI:SS')
10269: INTO v_min_horizon_date
10270: FROM rlm_interface_lines
10271: WHERE header_id=x_sched_rec.header_id
10272: AND inventory_item_id = x_group_rec.inventory_item_id
10273: AND customer_item_id = x_group_rec.customer_item_id
10274: AND Ship_from_org_id=x_group_rec.ship_from_org_id

Line 11935: x_line_id IN RLM_INTERFACE_LINES.LINE_ID%TYPE,

11931: FUNCTION IsLineConsumable
11932:
11933: ===========================================================================*/
11934: FUNCTION IsLineConsumable(x_consume_tab IN t_consume_tab,
11935: x_line_id IN RLM_INTERFACE_LINES.LINE_ID%TYPE,
11936: x_index OUT NOCOPY NUMBER)
11937: RETURN BOOLEAN
11938: IS
11939:

Line 12018: UPDATE rlm_interface_lines

12014: END IF;
12015: --
12016: IF x_UpdateLevel <> 'GROUP' THEN
12017: --
12018: UPDATE rlm_interface_lines
12019: SET process_status = x_Status
12020: WHERE header_id = x_header_id
12021: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
12022: rlm_core_sv.k_PS_FROZEN_FIRM)

Line 12038: UPDATE rlm_interface_lines

12034: IF (l_debug <> -1) THEN
12035: rlm_core_sv.dlog(k_DEBUG,'Update Group');
12036: END IF;
12037: --
12038: UPDATE rlm_interface_lines
12039: SET process_status = x_Status
12040: WHERE header_id = x_header_id
12041: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12042: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 12283: FROM rlm_interface_lines_all

12279: x_progress VARCHAR2(3) := '010';
12280:
12281: CURSOR c IS
12282: SELECT *
12283: FROM rlm_interface_lines_all
12284: WHERE header_id = x_header_id
12285: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12286: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12287: AND customer_item_id = x_Group_rec.customer_item_id

Line 12299: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_LINES');

12295: BEGIN
12296: --
12297: IF (l_debug <> -1) THEN
12298: rlm_core_sv.dpush(k_SDEBUG,'LockLines');
12299: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_LINES');
12300: END IF;
12301: --
12302: OPEN c;
12303: --

Line 12880: FROM rlm_interface_lines

12876: DECODE(x_Group_rec.match_within_rec.attribute12, 'Y', attribute12,NULL),
12877: DECODE(x_Group_rec.match_within_rec.attribute13, 'Y', attribute13,NULL),
12878: DECODE(x_Group_rec.match_within_rec.attribute14, 'Y', attribute14,NULL),
12879: DECODE(x_Group_rec.match_within_rec.attribute15, 'Y', attribute15,NULL)
12880: FROM rlm_interface_lines
12881: WHERE header_id = x_Sched_rec.header_id
12882: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12883: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12884: AND customer_item_id = x_Group_rec.customer_item_id

Line 13697: FROM rlm_interface_lines

13693: CURSOR c_LastReceipt IS
13694: SELECT start_date_time,
13695: item_detail_subtype,
13696: item_detail_ref_value_1
13697: FROM rlm_interface_lines
13698: WHERE header_id = x_Sched_rec.header_id
13699: AND ship_from_org_id = x_Group_rec.ship_from_org_id
13700: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13701: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 13717: FROM rlm_interface_lines

13713: CURSOR c_LastShipment IS
13714: SELECT start_date_time,
13715: item_detail_subtype,
13716: item_detail_ref_value_1
13717: FROM rlm_interface_lines
13718: WHERE header_id = x_Sched_rec.header_id
13719: AND ship_from_org_id = x_Group_rec.ship_from_org_id
13720: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13721: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 13964: rlm_interface_lines_all ril,

13960: rso.effective_start_date,
13961: ril.intrmd_ship_to_id, --Bugfix 5911991
13962: ril.intmed_ship_to_org_id --Bugfix 5911991
13963: FROM rlm_interface_headers rih,
13964: rlm_interface_lines_all ril,
13965: rlm_blanket_rso rso
13966: WHERE rih.header_id = x_Sched_rec.header_id
13967: AND rih.org_id = ril.org_id
13968: AND ril.header_id = rih.header_id

Line 14402: FROM rlm_interface_lines

14398: v_CUMQty,
14399: v_cum_key_record.cum_start_date,
14400: v_cum_key_record.cust_record_year,
14401: v_LineID
14402: FROM rlm_interface_lines
14403: WHERE header_id = x_Sched_rec.header_id
14404: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
14405: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
14406: AND ship_from_org_id = x_Group_rec.ship_from_org_id

Line 15286: PROCEDURE AssignMatchAttribValues ( x_req_rec IN rlm_interface_lines_all%ROWTYPE,

15282: PROCEDURE NAME: AssignMatchAttribValues
15283:
15284: ===========================================================================*/
15285: -- Bug 4297984
15286: PROCEDURE AssignMatchAttribValues ( x_req_rec IN rlm_interface_lines_all%ROWTYPE,
15287: x_match_rec IN OUT NOCOPY RLM_RD_SV.t_generic_rec)
15288: IS
15289:
15290: BEGIN

Line 15362: FROM rlm_interface_lines

15358: item_detail_quantity,
15359: start_date_time,
15360: industry_attribute1 cust_record_year,
15361: line_id
15362: FROM rlm_interface_lines
15363: WHERE header_id = x_Sched_rec.header_id
15364: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
15365: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
15366: AND ship_from_org_id = x_Group_rec.ship_from_org_id