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

VIEW: XLE.XLE_ASSOCIATIONS#

Object Details
Object Name: XLE_ASSOCIATIONS#
Object Type: VIEW
Owner: XLE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_ID NUMBER (15) Yes
ASSOCIATION_TYPE_ID NUMBER (15) Yes
SUBJECT_ID NUMBER (15) Yes
SUBJECT_PARENT_ID NUMBER (15)
OBJECT_ID NUMBER (15) Yes
EFFECTIVE_FROM DATE
Yes
EFFECTIVE_TO DATE

OBJECT_VERSION_NUMBER NUMBER

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
ASSOC_INFORMATION_CONTEXT VARCHAR2 (30)
ASSOC_INFORMATION1 VARCHAR2 (150)
ASSOC_INFORMATION2 VARCHAR2 (150)
ASSOC_INFORMATION3 VARCHAR2 (150)
ASSOC_INFORMATION4 VARCHAR2 (150)
ASSOC_INFORMATION5 VARCHAR2 (150)
ASSOC_INFORMATION6 VARCHAR2 (150)
ASSOC_INFORMATION7 VARCHAR2 (150)
ASSOC_INFORMATION8 VARCHAR2 (150)
ASSOC_INFORMATION9 VARCHAR2 (150)
ASSOC_INFORMATION10 VARCHAR2 (150)
ASSOC_INFORMATION11 VARCHAR2 (150)
ASSOC_INFORMATION12 VARCHAR2 (150)
ASSOC_INFORMATION13 VARCHAR2 (150)
ASSOC_INFORMATION14 VARCHAR2 (150)
ASSOC_INFORMATION15 VARCHAR2 (150)
ASSOC_INFORMATION16 VARCHAR2 (150)
ASSOC_INFORMATION17 VARCHAR2 (150)
ASSOC_INFORMATION18 VARCHAR2 (150)
ASSOC_INFORMATION19 VARCHAR2 (150)
ASSOC_INFORMATION20 VARCHAR2 (150)
Query Text

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


SELECT ASSOCIATION_ID
,      ASSOCIATION_TYPE_ID
,      SUBJECT_ID
,      SUBJECT_PARENT_ID
,      OBJECT_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ASSOC_INFORMATION_CONTEXT
,      ASSOC_INFORMATION1
,      ASSOC_INFORMATION2
,      ASSOC_INFORMATION3
,      ASSOC_INFORMATION4
,      ASSOC_INFORMATION5
,      ASSOC_INFORMATION6
,      ASSOC_INFORMATION7
,      ASSOC_INFORMATION8
,      ASSOC_INFORMATION9
,      ASSOC_INFORMATION10
,      ASSOC_INFORMATION11
,      ASSOC_INFORMATION12
,      ASSOC_INFORMATION13
,      ASSOC_INFORMATION14
,      ASSOC_INFORMATION15
,      ASSOC_INFORMATION16
,      ASSOC_INFORMATION17
,      ASSOC_INFORMATION18
,      ASSOC_INFORMATION19
,      ASSOC_INFORMATION20
FROM XLE.XLE_ASSOCIATIONS#;

Dependencies

[top of page]

XLE.XLE_ASSOCIATIONS# references the following:

SchemaXLE
TableXLE_ASSOCIATIONS
XLE.XLE_ASSOCIATIONS# is referenced by following:

SchemaAPPS
SynonymXLE_ASSOCIATIONS