[Home] [Help]
View: PQH_CORPS_ORGANIZATIONS_V
View Text
SELECT CEI.CORPS_DEFINITION_ID CORPS_DEFINITION_ID
, CEI.CORPS_EXTRA_INFO_ID CORPS_EXTRA_INFO_ID
, CEI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CEI.INFORMATION_TYPE INFORMATION_TYPE
, INFORMATION3 ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
FROM PQH_CORPS_EXTRA_INFO CEI
, HR_ORGANIZATION_UNITS ORG
WHERE CEI.INFORMATION3 = ORG.ORGANIZATION_ID
AND CEI.INFORMATION_TYPE = 'ORGANIZATION'
Columns
Name |
CORPS_DEFINITION_ID |
CORPS_EXTRA_INFO_ID |
OBJECT_VERSION_NUMBER |
INFORMATION_TYPE |
ORGANIZATION_ID |
ORGANIZATION_NAME |