[Home] [Help]
View: BEN_ACTY_RT_PTD_LMT_D
View Text
SELECT APL.ROWID ROW_ID
, APL.ACTY_RT_PTD_LMT_ID
, APL.EFFECTIVE_START_DATE
, APL.EFFECTIVE_END_DATE
, ACTY_BASE_RT.NAME
, PTD_LMT.NAME
, APL.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ACTY_RT_PTD_LMT_F APL
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, BEN_PTD_LMT_F PTD_LMT
WHERE FUSER.USER_ID (+)= APL .LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= APL .ACTY_BASE_RT_ID
AND PTD_LMT.PTD_LMT_ID (+)= APL .PTD_LMT_ID
Columns
Name |
ROW_ID |
ACTY_RT_PTD_LMT_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
ACTY_BASE_RT_NAME |
PTD_LMT_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |