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.OZF_PRE_PROCESS_PVT dependencies on HZ_LOCATIONS

Line 5193: hz_locations hl

5189: hz_parties hp,
5190: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5191: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5192: hz_party_sites hps,
5193: hz_locations hl
5194: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5195: AND hcas.party_site_id = hps.party_site_id
5196: AND hcsu.status = 'A'
5197: AND hps.location_id = hl.location_id

Line 5221: hz_locations hl

5217: hz_parties hp,
5218: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5219: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5220: hz_party_sites hps,
5221: hz_locations hl
5222: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5223: AND hcas.party_site_id = hps.party_site_id
5224: AND hcsu.status = 'A'
5225: AND hps.location_id = hl.location_id

Line 5307: hz_locations hl

5303: hz_parties hp,
5304: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5305: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5306: hz_party_sites hps,
5307: hz_locations hl
5308: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5309: AND hcas.party_site_id = hps.party_site_id
5310: AND hcsu.status = 'A'
5311: AND hps.location_id = hl.location_id

Line 5335: , hz_locations loc

5331: , party.party_id
5332: , party.party_name
5333: FROM hz_parties party
5334: , hz_party_sites site
5335: , hz_locations loc
5336: , hz_party_site_uses use
5337: WHERE site.location_id = loc.location_id
5338: AND party.party_id = site.party_id
5339: AND party.status = 'A'