VIEW: APPS.BEN_LER_CHG_PL_NIP_ENRT_D

Source

View Text - Preformatted

SELECT LPE.LER_CHG_PL_NIP_ENRT_ID , LPE.EFFECTIVE_START_DATE , LPE.EFFECTIVE_END_DATE , LPE.PL_ID , LPE.LER_ID , LPE.TCO_CHG_ENRT_CD , LPE.CRNT_ENRT_PRCLDS_CHG_FLAG , LPE.DFLT_ENRT_CD , LPE.DFLT_ENRT_RL , LPE.DFLT_FLAG , LPE.ENRT_RL , LPE.ENRT_CD , LPE.STL_ELIG_CANT_CHG_FLAG , LPE.ENRT_MTHD_CD , LPE.AUTO_ENRT_MTHD_RL , LPE.LAST_UPDATE_DATE , fuser.user_name FROM BEN_LER_CHG_PL_NIP_ENRT_F LPE, fnd_user fuser WHERE fuser.user_id(+) = lpe.last_updated_by

View Text - HTML Formatted

SELECT LPE.LER_CHG_PL_NIP_ENRT_ID
, LPE.EFFECTIVE_START_DATE
, LPE.EFFECTIVE_END_DATE
, LPE.PL_ID
, LPE.LER_ID
, LPE.TCO_CHG_ENRT_CD
, LPE.CRNT_ENRT_PRCLDS_CHG_FLAG
, LPE.DFLT_ENRT_CD
, LPE.DFLT_ENRT_RL
, LPE.DFLT_FLAG
, LPE.ENRT_RL
, LPE.ENRT_CD
, LPE.STL_ELIG_CANT_CHG_FLAG
, LPE.ENRT_MTHD_CD
, LPE.AUTO_ENRT_MTHD_RL
, LPE.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_LER_CHG_PL_NIP_ENRT_F LPE
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = LPE.LAST_UPDATED_BY