eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: MSD_SR_PRD_CAT_V
Product: MSD - Demand Planning
Description: This is the Source View that associates the Product level to Product Category level in the Product Dimension. This view would be applied to an Oracle Applications 11i instance from which the Product to Product Category level association i
Implementation/DBA Data:
APPS.MSD_SR_PRD_CAT_V
View Text
SELECT DISTINCT MSIV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MSIV.CONCATENATED_SEGMENTS , DECODE( MSIV.ORGANIZATION_ID , MORG.PARAMETER_VALUE , DECODE(PARA.PARAMETER_VALUE , NULL , MSD_SR_UTIL.GET_NULL_PK , DECODE(MICV.CATEGORY_ID , NULL , MSD_SR_UTIL.GET_NULL_PK , MICV.CATEGORY_ID)) , MSD_SR_UTIL.GET_NULL_PK) CATEGORY_ID , DECODE( MSIV.ORGANIZATION_ID , MORG.PARAMETER_VALUE , DECODE(PARA.PARAMETER_VALUE , NULL , MSD_SR_UTIL.GET_NULL_DESC , DECODE(MICV.CATEGORY_ID , NULL , MSD_SR_UTIL.GET_NULL_DESC , MICV.CATEGORY_CONCAT_SEGS)) , MSD_SR_UTIL.GET_NULL_DESC) , NULL , NULL , NULL , NULL , NULL FROM MSD_APP_INSTANCE_ORGS VORG , MSD_SETUP_PARAMETERS MORG , MSD_SETUP_PARAMETERS PARA , MTL_ITEM_CATEGORIES_V MICV , MTL_SYSTEM_ITEMS_KFV MSIV , 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 MSIV.MRP_PLANNING_CODE <> 6 AND MSIV.BOM_ITEM_TYPE <> 5 AND TO_CHAR(MICV.CATEGORY_SET_ID) = PARA.PARAMETER_VALUE (+) AND 'MSD_CATEGORY_SET_NAME'= PARA.PARAMETER_NAME (+) AND MORG.PARAMETER_NAME = 'MSD_MASTER_ORG' AND ( (TO_CHAR(MICV.CATEGORY_SET_ID) = PARA.PARAMETER_VALUE AND MSIV.ORGANIZATION_ID = MORG.PARAMETER_VALUE ) OR NOT EXISTS (SELECT 1 FROM MTL_SYSTEM_ITEMS MSIV2 , MTL_ITEM_CATEGORIES_V CAT1 , MSD_SETUP_PARAMETERS PARA2 , MSD_SETUP_PARAMETERS MORG3 WHERE MSIV2.INVENTORY_ITEM_ID = CAT1.INVENTORY_ITEM_ID AND MSIV2.ORGANIZATION_ID = CAT1.ORGANIZATION_ID AND TO_CHAR(CAT1.CATEGORY_SET_ID) = PARA2.PARAMETER_VALUE AND PARA2.PARAMETER_NAME = 'MSD_CATEGORY_SET_NAME' 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 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