VIEW: BEN.BEN_BNFT_PRVDD_LDGR_F_RBV#

Source

View Text - Preformatted

select BNFT_PRVDD_LDGR_ID BNFT_PRVDD_LDGR_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PRTT_RO_OF_UNUSD_AMT_FLAG PRTT_RO_OF_UNUSD_AMT_FLAG, PER_IN_LER_ID PER_IN_LER_ID, ACTY_BASE_RT_ID ACTY_BASE_RT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BPL_ATTRIBUTE_CATEGORY BPL_ATTRIBUTE_CATEGORY, BPL_ATTRIBUTE1 BPL_ATTRIBUTE1, BPL_ATTRIBUTE2 BPL_ATTRIBUTE2, BPL_ATTRIBUTE3 BPL_ATTRIBUTE3, BPL_ATTRIBUTE4 BPL_ATTRIBUTE4, BPL_ATTRIBUTE5 BPL_ATTRIBUTE5, BPL_ATTRIBUTE6 BPL_ATTRIBUTE6, BPL_ATTRIBUTE7 BPL_ATTRIBUTE7, BPL_ATTRIBUTE8 BPL_ATTRIBUTE8, BPL_ATTRIBUTE9 BPL_ATTRIBUTE9, BPL_ATTRIBUTE10 BPL_ATTRIBUTE10, BPL_ATTRIBUTE11 BPL_ATTRIBUTE11, BPL_ATTRIBUTE12 BPL_ATTRIBUTE12, BPL_ATTRIBUTE13 BPL_ATTRIBUTE13, BPL_ATTRIBUTE14 BPL_ATTRIBUTE14, BPL_ATTRIBUTE15 BPL_ATTRIBUTE15, BPL_ATTRIBUTE16 BPL_ATTRIBUTE16, BPL_ATTRIBUTE17 BPL_ATTRIBUTE17, BPL_ATTRIBUTE18 BPL_ATTRIBUTE18, BPL_ATTRIBUTE19 BPL_ATTRIBUTE19, BPL_ATTRIBUTE20 BPL_ATTRIBUTE20, BPL_ATTRIBUTE21 BPL_ATTRIBUTE21, BPL_ATTRIBUTE22 BPL_ATTRIBUTE22, BPL_ATTRIBUTE23 BPL_ATTRIBUTE23, BPL_ATTRIBUTE24 BPL_ATTRIBUTE24, BPL_ATTRIBUTE25 BPL_ATTRIBUTE25, BPL_ATTRIBUTE26 BPL_ATTRIBUTE26, BPL_ATTRIBUTE27 BPL_ATTRIBUTE27, BPL_ATTRIBUTE28 BPL_ATTRIBUTE28, BPL_ATTRIBUTE29 BPL_ATTRIBUTE29, BPL_ATTRIBUTE30 BPL_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, FRFTD_VAL FRFTD_VAL, PRVDD_VAL PRVDD_VAL, RLD_UP_VAL RLD_UP_VAL, USED_VAL USED_VAL, CASH_RECD_VAL CASH_RECD_VAL, BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, ACTY_REF_PERD_CD ACTY_REF_PERD_CD, CMCD_FRFTD_VAL CMCD_FRFTD_VAL, CMCD_PRVDD_VAL CMCD_PRVDD_VAL, CMCD_RLD_UP_VAL CMCD_RLD_UP_VAL, CMCD_USED_VAL CMCD_USED_VAL, CMCD_CASH_RECD_VAL CMCD_CASH_RECD_VAL, CMCD_REF_PERD_CD CMCD_REF_PERD_CD, ANN_FRFTD_VAL ANN_FRFTD_VAL, ANN_PRVDD_VAL ANN_PRVDD_VAL, ANN_RLD_UP_VAL ANN_RLD_UP_VAL, ANN_USED_VAL ANN_USED_VAL, ANN_CASH_RECD_VAL ANN_CASH_RECD_VAL, BENEFIT_ACTION_ID BENEFIT_ACTION_ID, PERSON_ACTION_ID PERSON_ACTION_ID from "BEN"."BEN_BNFT_PRVDD_LDGR_F_RBV"

View Text - HTML Formatted

