APPS.AMS_LIST_SRC_MAPPING dependencies on AK_REGION_ITEMS_VL
Line 88: FROM ak_region_items_vl ai
84:
85: cursor c_count_import(cur_source_type_id number,
86: p_import_type varchar2) is
87: SELECT COUNT(1) 88: FROM ak_region_items_vl ai 89: WHERE ai.region_code LIKE 'AMS_IMPH_METADATA_0%'
90: AND ai.required_flag = 'Y'
91: AND ai.SORTBY_VIEW_ATTRIBUTE_NAME = p_import_type
92: AND NOT EXISTS ( SELECT 'x'