DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 412: SELECT 'Y' FROM ams_list_src_fields sf,

408:
409:
410: /* For Mapped party */
411: cursor party_mapped is
412: SELECT 'Y' FROM ams_list_src_fields sf,
413: ams_imp_list_headers_all hd
414: WHERE sf.field_column_name = 'PARTY_ID'
415: AND sf.enabled_flag = 'Y'
416: AND sf.list_source_type_id = hd.list_source_type_id

Line 2314: SELECT 'Y' FROM ams_list_src_fields sf,

2310: and load_status in ('ACTIVE','RELOAD');
2311:
2312: -- For Mapped osr
2313: cursor osr_mapped is
2314: SELECT 'Y' FROM ams_list_src_fields sf,
2315: ams_imp_list_headers_all hd
2316: WHERE sf.field_column_name = 'ORIG_SYSTEM_REFERENCE'
2317: AND sf.enabled_flag = 'Y'
2318: AND sf.list_source_type_id = hd.list_source_type_id

Line 13730: SELECT 'Y' FROM ams_list_src_fields sf,

13726: and load_status in ('ACTIVE','RELOAD');
13727:
13728: -- For Mapped osr
13729: cursor osr_mapped is
13730: SELECT 'Y' FROM ams_list_src_fields sf,
13731: ams_imp_list_headers_all hd
13732: WHERE sf.field_column_name = 'ORIG_SYSTEM_REFERENCE'
13733: AND sf.enabled_flag = 'Y'
13734: AND sf.list_source_type_id = hd.list_source_type_id