[Home] [Help]
View: PQH_POSITION_ROLES_V
View Text
SELECT POSITION_EXTRA_INFO_ID
, PEI.POSITION_ID POSITION_ID
, POS.NAME POSITION_NAME
, DECODE(INFORMATION_TYPE
, 'PQH_POS_ROLE_ID'
, TO_NUMBER(POEI_INFORMATION3)
, -1) ROLE_ID
, RLS.ROLE_NAME
, RLS.ENABLE_FLAG ROLE_ENABLE_FLAG
, PEI.LAST_UPDATE_DATE
, PEI.LAST_UPDATED_BY
, PEI.LAST_UPDATE_LOGIN
, PEI.CREATED_BY
, PEI.CREATION_DATE
, PEI.OBJECT_VERSION_NUMBER
FROM PER_POSITION_EXTRA_INFO PEI
, HR_ALL_POSITIONS POS
, PQH_ROLES RLS
WHERE PEI.POSITION_ID=POS.POSITION_ID
AND PEI.INFORMATION_TYPE='PQH_POS_ROLE_ID'
AND PEI.POEI_INFORMATION3 = RLS.ROLE_ID
Columns
Name |
POSITION_EXTRA_INFO_ID |
POSITION_ID |
POSITION_NAME |
ROLE_ID |
ROLE_NAME |
ROLE_ENABLE_FLAG |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
OBJECT_VERSION_NUMBER |