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_MANAGE_DEMAND_SV dependencies on RLM_INTERFACE_LINES

Line 319: FROM rlm_interface_lines il

315: AND ship_to_address_id = x_Group_rec.ship_to_address_id --Bugfix 12863728
316: AND customer_item_id = x_Group_rec.customer_item_id --Bugfix 12863728
317: AND line_id IN (
318: SELECT schedule_line_id
319: FROM rlm_interface_lines il
320: WHERE il.header_id = x_sched_rec.header_id
321: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
322: AND il.ship_to_address_id = x_Group_rec.ship_to_address_id
323: AND il.customer_item_id = x_Group_rec.customer_item_id

Line 342: FROM rlm_interface_lines il

338: AND ship_to_address_id = x_Group_rec.ship_to_address_id --Bugfix 12863728
339: AND customer_item_id = x_Group_rec.customer_item_id --Bugfix 12863728
340: AND line_id IN (
341: SELECT schedule_line_id
342: FROM rlm_interface_lines il
343: WHERE il.header_id = x_sched_rec.header_id
344: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
345: AND il.ship_to_address_id = x_Group_rec.ship_to_address_id
346: AND il.customer_item_id = x_Group_rec.customer_item_id

Line 422: FROM rlm_interface_lines

418: start_date_time,
419: industry_attribute1 cust_record_year,
420: line_id,
421: k_TRUE
422: FROM rlm_interface_lines
423: WHERE header_id = x_Sched_rec.header_id
424: AND item_detail_type = k_SHIP_RECEIPT_INFO
425: AND item_detail_subtype IN (k_SHIPMENT, k_RECEIPT)
426: AND ship_to_address_id = x_Group_rec.ship_to_address_id

Line 507: FROM rlm_interface_lines

503: start_date_time,
504: industry_attribute1 cust_record_year,
505: line_id,
506: k_TRUE
507: FROM rlm_interface_lines
508: WHERE header_id = x_Sched_rec.header_id
509: AND item_detail_type = k_SHIP_RECEIPT_INFO
510: AND item_detail_subtype = k_CUM
511: AND ship_from_org_id = x_Group_rec.ship_from_org_id

Line 644: FROM rlm_interface_lines_all

640: IS
641: --
642: CURSOR c_Demand IS
643: SELECT *
644: FROM rlm_interface_lines_all
645: WHERE header_id = x_Sched_rec.header_id
646: AND ship_from_org_id = x_Group_rec.ship_from_org_id
647: AND ship_to_address_id = x_Group_rec.ship_to_address_id
648: AND customer_item_id = x_Group_rec.customer_item_id

Line 657: FROM rlm_interface_lines_all

653: ORDER BY START_DATE_TIME;
654:
655: CURSOR c_DemandCum IS
656: SELECT *
657: FROM rlm_interface_lines_all
658: WHERE header_id = x_Sched_rec.header_id
659: AND ship_from_org_id = x_Group_rec.ship_from_org_id
660: AND ship_to_address_id = x_Group_rec.ship_to_address_id
661: AND customer_item_id = x_Group_rec.customer_item_id

Line 669: v_Demand_rec rlm_interface_lines%ROWTYPE;

665: AND process_status = rlm_core_sv.k_PS_AVAILABLE
666: ORDER BY START_DATE_TIME;
667:
668: --
669: v_Demand_rec rlm_interface_lines%ROWTYPE;
670: v_Count NUMBER := 1;
671: v_Progress VARCHAR2(3) := '010';
672: --
673: BEGIN

Line 1069: FROM rlm_interface_lines

1065: BEGIN
1066: --
1067: SELECT line_id
1068: INTO v_InterfaceLineId
1069: FROM rlm_interface_lines
1070: WHERE header_id = x_Sched_rec.header_id
1071: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1072: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1073: AND customer_item_id = x_Group_rec.customer_item_id

Line 1118: FROM rlm_interface_lines

1114: BEGIN
1115: --
1116: SELECT line_id
1117: INTO v_InterfaceLineId
1118: FROM rlm_interface_lines
1119: WHERE header_id = x_Sched_rec.header_id
1120: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1121: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1122: AND customer_item_id = x_Group_rec.customer_item_id

Line 1167: FROM rlm_interface_lines

1163: BEGIN
1164: --
1165: SELECT line_id
1166: INTO v_InterfaceLineId
1167: FROM rlm_interface_lines
1168: WHERE header_id = x_Sched_rec.header_id
1169: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1170: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1171: AND customer_item_id = x_Group_rec.customer_item_id

Line 1212: FROM rlm_interface_lines

1208: BEGIN
1209: --
1210: SELECT line_id
1211: INTO v_InterfaceLineId
1212: FROM rlm_interface_lines
1213: WHERE header_id = x_Sched_rec.header_id
1214: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1215: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1216: AND customer_item_id = x_Group_rec.customer_item_id

Line 1269: FROM rlm_interface_lines

1265: BEGIN
1266: --
1267: SELECT line_id
1268: INTO v_InterfaceLineId
1269: FROM rlm_interface_lines
1270: WHERE header_id = x_Sched_rec.header_id
1271: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1272: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1273: AND customer_item_id = x_Group_rec.customer_item_id

Line 1359: PROCEDURE SetOperation(x_ManageDemand_rec IN OUT NOCOPY rlm_interface_lines%ROWTYPE,

1355: PROCEDURE NAME: SetOperation
1356:
1357: ===========================================================================*/
1358:
1359: PROCEDURE SetOperation(x_ManageDemand_rec IN OUT NOCOPY rlm_interface_lines%ROWTYPE,
1360: x_Operation IN NUMBER)
1361: IS
1362: --
1363: v_Progress VARCHAR2(3) :='010';

Line 1395: SELECT rlm_interface_lines_s.nextval

1391: THEN
1392: x_ManageDemand_rec.program_id := x_Operation;
1393: END IF;
1394: ELSIF x_Operation = k_INSERT THEN
1395: SELECT rlm_interface_lines_s.nextval
1396: INTO x_ManageDemand_rec.line_id
1397: FROM DUAL;
1398: x_ManageDemand_rec.program_id := x_Operation;
1399: END IF;

Line 4160: PROCEDURE DeleteReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)

4156: PROCEDURE NAME: DeleteReq
4157:
4158: ===========================================================================*/
4159:
4160: PROCEDURE DeleteReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)
4161: IS
4162:
4163: i NUMBER;
4164: v_Progress VARCHAR2(3) := '010';

Line 4173: DELETE rlm_interface_lines

4169: rlm_core_sv.dpush(C_SDEBUG,'DeleteReq');
4170: rlm_core_sv.dlog(C_DEBUG,'x_ManageDemand_rec.line_id',x_ManageDemand_rec.line_id);
4171: END IF;
4172: --
4173: DELETE rlm_interface_lines
4174: WHERE line_id = x_ManageDemand_rec.line_id;
4175: --
4176: -- JAUTOMO: The interface_line_id should be updated with the
4177: -- the line id of new lines created by SDP, Sourcing Rules,

Line 4210: PROCEDURE InsertReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)

