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.

[Home] [Help]

APPS.OZF_PRE_PROCESS_PVT dependencies on HZ_LOCATIONS

Line 5634: hz_locations hl

5630: hz_parties hp,
5631: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5632: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5633: hz_party_sites hps,
5634: hz_locations hl
5635: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5636: AND hcas.party_site_id = hps.party_site_id
5637: AND hcsu.status = 'A'
5638: AND hps.location_id = hl.location_id

Line 5662: hz_locations hl

5658: hz_parties hp,
5659: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5660: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5661: hz_party_sites hps,
5662: hz_locations hl
5663: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5664: AND hcas.party_site_id = hps.party_site_id
5665: AND hcsu.status = 'A'
5666: AND hps.location_id = hl.location_id

Line 5748: hz_locations hl

5744: hz_parties hp,
5745: hz_cust_site_uses hcsu, --hz_cust_site_uses_all hcsu,
5746: hz_cust_acct_sites hcas, --hz_cust_acct_sites_all hcas,
5747: hz_party_sites hps,
5748: hz_locations hl
5749: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
5750: AND hcas.party_site_id = hps.party_site_id
5751: AND hcsu.status = 'A'
5752: AND hps.location_id = hl.location_id

Line 5776: , hz_locations loc

5772: , party.party_id
5773: , party.party_name
5774: FROM hz_parties party
5775: , hz_party_sites site
5776: , hz_locations loc
5777: , hz_party_site_uses use
5778: WHERE site.location_id = loc.location_id
5779: AND party.party_id = site.party_id
5780: AND party.status = 'A'