View: MSD_SR_CAT_ALL_V

Product:	MSD - Demand Planning
Description:	This is the Source View that associates the Product Category level to Top level in the Product Dimension. This view would be applied to an Oracle Applications 11i instance from which the Product Category to Top level association informatio
Implementation/DBA Data:	APPS.MSD_SR_CAT_ALL_V

View Text

SELECT DISTINCT MCSVC.CATEGORY_ID
, MCSVC.CATEGORY_CONCAT_SEGS
, MSD_SR_UTIL.GET_ALL_PRD_PK
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MSD_SETUP_PARAMETERS PARA
, MTL_ITEM_CATEGORIES_V MCSVC
WHERE PARA.PARAMETER_NAME = 'MSD_CATEGORY_SET_NAME'
AND PARA.PARAMETER_VALUE = TO_CHAR(MCSVC.CATEGORY_SET_ID) UNION SELECT MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_ALL_PRD_PK
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL

Columns