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_PARTY_SITES

Line 424: hz_party_sites party_site,

420: struct.location_id_segment_8,
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

Line 949: from hz_party_sites party_site,

945: last_updated_by = arp_standard.profile.user_id,
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

Line 1310: hz_party_sites p,

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

Line 1389: hz_party_sites party_site,

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