VIEW: APPS.HR_H2PI_ADDRESSES_V

Source

View Text - Preformatted

SELECT pa.last_update_date, pa.business_group_id, pa.address_id, pa.person_id, pa.style, pa.date_from, pa.date_to, pa.address_type, pa.address_line1, pa.address_line2, pa.address_line3, pa.town_or_city, pa.region_1, pa.region_2, pa.region_3, pa.postal_code, pa.country, pa.telephone_number_1, pa.telephone_number_2, pa.telephone_number_3, pa.add_information13, pa.add_information14, pa.add_information15, pa.add_information16, pa.add_information17, pa.add_information18, pa.add_information19, pa.add_information20, pa.addr_attribute_category, pa.addr_attribute1, pa.addr_attribute2, pa.addr_attribute3, pa.addr_attribute4, pa.addr_attribute5, pa.addr_attribute6, pa.addr_attribute7, pa.addr_attribute8, pa.addr_attribute9, pa.addr_attribute10, pa.addr_attribute11, pa.addr_attribute12, pa.addr_attribute13, pa.addr_attribute14, pa.addr_attribute15, pa.addr_attribute16, pa.addr_attribute17, pa.addr_attribute18, pa.addr_attribute19, pa.addr_attribute20 from per_addresses pa WHERE pa.primary_flag = 'Y' and EXISTS (select pp.person_id from hr_h2pi_employees_v pp where pp.person_id = pa.person_id)

View Text - HTML Formatted

SELECT PA.LAST_UPDATE_DATE
, PA.BUSINESS_GROUP_ID
, PA.ADDRESS_ID
, PA.PERSON_ID
, PA.STYLE
, PA.DATE_FROM
, PA.DATE_TO
, PA.ADDRESS_TYPE
, PA.ADDRESS_LINE1
, PA.ADDRESS_LINE2
, PA.ADDRESS_LINE3
, PA.TOWN_OR_CITY
, PA.REGION_1
, PA.REGION_2
, PA.REGION_3
, PA.POSTAL_CODE
, PA.COUNTRY
, PA.TELEPHONE_NUMBER_1
, PA.TELEPHONE_NUMBER_2
, PA.TELEPHONE_NUMBER_3
, PA.ADD_INFORMATION13
, PA.ADD_INFORMATION14
, PA.ADD_INFORMATION15
, PA.ADD_INFORMATION16
, PA.ADD_INFORMATION17
, PA.ADD_INFORMATION18
, PA.ADD_INFORMATION19
, PA.ADD_INFORMATION20
, PA.ADDR_ATTRIBUTE_CATEGORY
, PA.ADDR_ATTRIBUTE1
, PA.ADDR_ATTRIBUTE2
, PA.ADDR_ATTRIBUTE3
, PA.ADDR_ATTRIBUTE4
, PA.ADDR_ATTRIBUTE5
, PA.ADDR_ATTRIBUTE6
, PA.ADDR_ATTRIBUTE7
, PA.ADDR_ATTRIBUTE8
, PA.ADDR_ATTRIBUTE9
, PA.ADDR_ATTRIBUTE10
, PA.ADDR_ATTRIBUTE11
, PA.ADDR_ATTRIBUTE12
, PA.ADDR_ATTRIBUTE13
, PA.ADDR_ATTRIBUTE14
, PA.ADDR_ATTRIBUTE15
, PA.ADDR_ATTRIBUTE16
, PA.ADDR_ATTRIBUTE17
, PA.ADDR_ATTRIBUTE18
, PA.ADDR_ATTRIBUTE19
, PA.ADDR_ATTRIBUTE20
FROM PER_ADDRESSES PA
WHERE PA.PRIMARY_FLAG = 'Y'
AND EXISTS (SELECT PP.PERSON_ID
FROM HR_H2PI_EMPLOYEES_V PP
WHERE PP.PERSON_ID = PA.PERSON_ID)