[Home] [Help]
View: PER_ORGANIZATION_UNITS_LOV
View Text
SELECT ORG.ORGANIZATION_ID
, ORG.NAME
, PL.MEANING
, ORG.INTERNAL_EXTERNAL_FLAG
, ORG.BUSINESS_GROUP_ID + 0
FROM HR_LOOKUPS PL
, PER_ORGANIZATION_UNITS ORG
WHERE ORG.TYPE = PL.LOOKUP_CODE(+)
AND PL.LOOKUP_TYPE(+) = 'ORG_TYPE'
Columns
Name |
ORGANIZATION_ID |
NAME |
TYPE |
INTERNAL_EXTERNAL_FLAG |
BUSINESS_GROUP_ID |