[Home] [Help]
View: PQH_CORPS_EXAMS_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
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_EXAM_TYPE'
, INFORMATION3) EXAMINATION_TYPE
, INFORMATION3 EXAMINATION_TYPE_CD
, ORG.NAME INSTITUTION_NAME
, CEI.INFORMATION4 INSTITUTION_ID
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_WAYS'
, INFORMATION5) JOINING_WAY
, INFORMATION5 JOINING_WAY_CD
, INFORMATION6 MANDATORY_FLAG
FROM PQH_CORPS_EXTRA_INFO CEI
, HR_ORGANIZATION_UNITS ORG
WHERE ORG.ORGANIZATION_ID = CEI.INFORMATION4
AND CEI.INFORMATION_TYPE ='EXAM'
Columns
Name |
CORPS_DEFINITION_ID |
CORPS_EXTRA_INFO_ID |
OBJECT_VERSION_NUMBER |
INFORMATION_TYPE |
EXAMINATION_TYPE |
EXAMINATION_TYPE_CD |
INSTITUTION_NAME |
INSTITUTION_ID |
JOINING_WAY |
JOINING_WAY_CD |
MANDATORY_FLAG |