APPS.RLM_DP_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 1005: FROM rlm_interface_lines_all il

1001: WHERE sl.header_id = v_SchedHeaderId
1002: AND process_status <> rlm_core_sv.k_PS_ERROR -- bug 5134706
1003: AND interface_line_id in
1004: (SELECT line_id
1005: FROM rlm_interface_lines_all il
1006: WHERE il.header_id = x_header_id);
1007: --
1008: IF (l_debug <> -1) THEN
1009: rlm_core_sv.dlog(C_DEBUG,'No of Schedule Lines Updated ', SQL%ROWCOUNT);

Line 1030: FROM rlm_interface_lines_all il

1026: PROGRAM_UPDATE_DATE = v_program_update_date
1027: WHERE header_id = v_SchedHeaderId
1028: AND interface_line_id in
1029: (SELECT /*+ unnest */ line_id --Bugfix 12863728
1030: FROM rlm_interface_lines_all il
1031: WHERE header_id = x_header_id
1032: AND industry_attribute15 = x_Group_rec.industry_attribute15
1033: AND ship_to_org_id = x_Group_rec.ship_to_org_id
1034: AND customer_item_id = x_Group_rec.customer_item_id

Line 1434: rlm_interface_lines_all ril

1430: CURSOR c_group_cur IS
1431: SELECT ril.order_header_id,
1432: ril.blanket_number
1433: FROM rlm_interface_headers rih,
1434: rlm_interface_lines_all ril
1435: WHERE ril.header_id = x_header_id
1436: AND ril.header_id = rih.header_id
1437: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,
1438: rlm_core_sv.k_PS_PARTIAL_PROCESSED)

Line 1663: from rlm_interface_lines_all il

1659: update rlm_schedule_lines sch
1660: set process_status = rlm_core_sv.k_PS_ERROR
1661: where interface_line_id in
1662: (select line_id
1663: from rlm_interface_lines_all il
1664: where header_id = x_header_id
1665: and dsp_child_process_index = i
1666: and process_status <> rlm_core_sv.k_PS_PROCESSED);
1667: --

Line 1797: from rlm_interface_lines_all il

1793: update rlm_schedule_lines sch
1794: set process_status = rlm_core_sv.k_PS_ERROR
1795: where interface_line_id in
1796: (select line_id
1797: from rlm_interface_lines_all il
1798: where header_id = p_header_id
1799: and dsp_child_process_index = p_index);
1800: --
1801: COMMIT;

Line 1865: rlm_interface_lines_all ril

1861: ril.blanket_number,
1862: min(ril.start_date_time),
1863: ril.ship_to_customer_id
1864: FROM rlm_interface_headers rih,
1865: rlm_interface_lines_all ril
1866: WHERE ril.header_id = p_header_id
1867: AND ril.header_id = rih.header_id
1868: AND nvl(ril.dsp_child_process_index,-99) =nvl(p_index, -99)
1869: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,