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


TABLE: BOM.BOM_ODI_WS_REVISIONS

Object Details
Object Name: BOM_ODI_WS_REVISIONS
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_ODI_WS_REVISIONS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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

Query Text

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;

Dependencies

[top of page]

BOM.BOM_ODI_WS_REVISIONS does not reference any database object

BOM.BOM_ODI_WS_REVISIONS is referenced by following:

SchemaBOM
ViewBOM_ODI_WS_REVISIONS#