DBA Data[Home] [Help]

APPS.RLM_REPLACE_SV dependencies on RLM_INTERFACE_LINES

Line 252: FROM rlm_interface_lines ril

248: FROM rlm_schedule_lines_all rsl
249: WHERE rsl.header_id = x_prev_header_id
250: AND rsl.item_detail_type IN (0,1,2)
251: AND NOT EXISTS ( SELECT 'X'
252: FROM rlm_interface_lines ril
253: WHERE ril.header_id = x_curr_header_id
254: AND ril.ship_from_org_id = rsl.ship_from_org_id
255: AND ril.ship_to_address_id = rsl.ship_to_address_id
256: AND ril.ship_to_org_id = rsl.ship_to_org_id

Line 431: FROM rlm_interface_lines_all

427: END IF;
428: --
429: SELECT count(1)
430: INTO v_exist_count
431: FROM rlm_interface_lines_all
432: WHERE header_id = x_curr_header_id
433: AND ship_from_org_id = g_list_tbl(i).ship_from_org_id
434: AND ship_to_address_id = g_list_tbl(i).ship_to_address_id
435: AND customer_item_id = g_list_tbl(i).customer_item_id;