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

VIEW: CSI.CSI_IEA_VALUE_INTERFACE#

Object Details
Object Name: CSI_IEA_VALUE_INTERFACE#
Object Type: VIEW
Owner: CSI
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

CSI.CSI_IEA_VALUE_INTERFACE# references the following:

SchemaCSI
TableCSI_IEA_VALUE_INTERFACE
CSI.CSI_IEA_VALUE_INTERFACE# is referenced by following:

SchemaAPPS
SynonymCSI_IEA_VALUE_INTERFACE