View: HR_ORGANIZATION_UNITS_V

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

View Text

SELECT O.ORGANIZATION_ID
, O.ROW_ID
, O.BUSINESS_GROUP_ID
, O.COST_ALLOCATION_KEYFLEX_ID
, O.LOCATION_ID
, LOC.LOCATION_CODE
, LOC.STYLE
, LOC.COUNTRY
, LOC.ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3
, LOC.REGION_1
, LOC.REGION_2
, LOC.REGION_3
, LOC.TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2
, LOC.TELEPHONE_NUMBER_3
, LOC.POSTAL_CODE
, LOC.TOWN_OR_CITY
, LOC.LOC_INFORMATION13
, LOC.LOC_INFORMATION14
, LOC.LOC_INFORMATION15
, LOC.LOC_INFORMATION16
, LOC.LOC_INFORMATION17
, LOC.LOC_INFORMATION18
, LOC.LOC_INFORMATION19
, LOC.LOC_INFORMATION20
, O.SOFT_CODING_KEYFLEX_ID
, O.DATE_FROM
, O.NAME
, O.COMMENTS
, O.DATE_TO
, O.INTERNAL_EXTERNAL_FLAG
, L2.MEANING
, O.INTERNAL_ADDRESS_LINE
, O.TYPE
, L.MEANING
, O.REQUEST_ID
, O.PROGRAM_APPLICATION_ID
, O.PROGRAM_ID
, O.PROGRAM_UPDATE_DATE
, O.ATTRIBUTE_CATEGORY
, O.ATTRIBUTE1
, O.ATTRIBUTE2
, O.ATTRIBUTE3
, O.ATTRIBUTE4
, O.ATTRIBUTE5
, O.ATTRIBUTE6
, O.ATTRIBUTE7
, O.ATTRIBUTE8
, O.ATTRIBUTE9
, O.ATTRIBUTE10
, O.ATTRIBUTE11
, O.ATTRIBUTE12
, O.ATTRIBUTE13
, O.ATTRIBUTE14
, O.ATTRIBUTE15
, O.ATTRIBUTE16
, O.ATTRIBUTE17
, O.ATTRIBUTE18
, O.ATTRIBUTE19
, O.ATTRIBUTE20
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
, O.LAST_UPDATE_LOGIN
, O.CREATED_BY
, O.CREATION_DATE
FROM HR_ORGANIZATION_UNITS O
, HR_LOOKUPS L
, HR_LOOKUPS L2
, HR_LOCATIONS_NO_JOIN LOC
WHERE O.TYPE = L.LOOKUP_CODE (+)
AND L.LOOKUP_TYPE (+) = 'ORG_TYPE'
AND O.INTERNAL_EXTERNAL_FLAG = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'INTL_EXTL'
AND O.LOCATION_ID = LOC.LOCATION_ID (+)

Columns