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 3391: rlm_interface_lines_all ril

3387: --ril.order_header_id,
3388: --ril.blanket_number
3389: --ril.cust_production_seq_num
3390: FROM rlm_interface_headers rih,
3391: rlm_interface_lines_all ril
3392: WHERE rih.header_id = x_Sched_rec.header_id
3393: AND rih.org_id = ril.org_id
3394: AND ril.header_id = rih.header_id
3395: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 3549: FROM rlm_interface_lines

3545: schedule_line_id,
3546: process_status,
3547: uom_code,
3548: cust_po_line_num
3549: FROM rlm_interface_lines
3550: WHERE header_id = x_Sched_rec.header_id
3551: AND ship_from_org_id = x_Group_rec.ship_from_org_id
3552: AND industry_attribute15 = x_Group_rec.industry_attribute15
3553: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 3648: FROM rlm_interface_lines

3644: schedule_line_id,
3645: process_status,
3646: uom_code,
3647: cust_po_line_num
3648: FROM rlm_interface_lines
3649: WHERE header_id = x_Sched_rec.header_id
3650: AND ship_from_org_id = x_Group_rec.ship_from_org_id
3651: AND industry_attribute15 = x_Group_rec.industry_attribute15
3652: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 3800: FROM rlm_interface_lines il,

3796: --
3797: --
3798: SELECT COUNT(*)
3799: INTO v_cumDiscrete
3800: FROM rlm_interface_lines il,
3801: rlm_schedule_lines_all sl
3802: WHERE il.header_id = x_Sched_rec.header_id
3803: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
3804: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id

Line 7332: v_newref_line_id RLM_INTERFACE_LINES.LINE_ID%TYPE;

7328: v_Qty_rec t_Qty_rec;
7329: v_qty NUMBER;
7330: v_consume_quantity NUMBER;
7331: v_newref_qty NUMBER;
7332: v_newref_line_id RLM_INTERFACE_LINES.LINE_ID%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';

Line 7333: v_line_id RLM_INTERFACE_LINES.LINE_ID%TYPE;

7329: v_qty NUMBER;
7330: v_consume_quantity NUMBER;
7331: v_newref_qty NUMBER;
7332: v_newref_line_id RLM_INTERFACE_LINES.LINE_ID%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;

Line 7433: FROM rlm_interface_lines_all -- Bug 5223933

7429: firm demand is never replaced by forecast data */
7430: --
7431: OPEN c_NewReq_ref FOR
7432: SELECT line_id, primary_quantity
7433: FROM rlm_interface_lines_all -- Bug 5223933
7434: WHERE header_id = x_Sched_rec.header_id
7435: --global_atp
7436: AND ship_from_org_id = x_Group_rec.ship_from_org_id
7437: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 7861: FROM rlm_interface_lines

7857: already and then consume the demand as it comes in. */
7858: --
7859: OPEN c_consume_ref FOR
7860: SELECT line_id, primary_quantity
7861: FROM rlm_interface_lines
7862: WHERE header_id = x_Sched_rec.header_id
7863: --global_atp
7864: AND ship_from_org_id = x_Group_rec.ship_from_org_id
7865: AND ship_to_org_id = x_Group_rec.ship_to_org_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 9089: 'FROM rlm_interface_lines r1 ';

