eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LISTIMPORT_PVT dependencies on HZ_FUZZY_PUB

Line 13500: l_address_key := hz_fuzzy_pub.Generate_Key (

13496: and nvl(loc.city,nvl(p_city,'x')) = nvl(p_city,'x');
13497:
13498: begin
13499: x_return_status := FND_API.g_ret_sts_success;
13500: l_address_key := hz_fuzzy_pub.Generate_Key (
13501: p_key_type => 'ADDRESS',
13502: p_address1 => p_address1,
13503: p_postal_code => p_pcode
13504: );

Line 18554: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"

18550: L_PARTY_NAME PARTY_NAME_LIST;
18551:
18552: cursor c_org_key is
18553: select b2b.party_name, 'N',
18554: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"
18555: from ams_hz_b2b_mapping_v b2b
18556: where b2b.import_list_header_id = p_import_list_header_id
18557: and b2b.load_status in ('ACTIVE','RELOAD')
18558: and b2b.party_name is not null

Line 18823: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"

18819: L_PARTY_NAME PARTY_NAME_LIST;
18820:
18821: cursor c_org_key is
18822: select b2b.party_name, 'N',
18823: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"
18824: from ams_hz_b2b_mapping_v b2b
18825: where b2b.import_list_header_id = p_import_list_header_id
18826: and b2b.load_status in ('ACTIVE','RELOAD')
18827: and b2b.party_name is not null

Line 19104: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"

19100: L_person_status person_status_LIST;
19101:
19102: cursor c_per_key is
19103: select b2c.import_source_line_id, 'N',
19104: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"
19105: from ams_hz_b2c_mapping_v b2c
19106: where b2c.import_list_header_id = p_import_list_header_id
19107: and b2c.load_status in ('ACTIVE','RELOAD')
19108: and b2c.PERSON_FIRST_NAME is not null

Line 19419: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"

19415: L_person_PARTY_ID person_PARTY_ID_LIST;
19416:
19417: cursor c_per_key is
19418: select b2c.import_source_line_id, 'N',
19419: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"
19420: from ams_hz_b2c_mapping_v b2c
19421: where b2c.import_list_header_id = p_import_list_header_id
19422: and b2c.load_status in ('ACTIVE','RELOAD')
19423: and b2c.PERSON_FIRST_NAME is not null

Line 19694: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)

19690: L_ocont_phnumb ocont_phnumb_LIST;
19691:
19692: cursor c_per_key is
19693: select b2b.import_source_line_id, 'N',
19694: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)
19695: "per_key"
19696: from ams_hz_b2b_mapping_v b2b
19697: where b2b.import_list_header_id = p_import_list_header_id
19698: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20072: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)

20068: L_ocont_PARTY_ID ocont_PARTY_ID_LIST;
20069:
20070: cursor c_per_key is
20071: select b2b.import_source_line_id, 'N',
20072: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)
20073: "per_key"
20074: from ams_hz_b2b_mapping_v b2b
20075: where b2b.import_list_header_id = p_import_list_header_id
20076: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20384: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.address1,b2b.address2,b2b.address3,b2b.address4,b2b.postal_code,null,null)

20380: L_PARTY_location_ID PARTY_location_ID_LIST;
20381:
20382: cursor c_addr_key is
20383: select b2b.import_source_line_id,
20384: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.address1,b2b.address2,b2b.address3,b2b.address4,b2b.postal_code,null,null)
20385: "add_key"
20386: from ams_hz_b2b_mapping_v b2b
20387: where b2b.import_list_header_id = p_import_list_header_id
20388: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20542: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.org_address1,b2b.org_address2,b2b.org_address3,b2b.org_address4,b2b.org_postal_code,null,null)

20538: L_org_location_ID party_location_ID_LIST;
20539:
20540: cursor c_addr_key is
20541: select b2b.import_source_line_id,
20542: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.org_address1,b2b.org_address2,b2b.org_address3,b2b.org_address4,b2b.org_postal_code,null,null)
20543: "add_key"
20544: from ams_hz_b2b_mapping_v b2b
20545: where b2b.import_list_header_id = p_import_list_header_id
20546: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20700: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2c.address1,b2c.address2,b2c.address3,b2c.address4,b2c.postal_code,null,null)

20696: L_PARTY_location_ID PARTY_location_ID_LIST;
20697:
20698: cursor c_addr_key is
20699: select b2c.import_source_line_id,
20700: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2c.address1,b2c.address2,b2c.address3,b2c.address4,b2c.postal_code,null,null)
20701: "add_key"
20702: from ams_hz_b2c_mapping_v b2c
20703: where b2c.import_list_header_id = p_import_list_header_id
20704: and b2c.load_status in ('ACTIVE','RELOAD')