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

TABLE: INV.MTL_EAM_ASSET_SEARCH_TEMP

Object Details
Object Name: MTL_EAM_ASSET_SEARCH_TEMP
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_EAM_ASSET_SEARCH_TEMP
Subobject Name:
Status: VALID


This is a temporary table for advanced asset search functions. Advanced search program uses this table to construct a dynamic query.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_EAM_ASSET_SEARCH_TEMP_U1 NORMAL UNIQUE TablespaceAPPS_TS_NOLOGGING ColumnSEARCH_SET_ID
Columns
Name Datatype Length Mandatory Comments
SEARCH_SET_ID NUMBER
Yes This is generated from a sequence, the primary key of a table
DESCRIPTIVE_FLEX_CONTEXT_CODE VARCHAR2 (30) Yes Attribute group of the asset
END_USER_COLUMN_NAME VARCHAR2 (30) Yes Attribute name
LINE_TYPE NUMBER
Yes The values of the line type can be 1, 2, 3 (1 - varchar, 2 - number, 3 - date)
OPERATOR VARCHAR2 (10) Yes Search criteria
ATTRIBUTE_VARCHAR2_VALUE VARCHAR2 (150)
Store the information the user entered
ATTRIBUTE_NUMBER_VALUE NUMBER

Store the information the user entered
ATTRIBUTE_DATE_VALUE DATE

Store the information the user entered
Query Text

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


SELECT SEARCH_SET_ID
,      DESCRIPTIVE_FLEX_CONTEXT_CODE
,      END_USER_COLUMN_NAME
,      LINE_TYPE
,      OPERATOR
,      ATTRIBUTE_VARCHAR2_VALUE
,      ATTRIBUTE_NUMBER_VALUE
,      ATTRIBUTE_DATE_VALUE
FROM INV.MTL_EAM_ASSET_SEARCH_TEMP;

Dependencies

[top of page]

INV.MTL_EAM_ASSET_SEARCH_TEMP does not reference any database object

INV.MTL_EAM_ASSET_SEARCH_TEMP is referenced by following:

SchemaINV
ViewMTL_EAM_ASSET_SEARCH_TEMP#