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

312: SET process_status = rlm_core_sv.k_PS_Processed
313: WHERE header_id = x_Sched_rec.schedule_header_id
314: AND line_id IN (
315: SELECT schedule_line_id
316: FROM rlm_interface_lines il
317: WHERE il.header_id = x_sched_rec.header_id
318: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
319: AND il.ship_to_address_id = x_Group_rec.ship_to_address_id
320: AND il.customer_item_id = x_Group_rec.customer_item_id

Line 336: FROM rlm_interface_lines il

332: SET process_status = rlm_core_sv.k_PS_Processed
333: WHERE header_id = x_Sched_rec.schedule_header_id
334: AND line_id IN (
335: SELECT schedule_line_id
336: FROM rlm_interface_lines il
337: WHERE il.header_id = x_sched_rec.header_id
338: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
339: AND il.ship_to_address_id = x_Group_rec.ship_to_address_id
340: AND il.customer_item_id = x_Group_rec.customer_item_id

Line 416: FROM rlm_interface_lines

412: start_date_time,
413: industry_attribute1 cust_record_year,
414: line_id,
415: k_TRUE
416: FROM rlm_interface_lines
417: WHERE header_id = x_Sched_rec.header_id
418: AND item_detail_type = k_SHIP_RECEIPT_INFO
419: AND item_detail_subtype IN (k_SHIPMENT, k_RECEIPT)
420: AND ship_to_address_id = x_Group_rec.ship_to_address_id

Line 501: FROM rlm_interface_lines

497: start_date_time,
498: industry_attribute1 cust_record_year,
499: line_id,
500: k_TRUE
501: FROM rlm_interface_lines
502: WHERE header_id = x_Sched_rec.header_id
503: AND item_detail_type = k_SHIP_RECEIPT_INFO
504: AND item_detail_subtype = k_CUM
505: AND ship_from_org_id = x_Group_rec.ship_from_org_id

Line 638: FROM rlm_interface_lines_all

634: IS
635: --
636: CURSOR c_Demand IS
637: SELECT *
638: FROM rlm_interface_lines_all
639: WHERE header_id = x_Sched_rec.header_id
640: AND ship_from_org_id = x_Group_rec.ship_from_org_id
641: AND ship_to_address_id = x_Group_rec.ship_to_address_id
642: AND customer_item_id = x_Group_rec.customer_item_id

Line 651: FROM rlm_interface_lines_all

647: ORDER BY START_DATE_TIME;
648:
649: CURSOR c_DemandCum IS
650: SELECT *
651: FROM rlm_interface_lines_all
652: WHERE header_id = x_Sched_rec.header_id
653: AND ship_from_org_id = x_Group_rec.ship_from_org_id
654: AND ship_to_address_id = x_Group_rec.ship_to_address_id
655: AND customer_item_id = x_Group_rec.customer_item_id

Line 663: v_Demand_rec rlm_interface_lines%ROWTYPE;

659: AND process_status = rlm_core_sv.k_PS_AVAILABLE
660: ORDER BY START_DATE_TIME;
661:
662: --
663: v_Demand_rec rlm_interface_lines%ROWTYPE;
664: v_Count NUMBER := 1;
665: v_Progress VARCHAR2(3) := '010';
666: --
667: BEGIN

Line 1063: FROM rlm_interface_lines

1059: BEGIN
1060: --
1061: SELECT line_id
1062: INTO v_InterfaceLineId
1063: FROM rlm_interface_lines
1064: WHERE header_id = x_Sched_rec.header_id
1065: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1066: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1067: AND customer_item_id = x_Group_rec.customer_item_id

Line 1112: FROM rlm_interface_lines

1108: BEGIN
1109: --
1110: SELECT line_id
1111: INTO v_InterfaceLineId
1112: FROM rlm_interface_lines
1113: WHERE header_id = x_Sched_rec.header_id
1114: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1115: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1116: AND customer_item_id = x_Group_rec.customer_item_id

Line 1161: FROM rlm_interface_lines

1157: BEGIN
1158: --
1159: SELECT line_id
1160: INTO v_InterfaceLineId
1161: FROM rlm_interface_lines
1162: WHERE header_id = x_Sched_rec.header_id
1163: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1164: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1165: AND customer_item_id = x_Group_rec.customer_item_id

Line 1206: FROM rlm_interface_lines

1202: BEGIN
1203: --
1204: SELECT line_id
1205: INTO v_InterfaceLineId
1206: FROM rlm_interface_lines
1207: WHERE header_id = x_Sched_rec.header_id
1208: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1209: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1210: AND customer_item_id = x_Group_rec.customer_item_id

Line 1263: FROM rlm_interface_lines

1259: BEGIN
1260: --
1261: SELECT line_id
1262: INTO v_InterfaceLineId
1263: FROM rlm_interface_lines
1264: WHERE header_id = x_Sched_rec.header_id
1265: AND ship_from_org_id = x_Group_rec.ship_from_org_id
1266: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1267: AND customer_item_id = x_Group_rec.customer_item_id

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

1349: PROCEDURE NAME: SetOperation
1350:
1351: ===========================================================================*/
1352:
1353: PROCEDURE SetOperation(x_ManageDemand_rec IN OUT NOCOPY rlm_interface_lines%ROWTYPE,
1354: x_Operation IN NUMBER)
1355: IS
1356: --
1357: v_Progress VARCHAR2(3) :='010';

Line 1389: SELECT rlm_interface_lines_s.nextval

1385: THEN
1386: x_ManageDemand_rec.program_id := x_Operation;
1387: END IF;
1388: ELSIF x_Operation = k_INSERT THEN
1389: SELECT rlm_interface_lines_s.nextval
1390: INTO x_ManageDemand_rec.line_id
1391: FROM DUAL;
1392: x_ManageDemand_rec.program_id := x_Operation;
1393: END IF;

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

4065: PROCEDURE NAME: DeleteReq
4066:
4067: ===========================================================================*/
4068:
4069: PROCEDURE DeleteReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)
4070: IS
4071:
4072: i NUMBER;
4073: v_Progress VARCHAR2(3) := '010';

Line 4082: DELETE rlm_interface_lines

4078: rlm_core_sv.dpush(C_SDEBUG,'DeleteReq');
4079: rlm_core_sv.dlog(C_DEBUG,'x_ManageDemand_rec.line_id',x_ManageDemand_rec.line_id);
4080: END IF;
4081: --
4082: DELETE rlm_interface_lines
4083: WHERE line_id = x_ManageDemand_rec.line_id;
4084: --
4085: -- JAUTOMO: The interface_line_id should be updated with the
4086: -- the line id of new lines created by SDP, Sourcing Rules,

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

4115: PROCEDURE NAME: InsertReq
4116:
4117: ===========================================================================*/
4118:
4119: PROCEDURE InsertReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)
4120: IS
4121: --
4122: v_Progress VARCHAR2(3) := '010';
4123: e_NullOrgId EXCEPTION;

