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

Line 426: hz_locations loc,

422: struct.location_id_segment_10
423: from ar_location_combinations struct,
424: hz_party_sites party_site,
425: hz_loc_assignments loc_assign,
426: hz_locations loc,
427: hz_cust_acct_sites acct_site
428: where struct.location_id = loc_assign.loc_id
429: and acct_site.party_site_id = party_site.party_site_id
430: and loc.location_id = party_site.location_id

Line 951: hz_locations loc,

947: program_application_id = arp_standard.profile.program_application_id
948: where location_id in ( select loc_assign.loc_id
949: from hz_party_sites party_site,
950: hz_loc_assignments loc_assign,
951: hz_locations loc,
952: hz_cust_acct_sites acct_site,
953: hz_cust_site_uses site_uses
954: where site_uses.cust_acct_site_id =
955: acct_site.cust_acct_site_id

Line 1388: hz_locations loc,

1384: c.location_id_segment_10
1385: from ar_location_combinations c,
1386: hz_cust_acct_sites acct_site,
1387: hz_loc_assignments loc_assign,
1388: hz_locations loc,
1389: hz_party_sites party_site,
1390: hz_cust_site_uses site_uses
1391: where site_uses.site_use_id = site_id
1392: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id