SELECT BNFT_PRVDD_LDGR_ID BNFT_PRVDD_LDGR_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PRTT_RO_OF_UNUSD_AMT_FLAG PRTT_RO_OF_UNUSD_AMT_FLAG
, PER_IN_LER_ID PER_IN_LER_ID
, ACTY_BASE_RT_ID ACTY_BASE_RT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BPL_ATTRIBUTE_CATEGORY BPL_ATTRIBUTE_CATEGORY
, BPL_ATTRIBUTE1 BPL_ATTRIBUTE1
, BPL_ATTRIBUTE2 BPL_ATTRIBUTE2
, BPL_ATTRIBUTE3 BPL_ATTRIBUTE3
, BPL_ATTRIBUTE4 BPL_ATTRIBUTE4
, BPL_ATTRIBUTE5 BPL_ATTRIBUTE5
, BPL_ATTRIBUTE6 BPL_ATTRIBUTE6
, BPL_ATTRIBUTE7 BPL_ATTRIBUTE7
, BPL_ATTRIBUTE8 BPL_ATTRIBUTE8
, BPL_ATTRIBUTE9 BPL_ATTRIBUTE9
, BPL_ATTRIBUTE10 BPL_ATTRIBUTE10
, BPL_ATTRIBUTE11 BPL_ATTRIBUTE11
, BPL_ATTRIBUTE12 BPL_ATTRIBUTE12
, BPL_ATTRIBUTE13 BPL_ATTRIBUTE13
, BPL_ATTRIBUTE14 BPL_ATTRIBUTE14
, BPL_ATTRIBUTE15 BPL_ATTRIBUTE15
, BPL_ATTRIBUTE16 BPL_ATTRIBUTE16
, BPL_ATTRIBUTE17 BPL_ATTRIBUTE17
, BPL_ATTRIBUTE18 BPL_ATTRIBUTE18
, BPL_ATTRIBUTE19 BPL_ATTRIBUTE19
, BPL_ATTRIBUTE20 BPL_ATTRIBUTE20
, BPL_ATTRIBUTE21 BPL_ATTRIBUTE21
, BPL_ATTRIBUTE22 BPL_ATTRIBUTE22
, BPL_ATTRIBUTE23 BPL_ATTRIBUTE23
, BPL_ATTRIBUTE24 BPL_ATTRIBUTE24
, BPL_ATTRIBUTE25 BPL_ATTRIBUTE25
, BPL_ATTRIBUTE26 BPL_ATTRIBUTE26
, BPL_ATTRIBUTE27 BPL_ATTRIBUTE27
, BPL_ATTRIBUTE28 BPL_ATTRIBUTE28
, BPL_ATTRIBUTE29 BPL_ATTRIBUTE29
, BPL_ATTRIBUTE30 BPL_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
, FRFTD_VAL FRFTD_VAL
, PRVDD_VAL PRVDD_VAL
, RLD_UP_VAL RLD_UP_VAL
, USED_VAL USED_VAL
, CASH_RECD_VAL CASH_RECD_VAL
, BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, ACTY_REF_PERD_CD ACTY_REF_PERD_CD
, CMCD_FRFTD_VAL CMCD_FRFTD_VAL
, CMCD_PRVDD_VAL CMCD_PRVDD_VAL
, CMCD_RLD_UP_VAL CMCD_RLD_UP_VAL
, CMCD_USED_VAL CMCD_USED_VAL
, CMCD_CASH_RECD_VAL CMCD_CASH_RECD_VAL
, CMCD_REF_PERD_CD CMCD_REF_PERD_CD
, ANN_FRFTD_VAL ANN_FRFTD_VAL
, ANN_PRVDD_VAL ANN_PRVDD_VAL
, ANN_RLD_UP_VAL ANN_RLD_UP_VAL
, ANN_USED_VAL ANN_USED_VAL
, ANN_CASH_RECD_VAL ANN_CASH_RECD_VAL
, BENEFIT_ACTION_ID BENEFIT_ACTION_ID
, PERSON_ACTION_ID PERSON_ACTION_ID
FROM "BEN"."BEN_BNFT_PRVDD_LDGR_F_RBV"