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.AR_RAXSKI_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 172: hz_party_sites party_site,

168:
169: select count(*)
170: into v_addresses_t
171: from hz_cust_acct_sites acct_site,
172: hz_party_sites party_site,
173: hz_loc_assignments loc_assign
174: where acct_site.party_site_id = party_site.party_site_id
175: and party_site.location_id = loc_assign.location_id
176: and nvl(acct_site.org_id, -99) = nvl(loc_assign.org_id,-99)

Line 184: hz_party_sites party_site,

180:
181: select count(*)
182: into prior_v_addresses_t
183: from hz_cust_acct_sites acct_site,
184: hz_party_sites party_site,
185: hz_loc_assignments loc_assign
186: where acct_site.party_site_id = party_site.party_site_id
187: and party_site.location_id = loc_assign.location_id
188: and nvl(acct_site.org_id, -99) = nvl(loc_assign.org_id,-99)

Line 196: hz_party_sites party_site,

192:
193: select count(*)
194: into address_total_number_t
195: from hz_cust_acct_sites acct_site,
196: hz_party_sites party_site,
197: hz_loc_assignments loc_assign
198: where acct_site.party_site_id = party_site.party_site_id
199: and party_site.location_id = loc_assign.location_id
200: and nvl(acct_site.org_id, -99) = nvl(loc_assign.org_id,-99);