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

Line 637: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

633: ,ps.IDENTIFYING_ADDRESS_FLAG
634: ,ps.MAILSTOP
635: ,ps.PARTY_SITE_NAME
636: ,ps.PARTY_SITE_NUMBER
637: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
638: WHERE ps.party_site_id = p_party_site_id
639: AND ps.location_id = l.location_id
640: AND (ps.status is null OR ps.status = 'A' or ps.status = 'I');
641:

Line 1418: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

1414:
1415: CURSOR c_party_site IS
1416: SELECT rtrim(l.address1 || ' ' || l.address2 || ' ' ||
1417: l.address3 || ' ' || l.address4), rtrim(l.address1)
1418: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
1419: WHERE ps.party_site_id = p_party_site_id
1420: AND ps.location_id = l.location_id;
1421:
1422: l_address VARCHAR2(4000);