[Home] [Help] [Dependency Information]
Object Name: | BNE_DOCUMENTS# |
---|---|
Object Type: | VIEW |
Owner: | BNE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_ID | VARCHAR2 | (40) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
DISABLED_FLAG | VARCHAR2 | (1) | Yes | |
DISABLED_DATE | DATE | |||
DISABLED_REASON | VARCHAR2 | (30) | ||
DOCUMENT_CREATED_FLAG | VARCHAR2 | (1) | Yes | |
DOCUMENT_CREATED_DATE | DATE | |||
DOCUMENT_CREATED_SESSION | NUMBER | |||
FIRST_DOWNLOAD_DONE_FLAG | VARCHAR2 | (1) | Yes | |
FIRST_DOWNLOAD_DATE | DATE | |||
LAST_USED_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_ID
, OBJECT_VERSION_NUMBER
, DISABLED_FLAG
, DISABLED_DATE
, DISABLED_REASON
, DOCUMENT_CREATED_FLAG
, DOCUMENT_CREATED_DATE
, DOCUMENT_CREATED_SESSION
, FIRST_DOWNLOAD_DONE_FLAG
, FIRST_DOWNLOAD_DATE
, LAST_USED_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM BNE.BNE_DOCUMENTS#;
|
|
|