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 13483: from hz_party_sites ps, hz_locations loc

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

Line 13492: from hz_locations loc

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

Line 18579: from hz_party_sites psite, hz_locations loc,

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

Line 18598: from hz_party_sites psite, hz_locations loc,

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

Line 18849: from hz_party_sites psite, hz_locations loc,

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

Line 18869: from hz_party_sites psite, hz_locations loc,

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

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

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

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

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

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

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

Line 20406: from hz_locations loc,ams_hz_b2b_mapping_v b2b

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

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

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

Line 20564: from hz_locations loc,ams_hz_b2b_mapping_v b2b

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

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

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

Line 20722: from hz_locations loc,ams_hz_b2c_mapping_v b2c

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