eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BEN.BEN_PRTT_RMT_RQST_CTFN_PRVDD_#

Source

View Text - Preformatted


select PRTT_RMT_RQST_CTFN_PRVDD_ID PRTT_RMT_RQST_CTFN_PRVDD_ID, PRTT_CLM_GD_OR_SVC_TYP_ID PRTT_CLM_GD_OR_SVC_TYP_ID, PL_GD_R_SVC_CTFN_ID PL_GD_R_SVC_CTFN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, REIMBMT_CTFN_RQD_FLAG REIMBMT_CTFN_RQD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID, REIMBMT_CTFN_RECD_DT REIMBMT_CTFN_RECD_DT, REIMBMT_CTFN_DND_DT REIMBMT_CTFN_DND_DT, REIMBMT_CTFN_TYP_CD REIMBMT_CTFN_TYP_CD, PQC_ATTRIBUTE_CATEGORY PQC_ATTRIBUTE_CATEGORY, PQC_ATTRIBUTE1 PQC_ATTRIBUTE1, PQC_ATTRIBUTE2 PQC_ATTRIBUTE2, PQC_ATTRIBUTE3 PQC_ATTRIBUTE3, PQC_ATTRIBUTE4 PQC_ATTRIBUTE4, PQC_ATTRIBUTE5 PQC_ATTRIBUTE5, PQC_ATTRIBUTE6 PQC_ATTRIBUTE6, PQC_ATTRIBUTE7 PQC_ATTRIBUTE7, PQC_ATTRIBUTE8 PQC_ATTRIBUTE8, PQC_ATTRIBUTE9 PQC_ATTRIBUTE9, PQC_ATTRIBUTE10 PQC_ATTRIBUTE10, PQC_ATTRIBUTE11 PQC_ATTRIBUTE11, PQC_ATTRIBUTE12 PQC_ATTRIBUTE12, PQC_ATTRIBUTE13 PQC_ATTRIBUTE13, PQC_ATTRIBUTE14 PQC_ATTRIBUTE14, PQC_ATTRIBUTE15 PQC_ATTRIBUTE15, PQC_ATTRIBUTE16 PQC_ATTRIBUTE16, PQC_ATTRIBUTE17 PQC_ATTRIBUTE17, PQC_ATTRIBUTE18 PQC_ATTRIBUTE18, PQC_ATTRIBUTE19 PQC_ATTRIBUTE19, PQC_ATTRIBUTE20 PQC_ATTRIBUTE20, PQC_ATTRIBUTE21 PQC_ATTRIBUTE21, PQC_ATTRIBUTE22 PQC_ATTRIBUTE22, PQC_ATTRIBUTE23 PQC_ATTRIBUTE23, PQC_ATTRIBUTE24 PQC_ATTRIBUTE24, PQC_ATTRIBUTE25 PQC_ATTRIBUTE25, PQC_ATTRIBUTE26 PQC_ATTRIBUTE26, PQC_ATTRIBUTE27 PQC_ATTRIBUTE27, PQC_ATTRIBUTE28 PQC_ATTRIBUTE28, PQC_ATTRIBUTE29 PQC_ATTRIBUTE29, PQC_ATTRIBUTE30 PQC_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "BEN"."BEN_PRTT_RMT_RQST_CTFN_PRVDD_F"

View Text - HTML Formatted

SELECT PRTT_RMT_RQST_CTFN_PRVDD_ID PRTT_RMT_RQST_CTFN_PRVDD_ID
, PRTT_CLM_GD_OR_SVC_TYP_ID PRTT_CLM_GD_OR_SVC_TYP_ID
, PL_GD_R_SVC_CTFN_ID PL_GD_R_SVC_CTFN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, REIMBMT_CTFN_RQD_FLAG REIMBMT_CTFN_RQD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID
, REIMBMT_CTFN_RECD_DT REIMBMT_CTFN_RECD_DT
, REIMBMT_CTFN_DND_DT REIMBMT_CTFN_DND_DT
, REIMBMT_CTFN_TYP_CD REIMBMT_CTFN_TYP_CD
, PQC_ATTRIBUTE_CATEGORY PQC_ATTRIBUTE_CATEGORY
, PQC_ATTRIBUTE1 PQC_ATTRIBUTE1
, PQC_ATTRIBUTE2 PQC_ATTRIBUTE2
, PQC_ATTRIBUTE3 PQC_ATTRIBUTE3
, PQC_ATTRIBUTE4 PQC_ATTRIBUTE4
, PQC_ATTRIBUTE5 PQC_ATTRIBUTE5
, PQC_ATTRIBUTE6 PQC_ATTRIBUTE6
, PQC_ATTRIBUTE7 PQC_ATTRIBUTE7
, PQC_ATTRIBUTE8 PQC_ATTRIBUTE8
, PQC_ATTRIBUTE9 PQC_ATTRIBUTE9
, PQC_ATTRIBUTE10 PQC_ATTRIBUTE10
, PQC_ATTRIBUTE11 PQC_ATTRIBUTE11
, PQC_ATTRIBUTE12 PQC_ATTRIBUTE12
, PQC_ATTRIBUTE13 PQC_ATTRIBUTE13
, PQC_ATTRIBUTE14 PQC_ATTRIBUTE14
, PQC_ATTRIBUTE15 PQC_ATTRIBUTE15
, PQC_ATTRIBUTE16 PQC_ATTRIBUTE16
, PQC_ATTRIBUTE17 PQC_ATTRIBUTE17
, PQC_ATTRIBUTE18 PQC_ATTRIBUTE18
, PQC_ATTRIBUTE19 PQC_ATTRIBUTE19
, PQC_ATTRIBUTE20 PQC_ATTRIBUTE20
, PQC_ATTRIBUTE21 PQC_ATTRIBUTE21
, PQC_ATTRIBUTE22 PQC_ATTRIBUTE22
, PQC_ATTRIBUTE23 PQC_ATTRIBUTE23
, PQC_ATTRIBUTE24 PQC_ATTRIBUTE24
, PQC_ATTRIBUTE25 PQC_ATTRIBUTE25
, PQC_ATTRIBUTE26 PQC_ATTRIBUTE26
, PQC_ATTRIBUTE27 PQC_ATTRIBUTE27
, PQC_ATTRIBUTE28 PQC_ATTRIBUTE28
, PQC_ATTRIBUTE29 PQC_ATTRIBUTE29
, PQC_ATTRIBUTE30 PQC_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "BEN"."BEN_PRTT_RMT_RQST_CTFN_PRVDD_F"