View: MSD_SR_IT_ALL_V

Product:	MSD - Demand Planning
Description:	This is the Source View that associates the Interest Type level to Top level in the Product Dimension. This view would be applied to an OracleSales Online Applications 11i instance from which the Interest Type to Top level association info
Implementation/DBA Data:	APPS.MSD_SR_IT_ALL_V

View Text

SELECT DISTINCT MC.SEGMENT1
, MC.DESCRIPTION
, MSD_SR_UTIL.GET_ALL_PRD_PK
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MTL_CATEGORIES_V MC
, (SELECT ID_FLEX_NUM
FROM FND_ID_FLEX_STRUCTURES
WHERE ID_FLEX_CODE = 'MCAT'
AND APPLICATION_ID = 401
AND ID_FLEX_STRUCTURE_CODE = 'SALES_CATEGORIES') CSI
WHERE MC.STRUCTURE_ID = CSI.ID_FLEX_NUM
AND MC.SEGMENT2 IS NULL
AND MC.SEGMENT3 IS NULL UNION SELECT TO_CHAR( 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