Skip to content

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

VIEW: BEN.BEN_ABR_EXTRA_INFO#

Object Details
Object Name: BEN_ABR_EXTRA_INFO#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ABR_EXTRA_INFO_ID NUMBER (15) Yes
ACTY_BASE_RT_ID NUMBER (15) Yes
INFORMATION_TYPE VARCHAR2 (40) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ABI_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ABI_ATTRIBUTE1 VARCHAR2 (150)
ABI_ATTRIBUTE2 VARCHAR2 (150)
ABI_ATTRIBUTE3 VARCHAR2 (150)
ABI_ATTRIBUTE4 VARCHAR2 (150)
ABI_ATTRIBUTE5 VARCHAR2 (150)
ABI_ATTRIBUTE6 VARCHAR2 (150)
ABI_ATTRIBUTE7 VARCHAR2 (150)
ABI_ATTRIBUTE8 VARCHAR2 (150)
ABI_ATTRIBUTE9 VARCHAR2 (150)
ABI_ATTRIBUTE10 VARCHAR2 (150)
ABI_ATTRIBUTE11 VARCHAR2 (150)
ABI_ATTRIBUTE12 VARCHAR2 (150)
ABI_ATTRIBUTE13 VARCHAR2 (150)
ABI_ATTRIBUTE14 VARCHAR2 (150)
ABI_ATTRIBUTE15 VARCHAR2 (150)
ABI_ATTRIBUTE16 VARCHAR2 (150)
ABI_ATTRIBUTE17 VARCHAR2 (150)
ABI_ATTRIBUTE18 VARCHAR2 (150)
ABI_ATTRIBUTE19 VARCHAR2 (150)
ABI_ATTRIBUTE20 VARCHAR2 (150)
ABI_INFORMATION_CATEGORY VARCHAR2 (30)
ABI_INFORMATION1 VARCHAR2 (150)
ABI_INFORMATION2 VARCHAR2 (150)
ABI_INFORMATION3 VARCHAR2 (150)
ABI_INFORMATION4 VARCHAR2 (150)
ABI_INFORMATION5 VARCHAR2 (150)
ABI_INFORMATION6 VARCHAR2 (150)
ABI_INFORMATION7 VARCHAR2 (150)
ABI_INFORMATION8 VARCHAR2 (150)
ABI_INFORMATION9 VARCHAR2 (150)
ABI_INFORMATION10 VARCHAR2 (150)
ABI_INFORMATION11 VARCHAR2 (150)
ABI_INFORMATION12 VARCHAR2 (150)
ABI_INFORMATION13 VARCHAR2 (150)
ABI_INFORMATION14 VARCHAR2 (150)
ABI_INFORMATION15 VARCHAR2 (150)
ABI_INFORMATION16 VARCHAR2 (150)
ABI_INFORMATION17 VARCHAR2 (150)
ABI_INFORMATION18 VARCHAR2 (150)
ABI_INFORMATION19 VARCHAR2 (150)
ABI_INFORMATION20 VARCHAR2 (150)
ABI_INFORMATION21 VARCHAR2 (150)
ABI_INFORMATION22 VARCHAR2 (150)
ABI_INFORMATION23 VARCHAR2 (150)
ABI_INFORMATION24 VARCHAR2 (150)
ABI_INFORMATION25 VARCHAR2 (150)
ABI_INFORMATION26 VARCHAR2 (150)
ABI_INFORMATION27 VARCHAR2 (150)
ABI_INFORMATION28 VARCHAR2 (150)
ABI_INFORMATION29 VARCHAR2 (150)
ABI_INFORMATION30 VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

Query Text

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


SELECT ABR_EXTRA_INFO_ID
,      ACTY_BASE_RT_ID
,      INFORMATION_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ABI_ATTRIBUTE_CATEGORY
,      ABI_ATTRIBUTE1
,      ABI_ATTRIBUTE2
,      ABI_ATTRIBUTE3
,      ABI_ATTRIBUTE4
,      ABI_ATTRIBUTE5
,      ABI_ATTRIBUTE6
,      ABI_ATTRIBUTE7
,      ABI_ATTRIBUTE8
,      ABI_ATTRIBUTE9
,      ABI_ATTRIBUTE10
,      ABI_ATTRIBUTE11
,      ABI_ATTRIBUTE12
,      ABI_ATTRIBUTE13
,      ABI_ATTRIBUTE14
,      ABI_ATTRIBUTE15
,      ABI_ATTRIBUTE16
,      ABI_ATTRIBUTE17
,      ABI_ATTRIBUTE18
,      ABI_ATTRIBUTE19
,      ABI_ATTRIBUTE20
,      ABI_INFORMATION_CATEGORY
,      ABI_INFORMATION1
,      ABI_INFORMATION2
,      ABI_INFORMATION3
,      ABI_INFORMATION4
,      ABI_INFORMATION5
,      ABI_INFORMATION6
,      ABI_INFORMATION7
,      ABI_INFORMATION8
,      ABI_INFORMATION9
,      ABI_INFORMATION10
,      ABI_INFORMATION11
,      ABI_INFORMATION12
,      ABI_INFORMATION13
,      ABI_INFORMATION14
,      ABI_INFORMATION15
,      ABI_INFORMATION16
,      ABI_INFORMATION17
,      ABI_INFORMATION18
,      ABI_INFORMATION19
,      ABI_INFORMATION20
,      ABI_INFORMATION21
,      ABI_INFORMATION22
,      ABI_INFORMATION23
,      ABI_INFORMATION24
,      ABI_INFORMATION25
,      ABI_INFORMATION26
,      ABI_INFORMATION27
,      ABI_INFORMATION28
,      ABI_INFORMATION29
,      ABI_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM BEN.BEN_ABR_EXTRA_INFO#;

Dependencies

[top of page]

BEN.BEN_ABR_EXTRA_INFO# references the following:

SchemaBEN
TableBEN_ABR_EXTRA_INFO
BEN.BEN_ABR_EXTRA_INFO# is referenced by following:

SchemaAPPS
SynonymBEN_ABR_EXTRA_INFO
TriggerBEN_ABR_EXTRA_INFO_WHO