4206: PROCEDURE NAME: InsertReq
4207:
4208: ===========================================================================*/
4209:
4210: PROCEDURE InsertReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)
4211: IS
4212: --
4213: v_Progress VARCHAR2(3) := '010';
4214: e_NullOrgId EXCEPTION;

Line 4241: INSERT INTO rlm_interface_lines_all(

4237: IF x_ManageDemand_rec.org_id IS NULL THEN
4238: RAISE e_NullOrgId;
4239: END IF;
4240: --
4241: INSERT INTO rlm_interface_lines_all(
4242: line_id,
4243: header_id,
4244: schedule_item_num,
4245: agreement_id,

Line 4842: PROCEDURE UpdateReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)

4838: PROCEDURE NAME: UpdateReq
4839:
4840: ===========================================================================*/
4841:
4842: PROCEDURE UpdateReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)
4843: IS
4844:
4845: v_Progress VARCHAR2(3) := '010';
4846:

Line 4870: UPDATE rlm_interface_lines_all

4866: rlm_core_sv.dlog(C_DEBUG,'x_ManageDemand_rec.blanket_number',
4867: x_ManageDemand_rec.blanket_number);
4868: END IF;
4869: --
4870: UPDATE rlm_interface_lines_all
4871: SET primary_quantity = x_ManageDemand_rec.primary_quantity,
4872: ship_from_org_id = x_ManageDemand_rec.ship_from_org_id,
4873: item_detail_type = x_ManageDemand_rec.item_detail_type,
4874: item_detail_subtype = x_ManageDemand_rec.item_detail_subtype,

Line 4908: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,

4904: PROCEDURE NAME: UpdateSchedule
4905:
4906: ===========================================================================*/
4907:
4908: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,
4909: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE)
4910: IS
4911:
4912: v_Progress VARCHAR2(3) := '010';

Line 4909: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE)

4905:
4906: ===========================================================================*/
4907:
4908: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,
4909: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE)
4910: IS
4911:
4912: v_Progress VARCHAR2(3) := '010';
4913:

Line 5742: T rlm_interface_lines%ROWTYPE;

5738: PROCEDURE Swap( i IN NUMBER,
5739: j IN NUMBER)
5740: IS
5741:
5742: T rlm_interface_lines%ROWTYPE;
5743: v_Progress VARCHAR2(3) := '010';
5744:
5745: BEGIN
5746:

Line 5782: v rlm_interface_lines%ROWTYPE;

5778: IS
5779:
5780: i NUMBER;
5781: j NUMBER;
5782: v rlm_interface_lines%ROWTYPE;
5783: v_Progress VARCHAR2(3) := '010';
5784:
5785: BEGIN
5786: --

Line 6114: rlm_interface_lines_all ril

6110: ril.ship_to_customer_id
6111: -- Perf change
6112: -- ril.cust_production_seq_num
6113: FROM rlm_interface_headers rih,
6114: rlm_interface_lines_all ril
6115: WHERE rih.header_id = x_Sched_rec.header_id
6116: AND rih.org_id = ril.org_id
6117: AND ril.header_id = rih.header_id
6118: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 6399: FROM rlm_interface_lines

