[Home] [Help]
View: PQH_CORPS_RULES_V
View Text
SELECT CORPS_DEFINITION_ID CORPS_DEFINITION_ID
, CORPS_EXTRA_INFO_ID CORPS_EXTRA_INFO_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INFORMATION_TYPE INFORMATION_TYPE
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_WAYS'
, INFORMATION3) JOINING_WAY
, INFORMATION3 JOINING_WAY_CD
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_WAYS_CRITERIA'
, INFORMATION4) SITUATION
, INFORMATION4 SITUATION_CD
, INFORMATION5 VALUE
, INFORMATION6 UOM
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, INFORMATION6) UOM_DESC
, INFORMATION7 MANDATORY_FLAG
FROM PQH_CORPS_EXTRA_INFO
WHERE INFORMATION_TYPE = 'RULES'
Columns
Name |
CORPS_DEFINITION_ID |
CORPS_EXTRA_INFO_ID |
OBJECT_VERSION_NUMBER |
INFORMATION_TYPE |
JOINING_WAY |
JOINING_WAY_CD |
SITUATION |
SITUATION_CD |
VALUE |
UOM |
UOM_DESC |
MANDATORY_FLAG |