9085: x_sched_rec.schedule_type ||''',''CUST'' item_identifier_type,'||
9086: 'r1.customer_item_ext,r1.agreement_id,r1.price_list_id,'||
9087: x_Sched_rec.schedule_header_id ||
9088: ',r1.schedule_line_id,r1.process_status,r1.uom_code,r1.cust_po_line_num,r1.blanket_number ' ||
9089: 'FROM rlm_interface_lines r1 ';
9090:
9091: --
9092: v_where_clause1 :=
9093:

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

10071: --Bug 3549475 jckwok
10072: --
10073: SELECT COUNT(*)
10074: INTO v_ActualCount
10075: FROM rlm_interface_lines il,
10076: rlm_schedule_lines_all sl
10077: WHERE il.header_id = x_Sched_rec.header_id
10078: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
10079: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id

Line 10096: FROM rlm_interface_lines

10092: IF (v_ActualCount > 0 ) THEN
10093: --
10094: SELECT TO_CHAR(TRUNC(min(request_date)), 'RRRR/MM/DD HH24:MI:SS')
10095: INTO v_min_horizon_date
10096: FROM rlm_interface_lines
10097: WHERE header_id=x_sched_rec.header_id
10098: AND inventory_item_id = x_group_rec.inventory_item_id
10099: AND customer_item_id = x_group_rec.customer_item_id
10100: AND Ship_from_org_id=x_group_rec.ship_from_org_id

Line 11741: x_line_id IN RLM_INTERFACE_LINES.LINE_ID%TYPE,

11737: FUNCTION IsLineConsumable
11738:
11739: ===========================================================================*/
11740: FUNCTION IsLineConsumable(x_consume_tab IN t_consume_tab,
11741: x_line_id IN RLM_INTERFACE_LINES.LINE_ID%TYPE,
11742: x_index OUT NOCOPY NUMBER)
11743: RETURN BOOLEAN
11744: IS
11745:

Line 11824: UPDATE rlm_interface_lines

11820: END IF;
11821: --
11822: IF x_UpdateLevel <> 'GROUP' THEN
11823: --
11824: UPDATE rlm_interface_lines
11825: SET process_status = x_Status
11826: WHERE header_id = x_header_id
11827: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
11828: rlm_core_sv.k_PS_FROZEN_FIRM)

Line 11844: UPDATE rlm_interface_lines

11840: IF (l_debug <> -1) THEN
11841: rlm_core_sv.dlog(k_DEBUG,'Update Group');
11842: END IF;
11843: --
11844: UPDATE rlm_interface_lines
11845: SET process_status = x_Status
11846: WHERE header_id = x_header_id
11847: AND ship_from_org_id = x_Group_rec.ship_from_org_id
11848: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 12089: FROM rlm_interface_lines_all

12085: x_progress VARCHAR2(3) := '010';
12086:
12087: CURSOR c IS
12088: SELECT *
12089: FROM rlm_interface_lines_all
12090: WHERE header_id = x_header_id
12091: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12092: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12093: AND customer_item_id = x_Group_rec.customer_item_id

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

12101: BEGIN
12102: --
12103: IF (l_debug <> -1) THEN
12104: rlm_core_sv.dpush(k_SDEBUG,'LockLines');
12105: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_LINES');
12106: END IF;
12107: --
12108: OPEN c;
12109: --

Line 12686: FROM rlm_interface_lines

12682: DECODE(x_Group_rec.match_within_rec.attribute12, 'Y', attribute12,NULL),
12683: DECODE(x_Group_rec.match_within_rec.attribute13, 'Y', attribute13,NULL),
12684: DECODE(x_Group_rec.match_within_rec.attribute14, 'Y', attribute14,NULL),
12685: DECODE(x_Group_rec.match_within_rec.attribute15, 'Y', attribute15,NULL)
12686: FROM rlm_interface_lines
12687: WHERE header_id = x_Sched_rec.header_id
12688: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12689: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12690: AND customer_item_id = x_Group_rec.customer_item_id

Line 13503: FROM rlm_interface_lines

13499: CURSOR c_LastReceipt IS
13500: SELECT start_date_time,
13501: item_detail_subtype,
13502: item_detail_ref_value_1
13503: FROM rlm_interface_lines
13504: WHERE header_id = x_Sched_rec.header_id
13505: AND ship_from_org_id = x_Group_rec.ship_from_org_id
13506: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13507: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 13523: FROM rlm_interface_lines

13519: CURSOR c_LastShipment IS
13520: SELECT start_date_time,
13521: item_detail_subtype,
13522: item_detail_ref_value_1
13523: FROM rlm_interface_lines
13524: WHERE header_id = x_Sched_rec.header_id
13525: AND ship_from_org_id = x_Group_rec.ship_from_org_id
13526: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13527: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 13770: rlm_interface_lines_all ril,

13766: rso.effective_start_date,
13767: ril.intrmd_ship_to_id, --Bugfix 5911991
13768: ril.intmed_ship_to_org_id --Bugfix 5911991
13769: FROM rlm_interface_headers rih,
13770: rlm_interface_lines_all ril,
13771: rlm_blanket_rso rso
13772: WHERE rih.header_id = x_Sched_rec.header_id
13773: AND rih.org_id = ril.org_id
13774: AND ril.header_id = rih.header_id

Line 14208: FROM rlm_interface_lines

14204: v_CUMQty,
14205: v_cum_key_record.cum_start_date,
14206: v_cum_key_record.cust_record_year,
14207: v_LineID
14208: FROM rlm_interface_lines
14209: WHERE header_id = x_Sched_rec.header_id
14210: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
14211: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
14212: AND ship_from_org_id = x_Group_rec.ship_from_org_id

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

15088: PROCEDURE NAME: AssignMatchAttribValues
15089:
15090: ===========================================================================*/
15091: -- Bug 4297984
15092: PROCEDURE AssignMatchAttribValues ( x_req_rec IN rlm_interface_lines_all%ROWTYPE,
15093: x_match_rec IN OUT NOCOPY RLM_RD_SV.t_generic_rec)
15094: IS
15095:
15096: BEGIN

Line 15168: FROM rlm_interface_lines

15164: item_detail_quantity,
15165: start_date_time,
15166: industry_attribute1 cust_record_year,
15167: line_id
15168: FROM rlm_interface_lines
15169: WHERE header_id = x_Sched_rec.header_id
15170: AND item_detail_type = RLM_MANAGE_DEMAND_SV.k_SHIP_RECEIPT_INFO
15171: AND item_detail_subtype = RLM_MANAGE_DEMAND_SV.k_CUM
15172: AND ship_from_org_id = x_Group_rec.ship_from_org_id