View: PER_ADDRESSES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_ADDRESSES_V

View Text

SELECT PA.ROWID ROW_ID
, PA.ADDRESS_ID
, PA.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PA.PERSON_ID
, PA.DATE_FROM
, PA.PRIMARY_FLAG
, PA.STYLE
, TL.DESCRIPTIVE_FLEX_CONTEXT_NAME D_STYLE
, PA.ADDRESS_LINE1
, PA.ADDRESS_LINE2
, PA.ADDRESS_LINE3
, PA.ADDRESS_TYPE
, HL1.MEANING D_ADDRESS_TYPE
, PA.COMMENTS
, PA.COUNTRY
, T.TERRITORY_SHORT_NAME D_COUNTRY
, PA.DATE_TO
, PA.POSTAL_CODE
, PA.REGION_1
, PA.REGION_2
, PA.REGION_3
, PA.TELEPHONE_NUMBER_1
, PA.TELEPHONE_NUMBER_2
, PA.TELEPHONE_NUMBER_3
, PA.TOWN_OR_CITY
, 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
, PA.REQUEST_ID
, PA.PROGRAM_APPLICATION_ID
, PA.PROGRAM_ID
, PA.PROGRAM_UPDATE_DATE
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.CREATED_BY
, PA.CREATION_DATE
, 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.OBJECT_VERSION_NUMBER
, PA.PARTY_ID
FROM FND_TERRITORIES_VL T
, FND_DESCR_FLEX_CONTEXTS_TL TL
, HR_LOOKUPS HL1
, PER_ADDRESSES PA
WHERE PA.COUNTRY = T.TERRITORY_CODE (+)
AND PA.STYLE = TL.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND TL.APPLICATION_ID = 800
AND TL.DESCRIPTIVE_FLEXFIELD_NAME = 'ADDRESS STRUCTURE'
AND TL.LANGUAGE = USERENV('LANG')
AND HL1.LOOKUP_TYPE(+) = 'ADDRESS_TYPE'
AND PA.ADDRESS_TYPE = HL1.LOOKUP_CODE (+)

Columns