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

Line 128: hz_party_sites hzs,

124: select p.party_id from
125: (SELECT column_value party_id FROM TABLE (CAST( x_matched_id AS JTF_NUMBER_TABLE)) ) p
126: ) tmp,
127: hz_parties org,
128: hz_party_sites hzs,
129: hz_locations hzl,
130: hz_contact_points cp,
131: pv_partner_profiles pvpp
132: where tmp.party_id = pvpp.partner_id

Line 716: ' hz_party_sites hzs, ' ||

712: ' hzl.country, '||
713: ' hzl.postal_code, '||
714: ' rownum rn '||
715: ' from hz_parties org, ' ||
716: ' hz_party_sites hzs, ' ||
717: ' hz_locations hzl, '||
718: ' pv_partner_profiles pvpp, '||
719: ' (SELECT * ' ||
720: ' FROM (SELECT column_value party_id ' ||

Line 774: hz_party_sites hzs,

770: pvpp.partner_id party_id, org.party_name, hzl.address1,
771: hzl.address2, hzl.address3, hzl.city, hzl.state, hzl.country,
772: hzl.postal_code, rownum rn
773: FROM hz_parties org,
774: hz_party_sites hzs,
775: hz_locations hzl,
776: pv_partner_profiles pvpp,
777: (SELECT *
778: FROM (SELECT column_value party_id