APPS.RLM_DP_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 998: FROM rlm_interface_lines_all il

994: WHERE sl.header_id = v_SchedHeaderId
995: AND process_status <> rlm_core_sv.k_PS_ERROR -- bug 5134706
996: AND interface_line_id in
997: (SELECT line_id
998: FROM rlm_interface_lines_all il
999: WHERE il.header_id = x_header_id);
1000: --
1001: IF (l_debug <> -1) THEN
1002: rlm_core_sv.dlog(C_DEBUG,'No of Schedule Lines Updated ', SQL%ROWCOUNT);

Line 1023: FROM rlm_interface_lines_all il

1019: PROGRAM_UPDATE_DATE = v_program_update_date
1020: WHERE header_id = v_SchedHeaderId
1021: AND interface_line_id in
1022: (SELECT line_id
1023: FROM rlm_interface_lines_all il
1024: WHERE header_id = x_header_id
1025: AND industry_attribute15 = x_Group_rec.industry_attribute15
1026: AND ship_to_org_id = x_Group_rec.ship_to_org_id
1027: AND customer_item_id = x_Group_rec.customer_item_id

Line 1427: rlm_interface_lines_all ril

1423: CURSOR c_group_cur IS
1424: SELECT ril.order_header_id,
1425: ril.blanket_number
1426: FROM rlm_interface_headers rih,
1427: rlm_interface_lines_all ril
1428: WHERE ril.header_id = x_header_id
1429: AND ril.header_id = rih.header_id
1430: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,
1431: rlm_core_sv.k_PS_PARTIAL_PROCESSED)

Line 1656: from rlm_interface_lines_all il

1652: update rlm_schedule_lines sch
1653: set process_status = rlm_core_sv.k_PS_ERROR
1654: where interface_line_id in
1655: (select line_id
1656: from rlm_interface_lines_all il
1657: where header_id = x_header_id
1658: and dsp_child_process_index = i
1659: and process_status <> rlm_core_sv.k_PS_PROCESSED);
1660: --

Line 1790: from rlm_interface_lines_all il

1786: update rlm_schedule_lines sch
1787: set process_status = rlm_core_sv.k_PS_ERROR
1788: where interface_line_id in
1789: (select line_id
1790: from rlm_interface_lines_all il
1791: where header_id = p_header_id
1792: and dsp_child_process_index = p_index);
1793: --
1794: COMMIT;

Line 1858: rlm_interface_lines_all ril

1854: ril.blanket_number,
1855: min(ril.start_date_time),
1856: ril.ship_to_customer_id
1857: FROM rlm_interface_headers rih,
1858: rlm_interface_lines_all ril
1859: WHERE ril.header_id = p_header_id
1860: AND ril.header_id = rih.header_id
1861: AND nvl(ril.dsp_child_process_index,-99) =nvl(p_index, -99)
1862: AND ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,