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 6351: from ams_hz_b2c_mapping_v ail,

6347: ail.contact_point_id ,
6348: ail.orig_system_reference,
6349: ail.address3,
6350: ail.address4
6351: from ams_hz_b2c_mapping_v ail,
6352: ams_list_select_actions als
6353: where ail.import_list_header_id = als.incl_object_id
6354: and als.list_select_action_id = ale.list_select_action_id
6355: and ail.party_id = ale.list_entry_source_system_id

Line 12204: from ams_hz_b2c_mapping_v

12200: else
12201: x_include_sql := '
12202: select
12203: count(*) :1
12204: from ams_hz_b2c_mapping_v
12205: where enabled_flag = '||''''||'Y'||''''||
12206: ' and import_list_header_id =' || p_incl_object_id ||
12207: ' and nvl(party_id, import_source_line_id) in (' ;
12208: end if;