VIEW: BEN.BEN_EXT_CHG_EVT_LOG#

Source

View Text - Preformatted

select EXT_CHG_EVT_LOG_ID EXT_CHG_EVT_LOG_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CHG_EVT_CD CHG_EVT_CD, CHG_EFF_DT CHG_EFF_DT, PERSON_ID PERSON_ID, OLD_VAL1 OLD_VAL1, OLD_VAL2 OLD_VAL2, OLD_VAL3 OLD_VAL3, OLD_VAL4 OLD_VAL4, OLD_VAL5 OLD_VAL5, OLD_VAL6 OLD_VAL6, NEW_VAL1 NEW_VAL1, NEW_VAL2 NEW_VAL2, NEW_VAL3 NEW_VAL3, NEW_VAL4 NEW_VAL4, NEW_VAL5 NEW_VAL5, NEW_VAL6 NEW_VAL6, CHG_USER_ID CHG_USER_ID, 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, CHG_ACTL_DT CHG_ACTL_DT, PRMTR_01 PRMTR_01, PRMTR_02 PRMTR_02, PRMTR_03 PRMTR_03, PRMTR_04 PRMTR_04, PRMTR_05 PRMTR_05, PRMTR_06 PRMTR_06, PRMTR_07 PRMTR_07, PRMTR_08 PRMTR_08, PRMTR_09 PRMTR_09, PRMTR_10 PRMTR_10 from "BEN"."BEN_EXT_CHG_EVT_LOG"

View Text - HTML Formatted

SELECT EXT_CHG_EVT_LOG_ID EXT_CHG_EVT_LOG_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CHG_EVT_CD CHG_EVT_CD
, CHG_EFF_DT CHG_EFF_DT
, PERSON_ID PERSON_ID
, OLD_VAL1 OLD_VAL1
, OLD_VAL2 OLD_VAL2
, OLD_VAL3 OLD_VAL3
, OLD_VAL4 OLD_VAL4
, OLD_VAL5 OLD_VAL5
, OLD_VAL6 OLD_VAL6
, NEW_VAL1 NEW_VAL1
, NEW_VAL2 NEW_VAL2
, NEW_VAL3 NEW_VAL3
, NEW_VAL4 NEW_VAL4
, NEW_VAL5 NEW_VAL5
, NEW_VAL6 NEW_VAL6
, CHG_USER_ID CHG_USER_ID
, 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
, CHG_ACTL_DT CHG_ACTL_DT
, PRMTR_01 PRMTR_01
, PRMTR_02 PRMTR_02
, PRMTR_03 PRMTR_03
, PRMTR_04 PRMTR_04
, PRMTR_05 PRMTR_05
, PRMTR_06 PRMTR_06
, PRMTR_07 PRMTR_07
, PRMTR_08 PRMTR_08
, PRMTR_09 PRMTR_09
, PRMTR_10 PRMTR_10
FROM "BEN"."BEN_EXT_CHG_EVT_LOG"