View: MSC_CATEGORIES_TREE_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view shows all the categories in the tree
Implementation/DBA Data:	APPS.MSC_CATEGORIES_TREE_V

View Text

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'

Columns