APPS.AMS_LISTIMPORT_PVT dependencies on AMS_LEAD_MAPPING_V

Line 4010: select source_system from ams_lead_mapping_v

4006: SELECT batch_id, VALIDATE_FILE, EXECUTE_MODE FROM ams_imp_list_headers_all
4007: WHERE import_list_header_id = p_import_list_header_id ;
4008:
4009: cursor c_lead_source_system is
4010: select source_system from ams_lead_mapping_v
4011: where import_list_header_id = p_import_list_header_id
4012: and load_status in ('ACTIVE','RELOAD')
4013: and source_system is not NULL
4014: and rownum < 2;

Line 6278: FROM ams_lead_mapping_v

6274: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(SOURCE_PRIMARY_REFERENCE)),'x')),30) - 30,0,' ','SOURCE_PRIMARY_REFERENCE :'||l_invalid_size||'(30)') SOURCE_PRIMARY_REFERENCE,
6275: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(SOURCE_SECONDARY_REFERENCE)),'x')),30) - 30,0,' ','SOURCE_SECONDARY_REFERENCE :'||l_invalid_size||'(30)') SOURCE_SECONDARY_REFERENCE,
6276: DECODE(GREATEST(lengthb(nvl(LTRIM(RTRIM(NOTE_TYPE)),'x')),30) - 30,0,' ','NOTE_TYPE :'||l_invalid_size||'(30)')
6277: NOTE_TYPE
6278: FROM ams_lead_mapping_v
6279: WHERE import_list_header_id = p_import_list_header_id
6280: and load_status in ('ACTIVE','RELOAD')
6281: and
6282: (

Line 6781: FROM ams_lead_mapping_v

6777: address_effective_date,
6778: last_ordered_date,
6779: program_update_date,
6780: lead_date
6781: FROM ams_lead_mapping_v
6782: WHERE import_list_header_id = p_import_list_header_id
6783: and load_status in ('ACTIVE','RELOAD')
6784: AND (assign_date is not null or address_effective_date is not null or
6785: last_ordered_date is not null or program_update_date is not null

Line 6789: SELECT COUNT(*) total_rec, source_system FROM ams_lead_mapping_v

6785: last_ordered_date is not null or program_update_date is not null
6786: or lead_date is not null);
6787:
6788: CURSOR c_source_system is
6789: SELECT COUNT(*) total_rec, source_system FROM ams_lead_mapping_v
6790: WHERE import_list_header_id = p_import_list_header_id
6791: GROUP BY source_system ORDER BY COUNT(*) DESC;
6792:
6793:

Line 6798: FROM ams_lead_mapping_v

6794: CURSOR c_invalid_src_sys is
6795: SELECT
6796: import_list_header_id,
6797: import_source_line_id
6798: FROM ams_lead_mapping_v
6799: WHERE import_list_header_id = p_import_list_header_id
6800: AND source_system <> l_source_system;
6801:
6802: cursor c_error_exists is