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_CUST_ACCT_SITES

Line 427: hz_cust_acct_sites acct_site

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
431: and loc.location_id = loc_assign.location_id

Line 952: hz_cust_acct_sites acct_site,

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
956: and acct_site.party_site_id =

Line 1309: hz_cust_acct_sites a,

1305: 'EXPIRED', 3000, 4000 )
1306: DISPLAY_ORDER
1307: from
1308: hz_cust_site_uses s,
1309: hz_cust_acct_sites a,
1310: hz_party_sites p,
1311: hz_loc_assignments la,
1312: ra_tax_exemptions x,
1313: ar_location_combinations c

Line 1386: hz_cust_acct_sites acct_site,

1382: c.location_id_segment_8,
1383: c.location_id_segment_9,
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