VIEW: BEN.BEN_PTNL_LER_FOR_PER#

Source

View Text - Preformatted

select PTNL_LER_FOR_PER_ID PTNL_LER_FOR_PER_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, LER_ID LER_ID, PTNL_LER_FOR_PER_STAT_CD PTNL_LER_FOR_PER_STAT_CD, PERSON_ID PERSON_ID, DTCTD_DT DTCTD_DT, PROCD_DT PROCD_DT, UNPROCD_DT UNPROCD_DT, VOIDD_DT VOIDD_DT, MNL_DT MNL_DT, ENRT_PERD_ID ENRT_PERD_ID, MNLO_DT MNLO_DT, 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, PTNL_LER_FOR_PER_SRC_CD PTNL_LER_FOR_PER_SRC_CD, NTFN_DT NTFN_DT, CSD_BY_PTNL_LER_FOR_PER_ID CSD_BY_PTNL_LER_FOR_PER_ID, TRGR_TABLE_PK_ID TRGR_TABLE_PK_ID from "BEN"."BEN_PTNL_LER_FOR_PER"

View Text - HTML Formatted

SELECT PTNL_LER_FOR_PER_ID PTNL_LER_FOR_PER_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, LER_ID LER_ID
, PTNL_LER_FOR_PER_STAT_CD PTNL_LER_FOR_PER_STAT_CD
, PERSON_ID PERSON_ID
, DTCTD_DT DTCTD_DT
, PROCD_DT PROCD_DT
, UNPROCD_DT UNPROCD_DT
, VOIDD_DT VOIDD_DT
, MNL_DT MNL_DT
, ENRT_PERD_ID ENRT_PERD_ID
, MNLO_DT MNLO_DT
, 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
, PTNL_LER_FOR_PER_SRC_CD PTNL_LER_FOR_PER_SRC_CD
, NTFN_DT NTFN_DT
, CSD_BY_PTNL_LER_FOR_PER_ID CSD_BY_PTNL_LER_FOR_PER_ID
, TRGR_TABLE_PK_ID TRGR_TABLE_PK_ID
FROM "BEN"."BEN_PTNL_LER_FOR_PER"