VIEW: BEN.BEN_PER_IN_LER#

Source

View Text - Preformatted

select PER_IN_LER_ID PER_IN_LER_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, LER_ID LER_ID, PERSON_ID PERSON_ID, PTNL_LER_FOR_PER_ID PTNL_LER_FOR_PER_ID, PIL_ATTRIBUTE_CATEGORY PIL_ATTRIBUTE_CATEGORY, PIL_ATTRIBUTE1 PIL_ATTRIBUTE1, PIL_ATTRIBUTE2 PIL_ATTRIBUTE2, PIL_ATTRIBUTE3 PIL_ATTRIBUTE3, PIL_ATTRIBUTE4 PIL_ATTRIBUTE4, PIL_ATTRIBUTE5 PIL_ATTRIBUTE5, PIL_ATTRIBUTE6 PIL_ATTRIBUTE6, PIL_ATTRIBUTE7 PIL_ATTRIBUTE7, PIL_ATTRIBUTE8 PIL_ATTRIBUTE8, PIL_ATTRIBUTE9 PIL_ATTRIBUTE9, PIL_ATTRIBUTE10 PIL_ATTRIBUTE10, PIL_ATTRIBUTE11 PIL_ATTRIBUTE11, PIL_ATTRIBUTE12 PIL_ATTRIBUTE12, PIL_ATTRIBUTE13 PIL_ATTRIBUTE13, PIL_ATTRIBUTE14 PIL_ATTRIBUTE14, PIL_ATTRIBUTE15 PIL_ATTRIBUTE15, PIL_ATTRIBUTE16 PIL_ATTRIBUTE16, PIL_ATTRIBUTE17 PIL_ATTRIBUTE17, PIL_ATTRIBUTE18 PIL_ATTRIBUTE18, PIL_ATTRIBUTE19 PIL_ATTRIBUTE19, PIL_ATTRIBUTE20 PIL_ATTRIBUTE20, PIL_ATTRIBUTE21 PIL_ATTRIBUTE21, PIL_ATTRIBUTE22 PIL_ATTRIBUTE22, PIL_ATTRIBUTE23 PIL_ATTRIBUTE23, PIL_ATTRIBUTE24 PIL_ATTRIBUTE24, PIL_ATTRIBUTE25 PIL_ATTRIBUTE25, PIL_ATTRIBUTE26 PIL_ATTRIBUTE26, PIL_ATTRIBUTE27 PIL_ATTRIBUTE27, PIL_ATTRIBUTE28 PIL_ATTRIBUTE28, PIL_ATTRIBUTE29 PIL_ATTRIBUTE29, PIL_ATTRIBUTE30 PIL_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_IN_LER_STAT_CD PER_IN_LER_STAT_CD, PRVS_STAT_CD PRVS_STAT_CD, BCKT_PER_IN_LER_ID BCKT_PER_IN_LER_ID, PROCD_DT PROCD_DT, STRTD_DT STRTD_DT, VOIDD_DT VOIDD_DT, BCKT_DT BCKT_DT, CLSD_DT CLSD_DT, NTFN_DT NTFN_DT, TRGR_TABLE_PK_ID TRGR_TABLE_PK_ID, ASSIGNMENT_ID ASSIGNMENT_ID, GROUP_PL_ID GROUP_PL_ID, MGR_OVRID_DT MGR_OVRID_DT, MGR_OVRID_PERSON_ID MGR_OVRID_PERSON_ID, WS_MGR_ID WS_MGR_ID from "BEN"."BEN_PER_IN_LER"

View Text - HTML Formatted

SELECT PER_IN_LER_ID PER_IN_LER_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, LER_ID LER_ID
, PERSON_ID PERSON_ID
, PTNL_LER_FOR_PER_ID PTNL_LER_FOR_PER_ID
, PIL_ATTRIBUTE_CATEGORY PIL_ATTRIBUTE_CATEGORY
, PIL_ATTRIBUTE1 PIL_ATTRIBUTE1
, PIL_ATTRIBUTE2 PIL_ATTRIBUTE2
, PIL_ATTRIBUTE3 PIL_ATTRIBUTE3
, PIL_ATTRIBUTE4 PIL_ATTRIBUTE4
, PIL_ATTRIBUTE5 PIL_ATTRIBUTE5
, PIL_ATTRIBUTE6 PIL_ATTRIBUTE6
, PIL_ATTRIBUTE7 PIL_ATTRIBUTE7
, PIL_ATTRIBUTE8 PIL_ATTRIBUTE8
, PIL_ATTRIBUTE9 PIL_ATTRIBUTE9
, PIL_ATTRIBUTE10 PIL_ATTRIBUTE10
, PIL_ATTRIBUTE11 PIL_ATTRIBUTE11
, PIL_ATTRIBUTE12 PIL_ATTRIBUTE12
, PIL_ATTRIBUTE13 PIL_ATTRIBUTE13
, PIL_ATTRIBUTE14 PIL_ATTRIBUTE14
, PIL_ATTRIBUTE15 PIL_ATTRIBUTE15
, PIL_ATTRIBUTE16 PIL_ATTRIBUTE16
, PIL_ATTRIBUTE17 PIL_ATTRIBUTE17
, PIL_ATTRIBUTE18 PIL_ATTRIBUTE18
, PIL_ATTRIBUTE19 PIL_ATTRIBUTE19
, PIL_ATTRIBUTE20 PIL_ATTRIBUTE20
, PIL_ATTRIBUTE21 PIL_ATTRIBUTE21
, PIL_ATTRIBUTE22 PIL_ATTRIBUTE22
, PIL_ATTRIBUTE23 PIL_ATTRIBUTE23
, PIL_ATTRIBUTE24 PIL_ATTRIBUTE24
, PIL_ATTRIBUTE25 PIL_ATTRIBUTE25
, PIL_ATTRIBUTE26 PIL_ATTRIBUTE26
, PIL_ATTRIBUTE27 PIL_ATTRIBUTE27
, PIL_ATTRIBUTE28 PIL_ATTRIBUTE28
, PIL_ATTRIBUTE29 PIL_ATTRIBUTE29
, PIL_ATTRIBUTE30 PIL_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_IN_LER_STAT_CD PER_IN_LER_STAT_CD
, PRVS_STAT_CD PRVS_STAT_CD
, BCKT_PER_IN_LER_ID BCKT_PER_IN_LER_ID
, PROCD_DT PROCD_DT
, STRTD_DT STRTD_DT
, VOIDD_DT VOIDD_DT
, BCKT_DT BCKT_DT
, CLSD_DT CLSD_DT
, NTFN_DT NTFN_DT
, TRGR_TABLE_PK_ID TRGR_TABLE_PK_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, GROUP_PL_ID GROUP_PL_ID
, MGR_OVRID_DT MGR_OVRID_DT
, MGR_OVRID_PERSON_ID MGR_OVRID_PERSON_ID
, WS_MGR_ID WS_MGR_ID
FROM "BEN"."BEN_PER_IN_LER"