Line 4150: INSERT INTO rlm_interface_lines_all(

4146: IF x_ManageDemand_rec.org_id IS NULL THEN
4147: RAISE e_NullOrgId;
4148: END IF;
4149: --
4150: INSERT INTO rlm_interface_lines_all(
4151: line_id,
4152: header_id,
4153: schedule_item_num,
4154: agreement_id,

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

4747: PROCEDURE NAME: UpdateReq
4748:
4749: ===========================================================================*/
4750:
4751: PROCEDURE UpdateReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE)
4752: IS
4753:
4754: v_Progress VARCHAR2(3) := '010';
4755:

Line 4779: UPDATE rlm_interface_lines_all

4775: rlm_core_sv.dlog(C_DEBUG,'x_ManageDemand_rec.blanket_number',
4776: x_ManageDemand_rec.blanket_number);
4777: END IF;
4778: --
4779: UPDATE rlm_interface_lines_all
4780: SET primary_quantity = x_ManageDemand_rec.primary_quantity,
4781: ship_from_org_id = x_ManageDemand_rec.ship_from_org_id,
4782: item_detail_type = x_ManageDemand_rec.item_detail_type,
4783: item_detail_subtype = x_ManageDemand_rec.item_detail_subtype,

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

4813: PROCEDURE NAME: UpdateSchedule
4814:
4815: ===========================================================================*/
4816:
4817: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,
4818: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE)
4819: IS
4820:
4821: v_Progress VARCHAR2(3) := '010';

Line 4818: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE)

4814:
4815: ===========================================================================*/
4816:
4817: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,
4818: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE)
4819: IS
4820:
4821: v_Progress VARCHAR2(3) := '010';
4822:

Line 5651: T rlm_interface_lines%ROWTYPE;

5647: PROCEDURE Swap( i IN NUMBER,
5648: j IN NUMBER)
5649: IS
5650:
5651: T rlm_interface_lines%ROWTYPE;
5652: v_Progress VARCHAR2(3) := '010';
5653:
5654: BEGIN
5655:

Line 5691: v rlm_interface_lines%ROWTYPE;

5687: IS
5688:
5689: i NUMBER;
5690: j NUMBER;
5691: v rlm_interface_lines%ROWTYPE;
5692: v_Progress VARCHAR2(3) := '010';
5693:
5694: BEGIN
5695: --

Line 6023: rlm_interface_lines_all ril

6019: ril.ship_to_customer_id
6020: -- Perf change
6021: -- ril.cust_production_seq_num
6022: FROM rlm_interface_headers rih,
6023: rlm_interface_lines_all ril
6024: WHERE rih.header_id = x_Sched_rec.header_id
6025: AND rih.org_id = ril.org_id
6026: AND ril.header_id = rih.header_id
6027: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 6308: FROM rlm_interface_lines

