APPS.PV_LOCATOR dependencies on HZ_PARTIES

Line 82: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,

78: type l_partner_rec_type IS RECORD
79: (
80: DISTANCE NUMBER,
81: PARTY_RELATION_ID NUMBER,
82: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
83: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,

Line 90: PARTNER_URL HZ_PARTIES.URL%TYPE,

86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,
91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,
92: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE,
93: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE,
94: row_number NUMBER

Line 127: hz_parties org,

123: (
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

Line 136: and cp.owner_table_name (+) = 'HZ_PARTIES'

132: where tmp.party_id = pvpp.partner_id
133: and org.party_id = pvpp.partner_party_id
134: and org.party_type = 'ORGANIZATION'
135: and org.party_id = cp.owner_table_id (+)
136: and cp.owner_table_name (+) = 'HZ_PARTIES'
137: and cp.contact_point_type (+) = 'PHONE'
138: and cp.primary_flag (+) = 'Y'
139: and org.party_id = hzs.party_id
140: and hzs.location_id = hzl.location_id

Line 468: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,

464: (
465: DISTANCE NUMBER,
466: --rownumber NUMBER,
467: PARTY_RELATION_ID NUMBER,
468: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
469: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,

Line 715: ' from hz_parties org, ' ||

711: ' hzl.state, '||
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 * ' ||

Line 773: FROM hz_parties org,

769: FROM (SELECT pv_locator.geocode_distance(:1,hzl.geometry,:2) dis,
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 *