APPS.AMS_LISTIMPORT_PVT dependencies on AMS_LEAD_MAPPING_V

Line 4009: select source_system from ams_lead_mapping_v

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

Line 6277: FROM ams_lead_mapping_v

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

Line 6780: FROM ams_lead_mapping_v

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

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

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

Line 6797: FROM ams_lead_mapping_v

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