APPS.AMS_LISTGENERATION_PKG dependencies on AMS_HZ_B2B_MAPPING_V

Line 285: from ams_hz_b2b_mapping_v

281: where import_list_header_id = l_incl_object_id;
282:
283: cursor c_no_of_rows_in_b2b_list is
284: select count(1)
285: from ams_hz_b2b_mapping_v
286: where import_list_header_id = l_incl_object_id
287: and enabled_flag = 'Y';
288:
289: cursor c_no_of_rows_in_b2c_list is

Line 1484: from ams_hz_b2b_mapping_v ail

1480: CUSTOM_COLUMN23,
1481: CUSTOM_COLUMN24,
1482: CUSTOM_COLUMN25,
1483: FAX_NUMBER
1484: from ams_hz_b2b_mapping_v ail
1485: where enabled_flag = '||''''||'Y'||''''||
1486: ' and import_list_header_id =' || p_incl_object_id ||
1487: ' and nvl(party_id, import_source_line_id) in (' ;
1488: write_to_act_log('Insert statement constructed for imported B2B list', 'LIST', g_list_header_id,'LOW');

Line 6265: from ams_hz_b2b_mapping_v ail,

6261: ail.contact_point_id ,
6262: ail.orig_system_reference,
6263: ail.address3,
6264: ail.address4
6265: from ams_hz_b2b_mapping_v ail,
6266: ams_list_select_actions als
6267: where ail.import_list_header_id = als.incl_object_id
6268: and als.list_select_action_id = ale.list_select_action_id
6269: and ail.party_id = ale.list_entry_source_system_id

Line 12297: from ams_hz_b2b_mapping_v ail

12293: if l_list_entry_source_type <> 'PERSON_LIST' then
12294: x_include_sql := '
12295: select
12296: count(*) into :1
12297: from ams_hz_b2b_mapping_v ail
12298: where enabled_flag = '||''''||'Y'||''''||
12299: ' and import_list_header_id =' || p_incl_object_id ||
12300: ' and nvl(party_id, import_source_line_id) in (' ;
12301: else