VIEW: BEN.BEN_PER_CM_PRVDD_F#

Source

View Text - Preformatted

select PER_CM_PRVDD_ID PER_CM_PRVDD_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, RQSTD_FLAG RQSTD_FLAG, INSPN_RQD_FLAG INSPN_RQD_FLAG, PER_CM_ID PER_CM_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PCD_ATTRIBUTE_CATEGORY PCD_ATTRIBUTE_CATEGORY, PCD_ATTRIBUTE1 PCD_ATTRIBUTE1, PCD_ATTRIBUTE2 PCD_ATTRIBUTE2, PCD_ATTRIBUTE3 PCD_ATTRIBUTE3, PCD_ATTRIBUTE4 PCD_ATTRIBUTE4, PCD_ATTRIBUTE5 PCD_ATTRIBUTE5, PCD_ATTRIBUTE6 PCD_ATTRIBUTE6, PCD_ATTRIBUTE7 PCD_ATTRIBUTE7, PCD_ATTRIBUTE8 PCD_ATTRIBUTE8, PCD_ATTRIBUTE9 PCD_ATTRIBUTE9, PCD_ATTRIBUTE10 PCD_ATTRIBUTE10, PCD_ATTRIBUTE11 PCD_ATTRIBUTE11, PCD_ATTRIBUTE12 PCD_ATTRIBUTE12, PCD_ATTRIBUTE13 PCD_ATTRIBUTE13, PCD_ATTRIBUTE14 PCD_ATTRIBUTE14, PCD_ATTRIBUTE15 PCD_ATTRIBUTE15, PCD_ATTRIBUTE16 PCD_ATTRIBUTE16, PCD_ATTRIBUTE17 PCD_ATTRIBUTE17, PCD_ATTRIBUTE18 PCD_ATTRIBUTE18, PCD_ATTRIBUTE19 PCD_ATTRIBUTE19, PCD_ATTRIBUTE20 PCD_ATTRIBUTE20, PCD_ATTRIBUTE21 PCD_ATTRIBUTE21, PCD_ATTRIBUTE22 PCD_ATTRIBUTE22, PCD_ATTRIBUTE23 PCD_ATTRIBUTE23, PCD_ATTRIBUTE24 PCD_ATTRIBUTE24, PCD_ATTRIBUTE25 PCD_ATTRIBUTE25, PCD_ATTRIBUTE26 PCD_ATTRIBUTE26, PCD_ATTRIBUTE27 PCD_ATTRIBUTE27, PCD_ATTRIBUTE28 PCD_ATTRIBUTE28, PCD_ATTRIBUTE29 PCD_ATTRIBUTE29, PCD_ATTRIBUTE30 PCD_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PER_CM_PRVDD_STAT_CD PER_CM_PRVDD_STAT_CD, CM_DLVRY_MED_CD CM_DLVRY_MED_CD, CM_DLVRY_MTHD_CD CM_DLVRY_MTHD_CD, SENT_DT SENT_DT, INSTNC_NUM INSTNC_NUM, TO_BE_SENT_DT TO_BE_SENT_DT, DLVRY_INSTN_TXT DLVRY_INSTN_TXT, RESND_RSN_CD RESND_RSN_CD, RESND_CMNT_TXT RESND_CMNT_TXT, ADDRESS_ID ADDRESS_ID from "BEN"."BEN_PER_CM_PRVDD_F"

View Text - HTML Formatted

SELECT PER_CM_PRVDD_ID PER_CM_PRVDD_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, RQSTD_FLAG RQSTD_FLAG
, INSPN_RQD_FLAG INSPN_RQD_FLAG
, PER_CM_ID PER_CM_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PCD_ATTRIBUTE_CATEGORY PCD_ATTRIBUTE_CATEGORY
, PCD_ATTRIBUTE1 PCD_ATTRIBUTE1
, PCD_ATTRIBUTE2 PCD_ATTRIBUTE2
, PCD_ATTRIBUTE3 PCD_ATTRIBUTE3
, PCD_ATTRIBUTE4 PCD_ATTRIBUTE4
, PCD_ATTRIBUTE5 PCD_ATTRIBUTE5
, PCD_ATTRIBUTE6 PCD_ATTRIBUTE6
, PCD_ATTRIBUTE7 PCD_ATTRIBUTE7
, PCD_ATTRIBUTE8 PCD_ATTRIBUTE8
, PCD_ATTRIBUTE9 PCD_ATTRIBUTE9
, PCD_ATTRIBUTE10 PCD_ATTRIBUTE10
, PCD_ATTRIBUTE11 PCD_ATTRIBUTE11
, PCD_ATTRIBUTE12 PCD_ATTRIBUTE12
, PCD_ATTRIBUTE13 PCD_ATTRIBUTE13
, PCD_ATTRIBUTE14 PCD_ATTRIBUTE14
, PCD_ATTRIBUTE15 PCD_ATTRIBUTE15
, PCD_ATTRIBUTE16 PCD_ATTRIBUTE16
, PCD_ATTRIBUTE17 PCD_ATTRIBUTE17
, PCD_ATTRIBUTE18 PCD_ATTRIBUTE18
, PCD_ATTRIBUTE19 PCD_ATTRIBUTE19
, PCD_ATTRIBUTE20 PCD_ATTRIBUTE20
, PCD_ATTRIBUTE21 PCD_ATTRIBUTE21
, PCD_ATTRIBUTE22 PCD_ATTRIBUTE22
, PCD_ATTRIBUTE23 PCD_ATTRIBUTE23
, PCD_ATTRIBUTE24 PCD_ATTRIBUTE24
, PCD_ATTRIBUTE25 PCD_ATTRIBUTE25
, PCD_ATTRIBUTE26 PCD_ATTRIBUTE26
, PCD_ATTRIBUTE27 PCD_ATTRIBUTE27
, PCD_ATTRIBUTE28 PCD_ATTRIBUTE28
, PCD_ATTRIBUTE29 PCD_ATTRIBUTE29
, PCD_ATTRIBUTE30 PCD_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PER_CM_PRVDD_STAT_CD PER_CM_PRVDD_STAT_CD
, CM_DLVRY_MED_CD CM_DLVRY_MED_CD
, CM_DLVRY_MTHD_CD CM_DLVRY_MTHD_CD
, SENT_DT SENT_DT
, INSTNC_NUM INSTNC_NUM
, TO_BE_SENT_DT TO_BE_SENT_DT
, DLVRY_INSTN_TXT DLVRY_INSTN_TXT
, RESND_RSN_CD RESND_RSN_CD
, RESND_CMNT_TXT RESND_CMNT_TXT
, ADDRESS_ID ADDRESS_ID
FROM "BEN"."BEN_PER_CM_PRVDD_F"