VIEW: APPS.MSC_TREE_SELECTION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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