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_LOC_ASSIGNMENTS

Line 173: hz_loc_assignments loc_assign

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)
177: and acct_site.creation_date between p_start_date

Line 185: hz_loc_assignments loc_assign

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)
189: and acct_site.creation_date between p_prior_start_date

Line 197: hz_loc_assignments loc_assign

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);
201: