[Home] [Help] [Dependency Information]
Object Name: | BOM_ODI_WS_REVISIONS# |
---|---|
Object Type: | VIEW |
Owner: | BOM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | |||
ROW_ID | ROWID | (10) | ||
REVISION | VARCHAR2 | (10) | ||
REVISION_ID | NUMBER | |||
REVISION_LABEL | VARCHAR2 | (10) | ||
REVISION_HIGH_DATE | DATE | |||
PARENT_REVISION | VARCHAR2 | (10) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
PUBLISH_FLAG | VARCHAR2 | (1) | ||
SEQUENCE_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, ROW_ID
, REVISION
, REVISION_ID
, REVISION_LABEL
, REVISION_HIGH_DATE
, PARENT_REVISION
, CREATION_DATE
, CREATED_BY
, PUBLISH_FLAG
, SEQUENCE_NUMBER
FROM BOM.BOM_ODI_WS_REVISIONS#;
|
|
|