VIEW: APPS.MSC_SELECTION_CRITERIA_V

Source

View Text - Preformatted

SELECT s.folder_id, s.field_name, nvl(f.item_prompt, nvl(msc_get_name.lookup_fnd(s.folder_object,s.field_name), c.field_prompt)) prompt, s.folder_object, s.field_type, s.condition, decode(s.condition, 11, s.from_field, decode(s.field_type, 'DATE', decode(c.lov_type,10,s.from_field, fnd_date.date_to_displaydate( fnd_date.canonical_to_date(s.from_field))), 'NUMBER', decode(c.lov_type, 1, to_char(fnd_number.canonical_to_number(s.from_field)), s.from_field), s.from_field)) low_value, s.hidden_from_field, decode(s.field_type, 'DATE', decode(c.lov_type,10,s.to_field, fnd_date.date_to_displaydate( fnd_date.canonical_to_date(s.to_field))), 'NUMBER', decode(c.lov_type, 1, to_char(fnd_number.canonical_to_number(s.to_field)), s.to_field), s.to_field) high_value, s.creation_date, s.created_by, s.last_update_date, s.last_updated_by, s.last_update_login, s.rowid row_id, c.app_short_name, c.flex_code, c.flex_num, c.data_set, c.sql_statement, c.lov_type, c.long_list, s.sequence, s.count_by, s.object_type, s.source_type, s.active_flag, s.and_or, c.group_by, s.object_sequence_id, c.sql_statement2 from msc_selection_criteria s, msc_criteria c, fnd_folder_columns f where f.item_name (+) = s.field_name and f.folder_id (+) = s.folder_id and c.field_name = s.field_name and c.folder_object = s.folder_object order by s.sequence

View Text - HTML Formatted

SELECT S.FOLDER_ID
, S.FIELD_NAME
, NVL(F.ITEM_PROMPT
, NVL(MSC_GET_NAME.LOOKUP_FND(S.FOLDER_OBJECT
, S.FIELD_NAME)
, C.FIELD_PROMPT)) PROMPT
, S.FOLDER_OBJECT
, S.FIELD_TYPE
, S.CONDITION
, DECODE(S.CONDITION
, 11
, S.FROM_FIELD
, DECODE(S.FIELD_TYPE
, 'DATE'
, DECODE(C.LOV_TYPE
, 10
, S.FROM_FIELD
, FND_DATE.DATE_TO_DISPLAYDATE( FND_DATE.CANONICAL_TO_DATE(S.FROM_FIELD)))
, 'NUMBER'
, DECODE(C.LOV_TYPE
, 1
, TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(S.FROM_FIELD))
, S.FROM_FIELD)
, S.FROM_FIELD)) LOW_VALUE
, S.HIDDEN_FROM_FIELD
, DECODE(S.FIELD_TYPE
, 'DATE'
, DECODE(C.LOV_TYPE
, 10
, S.TO_FIELD
, FND_DATE.DATE_TO_DISPLAYDATE( FND_DATE.CANONICAL_TO_DATE(S.TO_FIELD)))
, 'NUMBER'
, DECODE(C.LOV_TYPE
, 1
, TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(S.TO_FIELD))
, S.TO_FIELD)
, S.TO_FIELD) HIGH_VALUE
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
, S.ROWID ROW_ID
, C.APP_SHORT_NAME
, C.FLEX_CODE
, C.FLEX_NUM
, C.DATA_SET
, C.SQL_STATEMENT
, C.LOV_TYPE
, C.LONG_LIST
, S.SEQUENCE
, S.COUNT_BY
, S.OBJECT_TYPE
, S.SOURCE_TYPE
, S.ACTIVE_FLAG
, S.AND_OR
, C.GROUP_BY
, S.OBJECT_SEQUENCE_ID
, C.SQL_STATEMENT2
FROM MSC_SELECTION_CRITERIA S
, MSC_CRITERIA C
, FND_FOLDER_COLUMNS F
WHERE F.ITEM_NAME (+) = S.FIELD_NAME
AND F.FOLDER_ID (+) = S.FOLDER_ID
AND C.FIELD_NAME = S.FIELD_NAME
AND C.FOLDER_OBJECT = S.FOLDER_OBJECT ORDER BY S.SEQUENCE