6304: BEGIN
6305: --
6306: SELECT line_id
6307: INTO v_InterfaceLineId
6308: FROM rlm_interface_lines
6309: WHERE header_id = x_Sched_rec.header_id
6310: AND ship_from_org_id = x_Group_rec.ship_from_org_id
6311: AND ship_to_address_id = x_Group_rec.ship_to_address_id
6312: AND customer_item_id = x_Group_rec.customer_item_id

Line 6367: FROM rlm_interface_lines_all

6363: x_progress VARCHAR2(3) := '010';
6364: --
6365: CURSOR c IS
6366: SELECT *
6367: FROM rlm_interface_lines_all
6368: WHERE header_id = x_HeaderId
6369: --and inventory_item_id = x_GroupRec.inventory_item_id
6370: and customer_item_id = x_GroupRec.customer_item_id
6371: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6382: FROM rlm_interface_lines_all

6378: FOR UPDATE NOWAIT;
6379: --
6380: CURSOR c_blanket IS
6381: SELECT *
6382: FROM rlm_interface_lines_all
6383: WHERE header_id = x_HeaderId
6384: and customer_item_id = x_GroupRec.customer_item_id
6385: and ship_from_org_id = x_GroupRec.ship_from_org_id
6386: and ship_to_org_id = x_GroupRec.ship_to_org_id

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

6391: BEGIN
6392: --
6393: IF (l_debug <> -1) THEN
6394: rlm_core_sv.dpush(C_SDEBUG,'LockLines');
6395: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_INTERFACE_LINES');
6396: END IF;
6397: --
6398: IF x_GroupRec.blanket_number is NULL THEN
6399: --

Line 6534: UPDATE rlm_interface_lines

6530: x_GroupRec.cust_production_seq_num);*/
6531: END IF;
6532:
6533: --
6534: UPDATE rlm_interface_lines
6535: SET process_status = x_ProcessStatus
6536: WHERE header_id = x_HeaderId
6537: and inventory_item_id = x_GroupRec.inventory_item_id
6538: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6570: UPDATE rlm_interface_lines

6566: END IF;
6567: --
6568: ELSIF x_UpdateLevel = 'ALL' THEN
6569: --
6570: UPDATE rlm_interface_lines
6571: SET process_status = x_ProcessStatus
6572: WHERE header_id = x_HeaderId
6573: and process_status = rlm_core_sv.k_PS_AVAILABLE;
6574: --

Line 6938: FROM rlm_interface_lines il,

6934: END IF; /*Record Keeping Year*/
6935:
6936: SELECT TO_CHAR(TRUNC(min(il.start_date_time)), 'RRRR/MM/DD HH24:MI:SS')
6937: INTO v_min_horizon_date
6938: FROM rlm_interface_lines il,
6939: rlm_schedule_lines sl
6940: WHERE il.header_id = x_Sched_rec.header_id
6941: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
6942: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id

Line 7052: FROM rlm_interface_lines

7048: CURSOR c_LastReceipt(i IN NUMBER) IS
7049: SELECT start_date_time,
7050: item_detail_subtype,
7051: item_detail_ref_value_1
7052: FROM rlm_interface_lines
7053: WHERE header_id = x_Sched_rec.header_id
7054: AND ship_from_org_id = x_Source_Tab(i).organization_id
7055: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7056: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 7072: FROM rlm_interface_lines

7068: CURSOR c_LastShipment(i IN NUMBER) IS
7069: SELECT start_date_time,
7070: item_detail_subtype,
7071: item_detail_ref_value_1
7072: FROM rlm_interface_lines
7073: WHERE header_id = x_Sched_rec.header_id
7074: AND ship_from_org_id = x_Source_Tab(i).organization_id
7075: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7076: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 8025: FROM rlm_interface_lines

8021: CURSOR c_LastReceipt IS
8022: SELECT start_date_time,
8023: item_detail_subtype,
8024: item_detail_ref_value_1
8025: FROM rlm_interface_lines
8026: WHERE header_id = x_Sched_rec.header_id
8027: AND ship_from_org_id = x_Group_rec.ship_from_org_id
8028: AND ship_to_org_id = x_Group_rec.ship_to_org_id
8029: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 8043: FROM rlm_interface_lines

8039: CURSOR c_LastShipment IS
8040: SELECT start_date_time,
8041: item_detail_subtype,
8042: item_detail_ref_value_1
8043: FROM rlm_interface_lines
8044: WHERE header_id = x_Sched_rec.header_id
8045: AND ship_from_org_id = x_Group_rec.ship_from_org_id
8046: AND ship_to_org_id = x_Group_rec.ship_to_org_id
8047: AND inventory_item_id = x_Group_rec.inventory_item_id

Line 8363: FROM rlm_interface_lines il,

8359: END IF; /*Record Keeping Year*/
8360:
8361: SELECT TO_CHAR(TRUNC(min(il.start_date_time)), 'RRRR/MM/DD HH24:MI:SS')
8362: INTO v_min_horizon_date
8363: FROM rlm_interface_lines il,
8364: rlm_schedule_lines sl
8365: WHERE il.header_id = x_Sched_rec.header_id
8366: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
8367: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id