[Home] [Help] [Dependency Information]
Object Name: | CSI_IEA_VALUE_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | CSI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IEAV_INTERFACE_ID | NUMBER | Yes | ||
INST_INTERFACE_ID | NUMBER | Yes | ||
PARALLEL_WORKER_ID | NUMBER | |||
ERROR_TEXT | VARCHAR2 | (2000) | ||
ATTRIBUTE_ID | NUMBER | |||
INV_CONCATENATED_SEGMENTS | VARCHAR2 | (250) | ||
INVENTORY_ITEM_ID | NUMBER | |||
MASTER_ORGANIZATION_ID | NUMBER | |||
MASTER_ORGANIZATION_NAME | VARCHAR2 | (250) | ||
ITEM_CATEGORY_CONC_SEG | VARCHAR2 | (250) | ||
ITEM_CATEGORY_ID | NUMBER | |||
ATTRIBUTE_CODE | VARCHAR2 | (30) | ||
ATTRIBUTE_NAME | VARCHAR2 | (50) | ||
ATTRIBUTE_LEVEL | VARCHAR2 | (15) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE_VALUE | VARCHAR2 | (240) | ||
ATTRIBUTE_VALUE_ID | NUMBER | |||
IEAV_START_DATE | DATE | |||
IEAV_END_DATE | DATE | |||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT IEAV_INTERFACE_ID
, INST_INTERFACE_ID
, PARALLEL_WORKER_ID
, ERROR_TEXT
, ATTRIBUTE_ID
, INV_CONCATENATED_SEGMENTS
, INVENTORY_ITEM_ID
, MASTER_ORGANIZATION_ID
, MASTER_ORGANIZATION_NAME
, ITEM_CATEGORY_CONC_SEG
, ITEM_CATEGORY_ID
, ATTRIBUTE_CODE
, ATTRIBUTE_NAME
, ATTRIBUTE_LEVEL
, ATTRIBUTE_CATEGORY
, ATTRIBUTE_VALUE
, ATTRIBUTE_VALUE_ID
, IEAV_START_DATE
, IEAV_END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM CSI.CSI_IEA_VALUE_INTERFACE#;
|
|
|