VIEW: APPS.BEN_PRTT_RMT_RQST_CTFN_PRVDD_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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