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.POA_EDW_GEOGRAPHY_M_SIZE dependencies on HZ_LOCATIONS

Line 28: HZ_LOCATIONS hzl,

24: where last_update_date between p_from_date and p_to_date
25: union all
26: select count(*) cnt
27: from
28: HZ_LOCATIONS hzl,
29: HZ_PARTIES hzp,
30: HZ_PARTY_SITES hzps
31: WHERE hzps.location_id = hzl.location_id
32: AND hzps.party_id = hzp.party_id

Line 171: from HZ_LOCATIONS where last_update_date

167: avg(nvl(vsize(address1),0)),
168: avg(nvl(vsize(address2),0)),
169: avg(nvl(vsize(address3),0)),
170: avg(nvl(vsize(address4),0))
171: from HZ_LOCATIONS where last_update_date
172: between p_from_date and p_to_date;
173:
174: cursor c4 is
175: select avg(nvl(vsize(party_site_id),0)),

Line 451: ----------------- From HZ_LOCATIONS and Party_Sites ------------------

447: + NVL (ceil(x_NAME + 1), 0)
448: + NVL (ceil(x_AREA2_FK + 1), 0));
449:
450:
451: ----------------- From HZ_LOCATIONS and Party_Sites ------------------
452:
453: OPEN c3;
454: FETCH c3 into x_city, x_postal_code, x_state, x_province,
455: x_country, x_ADDRESS1, x_ADDRESS2, x_ADDRESS3, x_ADDRESS4;