[Home] [Help]
View: MSC_TREE_SELECTION_V
View Text
SELECT S.SEARCH_QUERY_ID
, C.FIELD_PROMPT
, S.FIELD_NAME
, S.FIELD_TYPE
, S.CONDITION
, S.FROM_FIELD
, S.FROM_FIELD_VALUE
, S.TO_FIELD
, S.TO_FIELD_VALUE
, S.TREE_NODE
FROM MSC_SELECTION_CRITERIA S
, MSC_CRITERIA C
WHERE C.FOLDER_OBJECT = S.FOLDER_OBJECT
AND C.FIELD_NAME = S.FIELD_NAME
Columns
Name |
SEARCH_QUERY_ID |
FIELD |
FIELD_NAME |
FIELD_TYPE |
CONDITION |
FROM_FIELD |
FROM_VALUE |
TO_FIELD |
TO_VALUE |
TREE_NODE |