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 line_id IN (
315: SELECT schedule_line_id

Line 331: UPDATE rlm_schedule_lines_all sl

327: IF (l_debug <> -1) THEN
328: rlm_core_sv.dlog(C_DEBUG, 'Sales order version of Update', x_Group_rec.order_header_id);
329: END IF;
330: --
331: UPDATE rlm_schedule_lines_all sl
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

Line 4089: --UPDATE rlm_schedule_lines

4085: -- JAUTOMO: The interface_line_id should be updated with the
4086: -- the line id of new lines created by SDP, Sourcing Rules,
4087: -- or Aggregate Demand.
4088: --
4089: --UPDATE rlm_schedule_lines
4090: --SET interface_line_id = NULL
4091: --WHERE line_id = x_ManageDemand_rec.schedule_line_id;
4092: --
4093: IF (l_debug <> -1) THEN

Line 4699: UPDATE rlm_schedule_lines_all

4695: --
4696: -- JAUTOMO: update schedule lines with the interface line id
4697: -- created when sourcing rule is applied
4698: --
4699: UPDATE rlm_schedule_lines_all
4700: SET interface_line_id = x_ManageDemand_rec.line_id
4701: WHERE line_id = x_ManageDemand_rec.schedule_line_id
4702: AND x_ManageDemand_rec.line_source = 'SOURCED';
4703: --

Line 4833: UPDATE rlm_schedule_lines_all

4829: END IF;
4830: --
4831: IF x_ManageDemand_rec.program_id <> k_INSERT THEN
4832: --
4833: UPDATE rlm_schedule_lines_all
4834: SET interface_line_id = x_AggregateDemand_rec.line_id
4835: WHERE line_id = x_ManageDemand_rec.schedule_line_id;
4836: --
4837: IF (l_debug <> -1) THEN

Line 6551: UPDATE rlm_schedule_lines

6547: IF (l_debug <> -1) THEN
6548: rlm_core_sv.dlog(C_DEBUG,'Number of Interface lines updated',SQL%ROWCOUNT);
6549: END IF;
6550: --
6551: UPDATE rlm_schedule_lines
6552: SET process_status = x_ProcessStatus
6553: WHERE header_id = x_ScheduleHeaderId
6554: and inventory_item_id = x_GroupRec.inventory_item_id
6555: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6579: UPDATE rlm_schedule_lines

6575: IF (l_debug <> -1) THEN
6576: rlm_core_sv.dlog(C_DEBUG,'Number of Interface lines updated',SQL%ROWCOUNT);
6577: END IF;
6578: --
6579: UPDATE rlm_schedule_lines
6580: SET process_status = x_ProcessStatus
6581: WHERE header_id = x_ScheduleHeaderId
6582: and process_status = rlm_core_sv.k_PS_AVAILABLE;
6583: --

Line 6939: rlm_schedule_lines sl

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

Line 7019: FROM rlm_schedule_lines

7015: SELECT start_date_time,
7016: primary_quantity,
7017: substr(item_detail_ref_value_1,1,29) shipper_Id,
7018: line_id
7019: FROM rlm_schedule_lines
7020: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
7021: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7022: AND inventory_item_id = x_Group_rec.inventory_item_id
7023: AND customer_item_id = x_Group_rec.customer_item_id

Line 7034: FROM rlm_schedule_lines

7030: SELECT start_date_time,
7031: primary_quantity,
7032: substr(item_detail_ref_value_1,1,29) shipper_Id,
7033: line_id
7034: FROM rlm_schedule_lines
7035: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
7036: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7037: AND inventory_item_id = x_Group_rec.inventory_item_id
7038: AND customer_item_id = x_Group_rec.customer_item_id

Line 7993: FROM rlm_schedule_lines

7989: SELECT start_date_time,
7990: primary_quantity,
7991: substr(item_detail_ref_value_1,1,29) shipper_Id,
7992: line_id
7993: FROM rlm_schedule_lines
7994: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
7995: AND ship_to_org_id = x_Group_rec.ship_to_org_id
7996: AND inventory_item_id = x_Group_rec.inventory_item_id
7997: AND customer_item_id = x_Group_rec.customer_item_id

Line 8008: FROM rlm_schedule_lines

8004: SELECT start_date_time,
8005: primary_quantity,
8006: substr(item_detail_ref_value_1,1,29) shipper_Id,
8007: line_id
8008: FROM rlm_schedule_lines
8009: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
8010: AND ship_to_org_id = x_Group_rec.ship_to_org_id
8011: AND inventory_item_id = x_Group_rec.inventory_item_id
8012: AND customer_item_id = x_Group_rec.customer_item_id

Line 8364: rlm_schedule_lines sl

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