APPS.AMS_LISTGENERATION_PKG dependencies on AMS_HZ_B2C_MAPPING_V

Line 291: from ams_hz_b2c_mapping_v

287: and enabled_flag = 'Y';
288:
289: cursor c_no_of_rows_in_b2c_list is
290: select count(1)
291: from ams_hz_b2c_mapping_v
292: where import_list_header_id = l_incl_object_id
293: and enabled_flag = 'Y';
294:
295: cursor c_get_cnt_from_sel is

Line 1666: from ams_hz_b2c_mapping_v

1662: CUSTOM_COLUMN23,
1663: CUSTOM_COLUMN24,
1664: CUSTOM_COLUMN25,
1665: FAX_NUMBER
1666: from ams_hz_b2c_mapping_v
1667: where enabled_flag = '||''''||'Y'||''''||
1668: ' and import_list_header_id =' || p_incl_object_id ||
1669: ' and nvl(party_id, import_source_line_id) in (' ;
1670: write_to_act_log('Insert statement constructed for imported B2B list', 'LIST', g_list_header_id,'LOW');

Line 6358: from ams_hz_b2c_mapping_v ail,

6354: ail.contact_point_id ,
6355: ail.orig_system_reference,
6356: ail.address3,
6357: ail.address4
6358: from ams_hz_b2c_mapping_v ail,
6359: ams_list_select_actions als
6360: where ail.import_list_header_id = als.incl_object_id
6361: and als.list_select_action_id = ale.list_select_action_id
6362: and ail.party_id = ale.list_entry_source_system_id

Line 12305: from ams_hz_b2c_mapping_v

12301: else
12302: x_include_sql := '
12303: select
12304: count(*) :1
12305: from ams_hz_b2c_mapping_v
12306: where enabled_flag = '||''''||'Y'||''''||
12307: ' and import_list_header_id =' || p_incl_object_id ||
12308: ' and nvl(party_id, import_source_line_id) in (' ;
12309: end if;