VIEW: APPS.HR_ORGANIZATION_UNITS_V

Source

View Text - Preformatted

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 , O.OBJECT_VERSION_NUMBER , O.ATTRIBUTE21 , O.ATTRIBUTE22 , O.ATTRIBUTE23 , O.ATTRIBUTE24 , O.ATTRIBUTE25 , O.ATTRIBUTE26 , O.ATTRIBUTE27 , O.ATTRIBUTE28 , O.ATTRIBUTE29 , O.ATTRIBUTE30 FROM HR_ORGANIZATION_UNITS O, HR_LOOKUPS L, HR_LOOKUPS L2, HR_LOCATIONS_ALL_V 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 (+)

View Text - HTML Formatted

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
, O.OBJECT_VERSION_NUMBER
, O.ATTRIBUTE21
, O.ATTRIBUTE22
, O.ATTRIBUTE23
, O.ATTRIBUTE24
, O.ATTRIBUTE25
, O.ATTRIBUTE26
, O.ATTRIBUTE27
, O.ATTRIBUTE28
, O.ATTRIBUTE29
, O.ATTRIBUTE30
FROM HR_ORGANIZATION_UNITS O
, HR_LOOKUPS L
, HR_LOOKUPS L2
, HR_LOCATIONS_ALL_V 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 (+)