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_DEMAND_PLANS_V

Product:	MSD - Demand Planning
Description:	This view provides the Demand Plan Definitions and its Express Setup Information.
Implementation/DBA Data:	APPS.MSD_DEMAND_PLANS_V

View Text

SELECT MDP.ROWID
, MDP.DEMAND_PLAN_ID
, MDP.ORGANIZATION_ID
, MDP.SR_INSTANCE_ID
, MDP.DEMAND_PLAN_NAME
, MDP.DESCRIPTION
, MDP.CALENDAR_TYPE
, NULL "CALENDAR_TYPE"
, MDP.CALENDAR_CODE
, MDP.PERIOD_SET_NAME
, MDP.BASE_UOM
, FND_PROFILE.VALUE('MSD_CURRENCY_CODE')
, MDP.AVERAGE_DISCOUNT
, MDP.CATEGORY_SET_ID
, MCS.CATEGORY_SET_NAME
, MDP.LOWEST_PERIOD_TYPE
, FLV2.MEANING "LOWEST_PERIOD_TYPE"
, MDP.HISTORY_START_DATE
, MDP.VALID_FLAG
, FLV3.MEANING "VALID_FLAG_DESC"
, MDP.ENABLE_FCST_EXPLOSION
, MDP.DELETE_PLAN_FLAG
, MDP.ROUNDOFF_THREASHOLD
, MDP.ROUNDOFF_DECIMAL_PLACES
, MDP.LAST_UPDATE_DATE
, MDP.LAST_UPDATED_BY
, MDP.CREATION_DATE
, MDP.CREATED_BY
, MDP.LAST_UPDATE_LOGIN
, MDP.REQUEST_ID
, MDP.PROGRAM_APPLICATION_ID
, MDP.PROGRAM_ID
, MDP.PROGRAM_UPDATE_DATE
, MDP.ATTRIBUTE_CATEGORY
, MDP.ATTRIBUTE1
, MDP.ATTRIBUTE2
, MDP.ATTRIBUTE3
, MDP.ATTRIBUTE4
, MDP.ATTRIBUTE5
, MDP.ATTRIBUTE6
, MDP.ATTRIBUTE7
, MDP.ATTRIBUTE8
, MDP.ATTRIBUTE9
, MDP.ATTRIBUTE10
, MDP.ATTRIBUTE11
, MDP.ATTRIBUTE12
, MDP.ATTRIBUTE13
, MDP.ATTRIBUTE14
, MDP.ATTRIBUTE15
, MES.SHARED_DB_PREFIX
, MES.CODE_LOCATION
, MES.SHARED_DB_LOCATION
, MES.EXPRESS_MACHINE_PORT
, MES.OWA_VIRTUAL_PATH_NAME
, MES.EAD_NAME
, MES.EXPRESS_CONNECT_STRING
, MES.SETUP1
, MES.SETUP2
, MES.SETUP3
, MES.SETUP4
, MES.SETUP5
, MDP.AMT_THRESHOLD
, MDP.AMT_DECIMAL_PLACES
, MDP.DP_BUILD_REFRESH_NUM
, MDP.G_MIN_TIM_LVL_ID
, MDP.M_MIN_TIM_LVL_ID
, MDP.F_MIN_TIM_LVL_ID
, MDP.C_MIN_TIM_LVL_ID
FROM FND_LOOKUP_VALUES_VL FLV2
, FND_LOOKUP_VALUES_VL FLV3
, MSC_CATEGORY_SETS MCS
, MSD_DEMAND_PLANS MDP
, MSD_DP_EXPRESS_SETUP MES
WHERE FLV2.LOOKUP_CODE = MDP.LOWEST_PERIOD_TYPE
AND FLV2.LOOKUP_TYPE = 'MSD_PERIOD_TYPE'
AND FLV3.LOOKUP_CODE (+) = MDP.VALID_FLAG
AND FLV3.LOOKUP_TYPE (+) = 'MSD_DEMAND_PLAN_VALID_STATUS'
AND MCS.CATEGORY_SET_ID (+) = MDP.CATEGORY_SET_ID
AND MDP.DEMAND_PLAN_ID = MES.DEMAND_PLAN_ID (+)

Columns

Name
ROW_ID
DEMAND_PLAN_ID
ORGANIZATION_ID
SR_INSTANCE_ID
DEMAND_PLAN_NAME
DESCRIPTION
CALENDAR_TYPE_ID
CALENDAR_TYPE
CALENDAR_CODE
PERIOD_SET_NAME
BASE_UOM
BASE_CURRENCY_CODE
AVERAGE_DISCOUNT
CATEGORY_SET_ID
CATEGORY_SET_NAME
LOWEST_PERIOD_TYPE_ID
LOWEST_PERIOD_TYPE
HISTORY_START_DATE
VALID_FLAG
VALID_FLAG_DESC
ENABLE_FCST_EXPLOSION
DELETE_PLAN_FLAG
ROUNDOFF_THREASHOLD
ROUNDOFF_DECIMAL_PLACES
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
SHARED_DB_PREFIX
CODE_LOCATION
SHARED_DB_LOCATION
EXPRESS_MACHINE_PORT
OWA_VIRTUAL_PATH_NAME
EAD_NAME
EXPRESS_CONNECT_STRING
SETUP1
SETUP2
SETUP3
SETUP4
SETUP5
AMT_THRESHOLD
AMT_DECIMAL_PLACES
DP_BUILD_REFRESH_NUM
G_MIN_TIM_LVL_ID
M_MIN_TIM_LVL_ID
F_MIN_TIM_LVL_ID
C_MIN_TIM_LVL_ID