FND Design Data [Home] [Help]

View: MSD_SR_PRD_IT_V

Product: MSD - Demand Planning
Description: This is the Source View that associates the Product level to Interest Type level in the Product Dimension. This view would be applied to an Oracle Sales Online Applications 11i instance from which the Product to Interest Type level associa
Implementation/DBA Data: ViewAPPS.MSD_SR_PRD_IT_V
View Text

SELECT DISTINCT MSIV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, DECODE( MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, 5
, DECODE(MICV.SEGMENT1
, NULL
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MICV.SEGMENT1)
, MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_PK) SEGMENT1
, DECODE( MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, 5
, DECODE(MICV.SEGMENT1
, NULL
, MSD_SR_UTIL.GET_NULL_DESC
, MCV.DESCRIPTION)
, MSD_SR_UTIL.GET_NULL_DESC)
, MSD_SR_UTIL.GET_NULL_DESC)
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MSD_APP_INSTANCE_ORGS VORG
, MSD_SETUP_PARAMETERS MORG
, MTL_ITEM_CATEGORIES_V MICV
, MTL_SYSTEM_ITEMS_KFV MSIV
, MTL_CATEGORIES_VL MCV
, MSD_SETUP_PARAMETERS MORG2
WHERE MORG2.PARAMETER_NAME = 'MSD_PLANNING_PERCENTAGE'
AND DECODE( MSIV.ATO_FORECAST_CONTROL
, 1
, 1
, 2
, 1
, 3
, DECODE(NVL(MORG2.PARAMETER_VALUE
, 1)
, 1
, 2
, 2
, 2
, 3
, 2
, MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(MSIV.INVENTORY_ITEM_ID ))) = 1
AND DECODE( NVL(MORG2.PARAMETER_VALUE
, 1)
, 3
, DECODE( MSIV.BOM_ITEM_TYPE
, 2
, 2
, 1)
, 1) = 1
AND MSIV.ORGANIZATION_ID = VORG.ORGANIZATION_ID
AND MICV.INVENTORY_ITEM_ID (+) = MSIV.INVENTORY_ITEM_ID
AND MICV.ORGANIZATION_ID (+) = MSIV.ORGANIZATION_ID
AND MCV.CATEGORY_ID (+) = MICV.CATEGORY_ID
AND MSIV.MRP_PLANNING_CODE <> 6
AND MSIV.BOM_ITEM_TYPE <> 5
AND MICV.CATEGORY_SET_ID (+) = 5
AND MORG.PARAMETER_NAME = 'MSD_MASTER_ORG'
AND ( ( MICV.CATEGORY_SET_ID = 5
AND MSIV.ORGANIZATION_ID = MORG.PARAMETER_VALUE ) OR NOT EXISTS (SELECT 1
FROM MTL_SYSTEM_ITEMS MSIV2
, MTL_ITEM_CATEGORIES_V CAT1
, MTL_CATEGORIES_VL MCV1
, MSD_SETUP_PARAMETERS MORG3
WHERE MSIV2.INVENTORY_ITEM_ID = CAT1.INVENTORY_ITEM_ID
AND MSIV2.ORGANIZATION_ID = CAT1.ORGANIZATION_ID
AND CAT1.CATEGORY_SET_ID =5
AND MSIV2.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND MSIV2.ORGANIZATION_ID = MORG.PARAMETER_VALUE
AND MORG3.PARAMETER_NAME = 'MSD_PLANNING_PERCENTAGE'
AND DECODE( MSIV2.ATO_FORECAST_CONTROL
, 1
, 1
, 2
, 1
, 3
, DECODE(NVL(MORG3.PARAMETER_VALUE
, 1)
, 1
, 2
, 2
, 2
, 3
, 2
, MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(MSIV2.INVENTORY_ITEM_ID ))) = 1
AND DECODE( NVL(MORG3.PARAMETER_VALUE
, 1)
, 3
, DECODE( MSIV2.BOM_ITEM_TYPE
, 2
, 2
, 1)
, 1) = 1
AND MCV.CATEGORY_ID = CAT1.CATEGORY_ID
AND MSIV2.MRP_PLANNING_CODE <> 6
AND MSIV2.BOM_ITEM_TYPE <> 5 ) )

Columns

Name
LEVEL_VALUE_PK
LEVEL_VALUE
PARENT_VALUE_PK
PARENT_VALUE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5