VIEW: APPS.MSC_CATEGORIES_TREE_V

Source

View Text - Preformatted

SELECT distinct p.plan_id, c.sr_instance_id, c.organization_id, c.category_set_id, c.sr_category_id, c.category_name, c.description from msc_item_categories c, msc_plans p WHERE c.enabled_flag = 'Y'

View Text - HTML Formatted

SELECT DISTINCT P.PLAN_ID
, C.SR_INSTANCE_ID
, C.ORGANIZATION_ID
, C.CATEGORY_SET_ID
, C.SR_CATEGORY_ID
, C.CATEGORY_NAME
, C.DESCRIPTION
FROM MSC_ITEM_CATEGORIES C
, MSC_PLANS P
WHERE C.ENABLED_FLAG = 'Y'