6395: BEGIN
6396: --
6397: SELECT line_id
6398: INTO v_InterfaceLineId
6399: FROM rlm_interface_lines
6400: WHERE header_id = x_Sched_rec.header_id
6401: AND ship_from_org_id = x_Group_rec.ship_from_org_id
6402: AND ship_to_address_id = x_Group_rec.ship_to_address_id
6403: AND customer_item_id = x_Group_rec.customer_item_id

Line 6458: FROM rlm_interface_lines_all

6454: x_progress VARCHAR2(3) := '010';
6455: --
6456: CURSOR c IS
6457: SELECT *
6458: FROM rlm_interface_lines_all
6459: WHERE header_id = x_HeaderId
6460: --and inventory_item_id = x_GroupRec.inventory_item_id
6461: and customer_item_id = x_GroupRec.customer_item_id
6462: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6473: FROM rlm_interface_lines_all

6469: FOR UPDATE NOWAIT;
6470: --
6471: CURSOR c_blanket IS
6472: SELECT *
6473: FROM rlm_interface_lines_all
6474: WHERE header_id = x_HeaderId
6475: and customer_item_id = x_GroupRec.customer_item_id
6476: and ship_from_org_id = x_GroupRec.ship_from_org_id
6477: and ship_to_org_id = x_GroupRec.ship_to_org_id

Line 6486: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_INTERFACE_LINES');

6482: BEGIN
6483: --
6484: IF (l_debug <> -1) THEN
6485: rlm_core_sv.dpush(C_SDEBUG,'LockLines');
6486: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_INTERFACE_LINES');
6487: END IF;
6488: --
6489: IF x_GroupRec.blanket_number is NULL THEN
6490: --

Line 6625: UPDATE rlm_interface_lines

6621: x_GroupRec.cust_production_seq_num);*/
6622: END IF;
6623:
6624: --
6625: UPDATE rlm_interface_lines
6626: SET process_status = x_ProcessStatus
6627: WHERE header_id = x_HeaderId
6628: and inventory_item_id = x_GroupRec.inventory_item_id
6629: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6661: UPDATE rlm_interface_lines

6657: END IF;
6658: --
6659: ELSIF x_UpdateLevel = 'ALL' THEN
6660: --
6661: UPDATE rlm_interface_lines
6662: SET process_status = x_ProcessStatus
6663: WHERE header_id = x_HeaderId
6664: and process_status = rlm_core_sv.k_PS_AVAILABLE;
6665: --

Line 7029: FROM rlm_interface_lines il,

7025: END IF; /*Record Keeping Year*/
7026:
7027: SELECT TO_CHAR(TRUNC(min(il.start_date_time)), 'RRRR/MM/DD HH24:MI:SS')
7028: INTO v_min_horizon_date
7029: FROM rlm_interface_lines il,
7030: rlm_schedule_lines sl
7031: WHERE il.header_id = x_Sched_rec.header_id
7032: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
7033: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id

Line 7142: FROM rlm_interface_lines

7138: CURSOR c_LastReceipt(i IN NUMBER) IS
7139: SELECT start_date_time,
7140: item_detail_subtype,
7141: item_detail_ref_value_1
7142: FROM rlm_interface_lines
7143: WHERE header_id = x_Sched_rec.header_id
7144: AND ship_from_org_id = x_Source_Tab(i).organization_id
7145: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7146: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 7162: FROM rlm_interface_lines

7158: CURSOR c_LastShipment(i IN NUMBER) IS
7159: SELECT start_date_time,
7160: item_detail_subtype,
7161: item_detail_ref_value_1
7162: FROM rlm_interface_lines
7163: WHERE header_id = x_Sched_rec.header_id
7164: AND ship_from_org_id = x_Source_Tab(i).organization_id
7165: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7166: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 8115: FROM rlm_interface_lines

8111: CURSOR c_LastReceipt IS
8112: SELECT start_date_time,
8113: item_detail_subtype,
8114: item_detail_ref_value_1
8115: FROM rlm_interface_lines
8116: WHERE header_id = x_Sched_rec.header_id
8117: AND ship_from_org_id = x_Group_rec.ship_from_org_id
8118: AND ship_to_org_id = x_Group_rec.ship_to_org_id
8119: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 8133: FROM rlm_interface_lines

8129: CURSOR c_LastShipment IS
8130: SELECT start_date_time,
8131: item_detail_subtype,
8132: item_detail_ref_value_1
8133: FROM rlm_interface_lines
8134: WHERE header_id = x_Sched_rec.header_id
8135: AND ship_from_org_id = x_Group_rec.ship_from_org_id
8136: AND ship_to_org_id = x_Group_rec.ship_to_org_id
8137: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 8453: FROM rlm_interface_lines il,

8449: END IF; /*Record Keeping Year*/
8450:
8451: SELECT TO_CHAR(TRUNC(min(il.start_date_time)), 'RRRR/MM/DD HH24:MI:SS')
8452: INTO v_min_horizon_date
8453: FROM rlm_interface_lines il,
8454: rlm_schedule_lines sl
8455: WHERE il.header_id = x_Sched_rec.header_id
8456: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
8457: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id