eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: BEN.BEN_EXT_CHG_EVT_LOG#

Object Details

Object Name:	BEN_EXT_CHG_EVT_LOG#
Object Type:	VIEW
Owner:	BEN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
EXT_CHG_EVT_LOG_ID	NUMBER	(15)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
CHG_EVT_CD	VARCHAR2	(30)	Yes
CHG_EFF_DT	DATE		Yes
PERSON_ID	NUMBER	(15)	Yes
OLD_VAL1	VARCHAR2	(600)
OLD_VAL2	VARCHAR2	(600)
OLD_VAL3	VARCHAR2	(600)
OLD_VAL4	VARCHAR2	(600)
OLD_VAL5	VARCHAR2	(600)
OLD_VAL6	VARCHAR2	(600)
NEW_VAL1	VARCHAR2	(600)
NEW_VAL2	VARCHAR2	(600)
NEW_VAL3	VARCHAR2	(600)
NEW_VAL4	VARCHAR2	(600)
NEW_VAL5	VARCHAR2	(600)
NEW_VAL6	VARCHAR2	(600)
CHG_USER_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
OBJECT_VERSION_NUMBER	NUMBER	(9)
CHG_ACTL_DT	DATE
PRMTR_01	VARCHAR2	(90)
PRMTR_02	VARCHAR2	(90)
PRMTR_03	VARCHAR2	(90)
PRMTR_04	VARCHAR2	(90)
PRMTR_05	VARCHAR2	(90)
PRMTR_06	VARCHAR2	(90)
PRMTR_07	VARCHAR2	(90)
PRMTR_08	VARCHAR2	(90)
PRMTR_09	VARCHAR2	(90)
PRMTR_10	VARCHAR2	(90)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXT_CHG_EVT_LOG_ID
,      BUSINESS_GROUP_ID
,      CHG_EVT_CD
,      CHG_EFF_DT
,      PERSON_ID
,      OLD_VAL1
,      OLD_VAL2
,      OLD_VAL3
,      OLD_VAL4
,      OLD_VAL5
,      OLD_VAL6
,      NEW_VAL1
,      NEW_VAL2
,      NEW_VAL3
,      NEW_VAL4
,      NEW_VAL5
,      NEW_VAL6
,      CHG_USER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      CHG_ACTL_DT
,      PRMTR_01
,      PRMTR_02
,      PRMTR_03
,      PRMTR_04
,      PRMTR_05
,      PRMTR_06
,      PRMTR_07
,      PRMTR_08
,      PRMTR_09
,      PRMTR_10
FROM BEN.BEN_EXT_CHG_EVT_LOG#;

Dependencies

[top of page]

BEN.BEN_EXT_CHG_EVT_LOG# references the following:

BEN: BEN_EXT_CHG_EVT_LOG

BEN.BEN_EXT_CHG_EVT_LOG# is referenced by following:

APPS: BEN_EXT_CHG_EVT_LOG; BEN_EXT_CHG_EVT_LOG_WHO