FND Design Data [Home] [Help]

View: BEN_PRTT_RMT_RQST_CTFN_PRVDD_D

Product: BEN - Advanced Benefits
Description:
Implementation/DBA Data: ViewAPPS.BEN_PRTT_RMT_RQST_CTFN_PRVDD_D
View Text

SELECT PQC.ROWID ROW_ID
, PQC.PRTT_RMT_RQST_CTFN_PRVDD_ID
, PQC.PRTT_CLM_GD_OR_SVC_TYP_ID
, PQC.PL_GD_R_SVC_CTFN_ID
, PQC.EFFECTIVE_START_DATE
, PQC.EFFECTIVE_END_DATE
, PQC.REIMBMT_CTFN_RQD_FLAG
, PQC.BUSINESS_GROUP_ID
, PQC.PRTT_ENRT_ACTN_ID
, PQC.REIMBMT_CTFN_RECD_DT
, PQC.REIMBMT_CTFN_DND_DT
, PQC.REIMBMT_CTFN_TYP_CD
, PQC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PRTT_RMT_RQST_CTFN_PRVDD_F PQC
, FND_USER FUSER
WHERE FUSER.USER_ID(+)= PQC.LAST_UPDATED_BY

Columns

Name
ROW_ID
PRTT_RMT_RQST_CTFN_PRVDD_ID
PRTT_CLM_GD_OR_SVC_TYP_ID
PL_GD_R_SVC_CTFN_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
REIMBMT_CTFN_RQD_FLAG
BUSINESS_GROUP_ID
PRTT_ENRT_ACTN_ID
REIMBMT_CTFN_RECD_DT
REIMBMT_CTFN_DND_DT
REIMBMT_CTFN_TYP_CD
LAST_UPDATE_DATE
LAST_UPDATED_BY