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_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:
APPS.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