[Home] [Help]
View: BEN_POPL_ORG_ROLE_D
View Text
SELECT CPR.ROWID ROW_ID
, CPR.POPL_ORG_ROLE_ID
, CPR.EFFECTIVE_START_DATE
, CPR.EFFECTIVE_END_DATE
, CPR.NAME
, POPL_ORG.CSTMR_NUM
, POPL_ORG.PLCY_R_GRP
, CPR.LAST_UPDATE_DATE
, FUSER.USER_NAME
, ROLE_TYP.MEANING
FROM BEN_POPL_ORG_ROLE_F CPR
, FND_USER_VIEW FUSER
, BEN_POPL_ORG_F POPL_ORG
, HR_LOOKUPS ROLE_TYP
WHERE FUSER.USER_ID (+)= CPR.LAST_UPDATED_BY
AND POPL_ORG.POPL_ORG_ID (+)= CPR.POPL_ORG_ID
AND ROLE_TYP.LOOKUP_CODE (+)= CPR.ORG_ROLE_TYP_CD
AND ROLE_TYP.LOOKUP_TYPE (+)= 'BEN_ORG_ROLE_TYP'
Columns
Name |
ROW_ID |
POPL_ORG_ROLE_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
NAME |
POPL_ORG_CSTMR_NUM |
POPL_ORG_PLCY_R_GRP |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
ORG_ROLE_TYP_MEANING |