DBA Data[Home] [Help]

APPS.RLM_REPLACE_SV dependencies on RLM_INTERFACE_LINES

Line 247: FROM rlm_interface_lines ril

243: FROM rlm_schedule_lines_all rsl
244: WHERE rsl.header_id = x_prev_header_id
245: AND rsl.item_detail_type IN (0,1,2)
246: AND NOT EXISTS ( SELECT 'X'
247: FROM rlm_interface_lines ril
248: WHERE ril.header_id = x_curr_header_id
249: AND ril.ship_from_org_id = rsl.ship_from_org_id
250: AND ril.ship_to_address_id = rsl.ship_to_address_id
251: AND ril.ship_to_org_id = rsl.ship_to_org_id

Line 418: FROM rlm_interface_lines_all

414: END IF;
415: --
416: SELECT count(1)
417: INTO v_exist_count
418: FROM rlm_interface_lines_all
419: WHERE header_id = x_curr_header_id
420: AND ship_from_org_id = g_list_tbl(i).ship_from_org_id
421: AND ship_to_address_id = g_list_tbl(i).ship_to_address_id
422: AND customer_item_id = g_list_tbl(i).customer_item_id;