DBA Data[Home] [Help]

VIEW: APPS.ISC_MSC_BIS_CATEGORIES_V

Source

View Text - Preformatted

SELECT DISTINCT category_set_id||category_name ID, category_name VALUE FROM msc_item_categories UNION ALL SELECT 'NA' ID, 'Not Categorized' VALUE FROM dual
View Text - HTML Formatted

SELECT DISTINCT CATEGORY_SET_ID||CATEGORY_NAME ID
, CATEGORY_NAME VALUE
FROM MSC_ITEM_CATEGORIES UNION ALL SELECT 'NA' ID
, 'NOT CATEGORIZED' VALUE
FROM DUAL