[Home] [Help] [Dependency Information]
Object Name: | MTL_EAM_ASSET_SEARCH_TEMP |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.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.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_EAM_ASSET_SEARCH_TEMP_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING | SEARCH_SET_ID |
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 |
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;
INV.MTL_EAM_ASSET_SEARCH_TEMP does not reference any database object
INV.MTL_EAM_ASSET_SEARCH_TEMP is referenced by following:
|
|
|