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 321: l_party_site_number hz_party_sites.party_site_number%TYPE;

317: x_msg_data OUT nocopy VARCHAR2,
318: x_party_site_id OUT nocopy NUMBER
319: )
320: IS
321: l_party_site_number hz_party_sites.party_site_number%TYPE;
322: l_party_site_id NUMBER;
323: l_location_id NUMBER;
324: l_party_site_use_id NUMBER;
325: l_ou_ids pos_security_profile_utl_pkg.number_table;

Line 583: FROM hz_party_sites

579: SELECT object_version_number,location_id
580: from hz_locations
581: where location_id =
582: (SELECT location_id
583: FROM hz_party_sites
584: WHERE party_site_id = p_party_site_id
585: ) FOR UPDATE;
586:
587: l_rec l_cur%ROWTYPE;

Line 591: from hz_party_sites

587: l_rec l_cur%ROWTYPE;
588:
589: CURSOR l_cur2 IS
590: select object_version_number, party_site_name
591: from hz_party_sites
592: where party_site_id = p_party_site_id FOR UPDATE;
593:
594: l_rec2 l_cur2%ROWTYPE;
595: