VIEW: APPS.PER_ORGANIZATION_UNITS_V

Source

View Text - Preformatted

SELECT O.ORGANIZATION_ID , O.ROWID , O.BUSINESS_GROUP_ID , O.COST_ALLOCATION_KEYFLEX_ID , O.LOCATION_ID , O.SOFT_CODING_KEYFLEX_ID , O.DATE_FROM , OTL.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_ALL_ORGANIZATION_UNITS O, HR_ALL_ORGANIZATION_UNITS_TL OTL, HR_ORGANIZATION_INFORMATION O2, HR_LOOKUPS L, HR_LOOKUPS L2 WHERE O.TYPE = L.LOOKUP_CODE (+) AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+) AND O2.ORG_INFORMATION_CONTEXT (+) = 'Work Day Information' AND L.LOOKUP_TYPE (+) = 'ORG_TYPE' AND O.INTERNAL_EXTERNAL_FLAG = L2.LOOKUP_CODE (+) AND L2.LOOKUP_TYPE (+) = 'INTL_EXTL' AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID AND OTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT O.ORGANIZATION_ID
, O.ROWID
, O.BUSINESS_GROUP_ID
, O.COST_ALLOCATION_KEYFLEX_ID
, O.LOCATION_ID
, O.SOFT_CODING_KEYFLEX_ID
, O.DATE_FROM
, OTL.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_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
, HR_LOOKUPS L
, HR_LOOKUPS L2
WHERE O.TYPE = L.LOOKUP_CODE (+)
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O2.ORG_INFORMATION_CONTEXT (+) = 'WORK DAY INFORMATION'
AND L.LOOKUP_TYPE (+) = 'ORG_TYPE'
AND O.INTERNAL_EXTERNAL_FLAG = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'INTL_EXTL'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')