APPS.RLM_VALIDATEDEMAND_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 46: rlm_interface_lines_all ril

42: null,
43: null,
44: null
45: FROM rlm_interface_headers rih,
46: rlm_interface_lines_all ril
47: WHERE ril.header_id = rih.header_id
48: AND rih.header_id = x_header_id
49: AND rih.org_id = ril.org_id
50: GROUP BY schedule_item_num;

Line 68: rlm_interface_lines_all ril

64: null,
65: null,
66: null
67: FROM rlm_interface_headers rih,
68: rlm_interface_lines_all ril
69: WHERE ril.header_id = rih.header_id
70: AND rih.header_id = x_header_id
71: AND rih.org_id = ril.org_id
72: GROUP BY cust_ship_from_org_ext, cust_ship_to_ext,

Line 87: rlm_interface_lines_all ril

83: ril.customer_item_id,
84: ril.ship_from_org_id,
85: ril.ship_to_address_id
86: FROM rlm_interface_headers rih,
87: rlm_interface_lines_all ril
88: WHERE ril.header_id = rih.header_id
89: AND rih.header_id = x_header_id
90: AND rih.org_id = ril.org_id
91: GROUP BY customer_item_id,

Line 2601: FROM RLM_INTERFACE_LINES_ALL --bug 4907839

2597: IF v_Group_rec.group_type = 'N' THEN
2598: --
2599: OPEN c_lines FOR
2600: SELECT *
2601: FROM RLM_INTERFACE_LINES_ALL --bug 4907839
2602: WHERE schedule_item_num = v_Group_rec.schedule_item_num
2603: AND header_id = g_header_rec.header_id
2604: AND process_status = rlm_core_sv.k_PS_AVAILABLE
2605: --ORDER BY item_detail_type desc

Line 2616: FROM RLM_INTERFACE_LINES_ALL --Bug 4907839

2612: IF (v_Group_rec.cust_ship_from_org_ext IS NOT NULL AND v_Group_rec.cust_ship_to_ext IS NOT NULL) THEN
2613: --
2614: OPEN c_lines FOR
2615: SELECT *
2616: FROM RLM_INTERFACE_LINES_ALL --Bug 4907839
2617: WHERE header_id = g_header_rec.header_id
2618: AND cust_ship_from_org_ext =
2619: v_Group_rec.cust_ship_from_org_ext
2620: AND cust_ship_to_ext =

Line 2631: FROM RLM_INTERFACE_LINES_ALL --bug 4907839

2627: ELSE
2628: --
2629: OPEN c_lines FOR
2630: SELECT *
2631: FROM RLM_INTERFACE_LINES_ALL --bug 4907839
2632: WHERE header_id = g_header_rec.header_id
2633: AND nvl(cust_ship_from_org_ext,k_VNULL) =
2634: nvl(v_Group_rec.cust_ship_from_org_ext,k_VNULL)
2635: AND nvl(cust_ship_to_ext,k_VNULL) =