[Home] [Help] [Dependency Information]
Object Name: | MTL_EAM_ASSET_SEARCH_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | INV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEARCH_SET_ID | NUMBER | Yes | ||
DESCRIPTIVE_FLEX_CONTEXT_CODE | VARCHAR2 | (30) | Yes | |
END_USER_COLUMN_NAME | VARCHAR2 | (30) | Yes | |
LINE_TYPE | NUMBER | Yes | ||
OPERATOR | VARCHAR2 | (10) | Yes | |
ATTRIBUTE_VARCHAR2_VALUE | VARCHAR2 | (150) | ||
ATTRIBUTE_NUMBER_VALUE | NUMBER | |||
ATTRIBUTE_DATE_VALUE | DATE |
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#;
|
|
|