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

Line 342: l_party_site_number hz_party_sites.party_site_number%TYPE;

338: x_msg_data OUT nocopy VARCHAR2,
339: x_party_site_id OUT nocopy NUMBER
340: )
341: IS
342: l_party_site_number hz_party_sites.party_site_number%TYPE;
343: l_party_site_id NUMBER;
344: l_location_id NUMBER;
345: l_party_site_use_id NUMBER;
346: l_ou_ids pos_security_profile_utl_pkg.number_table;

Line 667: FROM hz_party_sites

663: SELECT object_version_number,location_id
664: from hz_locations
665: where location_id =
666: (SELECT location_id
667: FROM hz_party_sites
668: WHERE party_site_id = p_party_site_id
669: ) FOR UPDATE;
670:
671: l_rec l_cur%ROWTYPE;

Line 675: from hz_party_sites

671: l_rec l_cur%ROWTYPE;
672:
673: CURSOR l_cur2 IS
674: select object_version_number, party_site_name
675: from hz_party_sites
676: where party_site_id = p_party_site_id FOR UPDATE;
677:
678: l_rec2 l_cur2%ROWTYPE;
679: