VIEW: APPS.BEN_PRMRY_CARE_PRVDR_PPR_V

Source

View Text - Preformatted

SELECT PRMRY_CARE_PRVDR_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, NAME, EXT_IDENT, PRMRY_CARE_PRVDR_TYP_CD, nvl(PRTT_ENRT_RSLT_ID,0) PRTT_ENRT_RSLT_ID, nvl(ELIG_CVRD_DPNT_ID,0) ELIG_CVRD_DPNT_ID, BUSINESS_GROUP_ID, PPR_ATTRIBUTE_CATEGORY, PPR_ATTRIBUTE1, PPR_ATTRIBUTE2, PPR_ATTRIBUTE3, PPR_ATTRIBUTE4, PPR_ATTRIBUTE5, PPR_ATTRIBUTE6, PPR_ATTRIBUTE7, PPR_ATTRIBUTE8, PPR_ATTRIBUTE9, PPR_ATTRIBUTE10, PPR_ATTRIBUTE11, PPR_ATTRIBUTE12, PPR_ATTRIBUTE13, PPR_ATTRIBUTE14, PPR_ATTRIBUTE15, PPR_ATTRIBUTE16, PPR_ATTRIBUTE17, PPR_ATTRIBUTE18, PPR_ATTRIBUTE19, PPR_ATTRIBUTE20, PPR_ATTRIBUTE21, PPR_ATTRIBUTE22, PPR_ATTRIBUTE23, PPR_ATTRIBUTE24, PPR_ATTRIBUTE25, PPR_ATTRIBUTE26, PPR_ATTRIBUTE27, PPR_ATTRIBUTE28, PPR_ATTRIBUTE29, PPR_ATTRIBUTE30, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER from ben_prmry_care_prvdr_v

View Text - HTML Formatted

SELECT PRMRY_CARE_PRVDR_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, NAME
, EXT_IDENT
, PRMRY_CARE_PRVDR_TYP_CD
, NVL(PRTT_ENRT_RSLT_ID
, 0) PRTT_ENRT_RSLT_ID
, NVL(ELIG_CVRD_DPNT_ID
, 0) ELIG_CVRD_DPNT_ID
, BUSINESS_GROUP_ID
, PPR_ATTRIBUTE_CATEGORY
, PPR_ATTRIBUTE1
, PPR_ATTRIBUTE2
, PPR_ATTRIBUTE3
, PPR_ATTRIBUTE4
, PPR_ATTRIBUTE5
, PPR_ATTRIBUTE6
, PPR_ATTRIBUTE7
, PPR_ATTRIBUTE8
, PPR_ATTRIBUTE9
, PPR_ATTRIBUTE10
, PPR_ATTRIBUTE11
, PPR_ATTRIBUTE12
, PPR_ATTRIBUTE13
, PPR_ATTRIBUTE14
, PPR_ATTRIBUTE15
, PPR_ATTRIBUTE16
, PPR_ATTRIBUTE17
, PPR_ATTRIBUTE18
, PPR_ATTRIBUTE19
, PPR_ATTRIBUTE20
, PPR_ATTRIBUTE21
, PPR_ATTRIBUTE22
, PPR_ATTRIBUTE23
, PPR_ATTRIBUTE24
, PPR_ATTRIBUTE25
, PPR_ATTRIBUTE26
, PPR_ATTRIBUTE27
, PPR_ATTRIBUTE28
, PPR_ATTRIBUTE29
, PPR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_PRMRY_CARE_PRVDR_V