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_LOCATIONS

Line 13484: from hz_party_sites ps, hz_locations loc

13480:
13481:
13482: cursor c_addr_ps is
13483: select max(loc.location_id)
13484: from hz_party_sites ps, hz_locations loc
13485: where ps.party_id = p_party_id
13486: and ps.location_id = loc.location_id
13487: and loc.address_key = l_address_key
13488: and loc.country = p_country

Line 13493: from hz_locations loc

13489: and nvl(loc.city,nvl(p_city,'x')) = nvl(p_city,'x');
13490:
13491: cursor c_addr is
13492: select max(loc.location_id)
13493: from hz_locations loc
13494: where loc.address_key = l_address_key
13495: and loc.country = p_country
13496: and nvl(loc.city,nvl(p_city,'x')) = nvl(p_city,'x');
13497:

Line 18580: from hz_party_sites psite, hz_locations loc,

18576:
18577:
18578: cursor c_address_country is
18579: select b2b.import_source_line_id, max(psite.party_id)
18580: from hz_party_sites psite, hz_locations loc,
18581: hz_parties party, ams_hz_b2b_mapping_v b2b
18582: where b2b.import_list_header_id = p_import_list_header_id
18583: and b2b.load_status in ('ACTIVE','RELOAD')
18584: and b2b.org_exist = 'Y'

Line 18599: from hz_party_sites psite, hz_locations loc,

18595: group by b2b.import_source_line_id;
18596:
18597: cursor c_country is
18598: select b2b.import_source_line_id, max(psite.party_id)
18599: from hz_party_sites psite, hz_locations loc,
18600: hz_parties party, ams_hz_b2b_mapping_v b2b
18601: where b2b.import_list_header_id = p_import_list_header_id
18602: and b2b.load_status in ('ACTIVE','RELOAD')
18603: and b2b.org_exist = 'Y'

Line 18850: from hz_party_sites psite, hz_locations loc,

18846:
18847:
18848: cursor c_address_country is
18849: select b2b.import_source_line_id, max(psite.party_id)
18850: from hz_party_sites psite, hz_locations loc,
18851: hz_parties party, ams_hz_b2b_mapping_v b2b
18852: where b2b.import_list_header_id = p_import_list_header_id
18853: and b2b.load_status in ('ACTIVE','RELOAD')
18854: and b2b.org_exist = 'Y'

Line 18870: from hz_party_sites psite, hz_locations loc,

18866: group by b2b.import_source_line_id;
18867:
18868: cursor c_country is
18869: select b2b.import_source_line_id, max(psite.party_id)
18870: from hz_party_sites psite, hz_locations loc,
18871: hz_parties party, ams_hz_b2b_mapping_v b2b
18872: where b2b.import_list_header_id = p_import_list_header_id
18873: and b2b.load_status in ('ACTIVE','RELOAD')
18874: and b2b.org_exist = 'Y'

Line 19162: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c

19158: group by b2c.import_source_line_id;
19159:
19160: cursor c_address_country is
19161: select b2c.import_source_line_id, max(psite.party_id)
19162: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c
19163: where b2c.import_list_header_id = p_import_list_header_id
19164: and b2c.load_status in ('ACTIVE','RELOAD')
19165: and b2c.person_exist = 'Y'
19166: and b2c.address1 is not null

Line 19478: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c

19474: group by b2c.import_source_line_id;
19475:
19476: cursor c_address_country is
19477: select b2c.import_source_line_id, max(psite.party_id)
19478: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c
19479: where b2c.import_list_header_id = p_import_list_header_id
19480: and b2c.load_status in ('ACTIVE','RELOAD')
19481: and b2c.person_exist = 'Y'
19482: and b2c.address1 is not null

Line 20393: from hz_party_sites ps, hz_locations loc,ams_hz_b2b_mapping_v b2b

20389: and b2b.address1 is not null;
20390:
20391: cursor c_addr_ps is
20392: select b2b.import_source_line_id,max(loc.location_id)
20393: from hz_party_sites ps, hz_locations loc,ams_hz_b2b_mapping_v b2b
20394: where b2b.import_list_header_id = p_import_list_header_id
20395: and b2b.load_status in ('ACTIVE','RELOAD')
20396: and b2b.address_key is not null
20397: and b2b.org_party_id is not null

Line 20407: from hz_locations loc,ams_hz_b2b_mapping_v b2b

20403: group by b2b.import_source_line_id;
20404:
20405: cursor c_addr is
20406: select b2b.import_source_line_id,max(loc.location_id)
20407: from hz_locations loc,ams_hz_b2b_mapping_v b2b
20408: where b2b.import_list_header_id = p_import_list_header_id
20409: and b2b.load_status in ('ACTIVE','RELOAD')
20410: and b2b.address_key is not null
20411: and b2b.party_location_id is null

Line 20551: from hz_party_sites ps, hz_locations loc,ams_hz_b2b_mapping_v b2b

20547: and b2b.org_address1 is not null;
20548:
20549: cursor c_addr_ps is
20550: select b2b.import_source_line_id,max(loc.location_id)
20551: from hz_party_sites ps, hz_locations loc,ams_hz_b2b_mapping_v b2b
20552: where b2b.import_list_header_id = p_import_list_header_id
20553: and b2b.load_status in ('ACTIVE','RELOAD')
20554: and b2b.org_address_key is not null
20555: and b2b.org_party_id is not null

Line 20565: from hz_locations loc,ams_hz_b2b_mapping_v b2b

20561: group by b2b.import_source_line_id;
20562:
20563: cursor c_addr is
20564: select b2b.import_source_line_id,max(loc.location_id)
20565: from hz_locations loc,ams_hz_b2b_mapping_v b2b
20566: where b2b.import_list_header_id = p_import_list_header_id
20567: and b2b.load_status in ('ACTIVE','RELOAD')
20568: and b2b.org_address_key is not null
20569: and b2b.org_location_id is null

Line 20709: from hz_party_sites ps, hz_locations loc,ams_hz_b2c_mapping_v b2c

20705: and b2c.address1 is not null;
20706:
20707: cursor c_addr_ps is
20708: select b2c.import_source_line_id,max(loc.location_id)
20709: from hz_party_sites ps, hz_locations loc,ams_hz_b2c_mapping_v b2c
20710: where b2c.import_list_header_id = p_import_list_header_id
20711: and b2c.load_status in ('ACTIVE','RELOAD')
20712: and b2c.address_key is not null
20713: and b2c.person_party_id is not null

Line 20723: from hz_locations loc,ams_hz_b2c_mapping_v b2c

20719: group by b2c.import_source_line_id;
20720:
20721: cursor c_addr is
20722: select b2c.import_source_line_id,max(loc.location_id)
20723: from hz_locations loc,ams_hz_b2c_mapping_v b2c
20724: where b2c.import_list_header_id = p_import_list_header_id
20725: and b2c.load_status in ('ACTIVE','RELOAD')
20726: and b2c.address_key is not null
20727: and b2c.party_location_id is null