[Home] [Help] [Dependency Information]
Object Name: | XLE_ASSOCIATIONS# |
---|---|
Object Type: | VIEW |
Owner: | XLE |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|