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

VIEW: INV.MTL_EAM_ATTR_VAL_INTERFACE#

Object Details
Object Name: MTL_EAM_ATTR_VAL_INTERFACE#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTERFACE_HEADER_ID NUMBER
Yes
INTERFACE_LINE_ID NUMBER
Yes
APPLICATION_ID NUMBER (10)
DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2 (40)
APPLICATION_COLUMN_NAME VARCHAR2 (30)
END_USER_COLUMN_NAME VARCHAR2 (30) Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30) Yes
LINE_TYPE NUMBER
Yes
ASSOCIATION_ID NUMBER

ATTRIBUTE_VARCHAR2_VALUE VARCHAR2 (150)
ATTRIBUTE_NUMBER_VALUE NUMBER

ATTRIBUTE_DATE_VALUE DATE

PROCESS_STATUS VARCHAR2 (1) Yes
ERROR_NUMBER NUMBER

ERROR_MESSAGE VARCHAR2 (2000)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
INTERFACE_GROUP_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_HEADER_ID
,      INTERFACE_LINE_ID
,      APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      APPLICATION_COLUMN_NAME
,      END_USER_COLUMN_NAME
,      ATTRIBUTE_CATEGORY
,      LINE_TYPE
,      ASSOCIATION_ID
,      ATTRIBUTE_VARCHAR2_VALUE
,      ATTRIBUTE_NUMBER_VALUE
,      ATTRIBUTE_DATE_VALUE
,      PROCESS_STATUS
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INTERFACE_GROUP_ID
FROM INV.MTL_EAM_ATTR_VAL_INTERFACE#;

Dependencies

[top of page]

INV.MTL_EAM_ATTR_VAL_INTERFACE# references the following:

SchemaINV
TableMTL_EAM_ATTR_VAL_INTERFACE
INV.MTL_EAM_ATTR_VAL_INTERFACE# is referenced by following:

SchemaAPPS
SynonymMTL_EAM_ATTR_VAL_INTERFACE