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.RRS_SITE_INFO dependencies on HZ_PARTY_SITE_USES

Line 384: HZ_PARTY_SITE_USES HPSU,

380: BULK COLLECT
381: INTO site_use_rec_details
382: FROM RRS_SITE_USES SiteUseEO,
383: RRS_SITES_B RSB,
384: HZ_PARTY_SITE_USES HPSU,
385: AR_LOOKUPS LKUP1
386: -- ,RRS_LOOKUPS_V LKUP2
387: ,RRS_LOOKUPS_V LKUP3
388: WHERE RSB.SITE_ID = SiteUseEO.SITE_ID

Line 1825: , HZ_PARTY_SITE_USES PSU

1821: INTO l_site_party_dets
1822: FROM HZ_LOCATIONS HL
1823: ,FND_TERRITORIES_VL FTV
1824: ,HZ_PARTY_SITES HPS
1825: , HZ_PARTY_SITE_USES PSU
1826: WHERE COUNTRY = FTV.TERRITORY_CODE
1827: AND HL.LOCATION_ID = HPS.LOCATION_ID
1828: AND PSU.PARTY_SITE_ID(+) = HPS.PARTY_SITE_ID
1829: AND PSU.STATUS(+) = 'A'