[Home] [Help] [Dependency Information]
Object Name: | BOM_ODI_WS_ENTITIES# |
---|---|
Object Type: | VIEW |
Owner: | BOM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | ||
ODI_SESSION_ID | NUMBER | Yes | ||
ITEM_ID | NUMBER | |||
ITEM_ORG_ID | NUMBER | |||
ITEM_REV | NUMBER | |||
ITEM_REV_CODE | VARCHAR2 | (10) | ||
ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
GROUP_ID | NUMBER | |||
EXPLOSION_DATE | DATE | |||
EXPLOSION_OPTION | NUMBER | |||
STRUCTURE_NAME | VARCHAR2 | (100) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
SEQUENCE_NUMBER | NUMBER | |||
PUBLISH_FLAG | VARCHAR2 | (1) | ||
ROOT_NODE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, ODI_SESSION_ID
, ITEM_ID
, ITEM_ORG_ID
, ITEM_REV
, ITEM_REV_CODE
, ITEM_UNIT_NUMBER
, GROUP_ID
, EXPLOSION_DATE
, EXPLOSION_OPTION
, STRUCTURE_NAME
, CREATION_DATE
, CREATED_BY
, SEQUENCE_NUMBER
, PUBLISH_FLAG
, ROOT_NODE_ID
FROM BOM.BOM_ODI_WS_ENTITIES#;
|
|
|