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_SCHEDULE_LINES

Line 311: UPDATE rlm_schedule_lines_all sl

307: IF (l_debug <> -1) THEN
308: rlm_core_sv.dlog(C_DEBUG, 'Blanket Version of Update', x_Group_rec.blanket_number);
309: END IF;
310: --
311: UPDATE rlm_schedule_lines_all sl
312: SET process_status = rlm_core_sv.k_PS_Processed
313: WHERE header_id = x_Sched_rec.schedule_header_id
314: AND ship_from_org_id = x_Group_rec.ship_from_org_id --Bugfix 12863728
315: AND ship_to_address_id = x_Group_rec.ship_to_address_id --Bugfix 12863728

Line 334: UPDATE rlm_schedule_lines_all sl

330: IF (l_debug <> -1) THEN
331: rlm_core_sv.dlog(C_DEBUG, 'Sales order version of Update', x_Group_rec.order_header_id);
332: END IF;
333: --
334: UPDATE rlm_schedule_lines_all sl
335: SET process_status = rlm_core_sv.k_PS_Processed
336: WHERE header_id = x_Sched_rec.schedule_header_id
337: AND ship_from_org_id = x_Group_rec.ship_from_org_id --Bugfix 12863728
338: AND ship_to_address_id = x_Group_rec.ship_to_address_id --Bugfix 12863728

Line 4180: --UPDATE rlm_schedule_lines

4176: -- JAUTOMO: The interface_line_id should be updated with the
4177: -- the line id of new lines created by SDP, Sourcing Rules,
4178: -- or Aggregate Demand.
4179: --
4180: --UPDATE rlm_schedule_lines
4181: --SET interface_line_id = NULL
4182: --WHERE line_id = x_ManageDemand_rec.schedule_line_id;
4183: --
4184: IF (l_debug <> -1) THEN

Line 4790: UPDATE rlm_schedule_lines_all

4786: --
4787: -- JAUTOMO: update schedule lines with the interface line id
4788: -- created when sourcing rule is applied
4789: --
4790: UPDATE rlm_schedule_lines_all
4791: SET interface_line_id = x_ManageDemand_rec.line_id
4792: WHERE line_id = x_ManageDemand_rec.schedule_line_id
4793: AND x_ManageDemand_rec.line_source = 'SOURCED';
4794: --

Line 4924: UPDATE rlm_schedule_lines_all

4920: END IF;
4921: --
4922: IF x_ManageDemand_rec.program_id <> k_INSERT THEN
4923: --
4924: UPDATE rlm_schedule_lines_all
4925: SET interface_line_id = x_AggregateDemand_rec.line_id
4926: WHERE line_id = x_ManageDemand_rec.schedule_line_id;
4927: --
4928: IF (l_debug <> -1) THEN

Line 6642: UPDATE rlm_schedule_lines

6638: IF (l_debug <> -1) THEN
6639: rlm_core_sv.dlog(C_DEBUG,'Number of Interface lines updated',SQL%ROWCOUNT);
6640: END IF;
6641: --
6642: UPDATE rlm_schedule_lines
6643: SET process_status = x_ProcessStatus
6644: WHERE header_id = x_ScheduleHeaderId
6645: and inventory_item_id = x_GroupRec.inventory_item_id
6646: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6670: UPDATE rlm_schedule_lines

6666: IF (l_debug <> -1) THEN
6667: rlm_core_sv.dlog(C_DEBUG,'Number of Interface lines updated',SQL%ROWCOUNT);
6668: END IF;
6669: --
6670: UPDATE rlm_schedule_lines
6671: SET process_status = x_ProcessStatus
6672: WHERE header_id = x_ScheduleHeaderId
6673: and process_status = rlm_core_sv.k_PS_AVAILABLE;
6674: --

Line 7030: rlm_schedule_lines sl

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
7034: AND il.inventory_item_id = x_Group_rec.inventory_item_id

Line 7109: FROM rlm_schedule_lines

7105: SELECT start_date_time,
7106: primary_quantity,
7107: substr(item_detail_ref_value_1,1,29) shipper_Id,
7108: line_id
7109: FROM rlm_schedule_lines
7110: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
7111: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7112: AND inventory_item_id = x_Group_rec.inventory_item_id
7113: AND customer_item_id = x_Group_rec.customer_item_id

Line 7124: FROM rlm_schedule_lines

7120: SELECT start_date_time,
7121: primary_quantity,
7122: substr(item_detail_ref_value_1,1,29) shipper_Id,
7123: line_id
7124: FROM rlm_schedule_lines
7125: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
7126: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7127: AND inventory_item_id = x_Group_rec.inventory_item_id
7128: AND customer_item_id = x_Group_rec.customer_item_id

Line 8083: FROM rlm_schedule_lines

8079: SELECT start_date_time,
8080: primary_quantity,
8081: substr(item_detail_ref_value_1,1,29) shipper_Id,
8082: line_id
8083: FROM rlm_schedule_lines
8084: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
8085: AND ship_to_org_id = x_Group_rec.ship_to_org_id
8086: AND inventory_item_id = x_Group_rec.inventory_item_id
8087: AND customer_item_id = x_Group_rec.customer_item_id

Line 8098: FROM rlm_schedule_lines

8094: SELECT start_date_time,
8095: primary_quantity,
8096: substr(item_detail_ref_value_1,1,29) shipper_Id,
8097: line_id
8098: FROM rlm_schedule_lines
8099: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
8100: AND ship_to_org_id = x_Group_rec.ship_to_org_id
8101: AND inventory_item_id = x_Group_rec.inventory_item_id
8102: AND customer_item_id = x_Group_rec.customer_item_id

Line 8454: rlm_schedule_lines sl

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
8458: AND il.inventory_item_id = x_Group_rec.inventory_item_id