VIEW: APPS.PER_ADDRESSES_V

Source

View Text - Preformatted

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_TL 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 (+) AND T.LANGUAGE (+) = userenv('LANG')

View Text - HTML Formatted

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_TL 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 (+)
AND T.LANGUAGE (+) = USERENV('LANG')