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_LOC_ASSIGNMENTS

Line 425: hz_loc_assignments loc_assign,

421: struct.location_id_segment_9,
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

Line 950: hz_loc_assignments loc_assign,

946: program_id = arp_standard.profile.program_id,
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 =

Line 1311: hz_loc_assignments la,

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
1314: WHERE la.loc_id = c.location_id(+)
1315: and a.party_site_id = p.party_site_id

Line 1387: hz_loc_assignments loc_assign,

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
1391: where site_uses.site_use_id = site_id