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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MSD_DEMAND_PLANS_VL

Object Details

Object Name:	MSD_DEMAND_PLANS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view provides the Demand Plan Definitions and its Express Setup Information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID.
DEMAND_PLAN_ID	NUMBER		Yes	Demand Plan Id
ORGANIZATION_ID	NUMBER		Yes	Organization ID
SR_INSTANCE_ID	NUMBER		Yes	Source Instance ID
DEMAND_PLAN_NAME	VARCHAR2	(30)	Yes	Demand Plan Name
DESCRIPTION	VARCHAR2	(240)		Description
CALENDAR_TYPE_ID	VARCHAR2	(1)		Calender Type ID
CALENDAR_TYPE	VARCHAR2	(0)		Calendar Type
CALENDAR_CODE	VARCHAR2	(10)		Calendar Code
PERIOD_SET_NAME	VARCHAR2	(15)		Period Set Name
BASE_UOM	VARCHAR2	(3)		Base Unit of Measurement
BASE_CURRENCY_CODE	VARCHAR2	(4000)		base Currency Code
AVERAGE_DISCOUNT	NUMBER			Average Discount
CATEGORY_SET_ID	NUMBER			Category Set ID
CATEGORY_SET_NAME	VARCHAR2	(30)		Category Set Name
LOWEST_PERIOD_TYPE_ID	VARCHAR2	(1)		Lowest Period Type ID
LOWEST_PERIOD_TYPE	VARCHAR2	(80)	Yes	Lowest Period Type
HISTORY_START_DATE	DATE			History Start Date
VALID_FLAG	VARCHAR2	(30)		Valid Flag
VALID_FLAG_DESC	VARCHAR2	(80)		Valid Flag Description
ENABLE_FCST_EXPLOSION	VARCHAR2	(30)		Enable Forecast Explosion Flag
DELETE_PLAN_FLAG	VARCHAR2	(30)		The plan will be deleted by the concurrent program.
ROUNDOFF_THREASHOLD	NUMBER			Roundoff Threshold
ROUNDOFF_DECIMAL_PLACES	NUMBER			Roundoff Decimal Points
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
REQUEST_ID	NUMBER			Enhanced Who Column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who Column
PROGRAM_ID	NUMBER			Enhanced Who Column
PROGRAM_UPDATE_DATE	DATE			Enhanced Who Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment
SHARED_DB_PREFIX	VARCHAR2	(80)		Shared DB Prefix
CODE_LOCATION	VARCHAR2	(240)		Express Code Location
SHARED_DB_LOCATION	VARCHAR2	(240)		Shared Express Database Location
EXPRESS_MACHINE_PORT	VARCHAR2	(80)		Express Machine Port
OWA_VIRTUAL_PATH_NAME	VARCHAR2	(240)		OWA Virtual PAth Name
EAD_NAME	VARCHAR2	(80)		EAD Name
EXPRESS_CONNECT_STRING	VARCHAR2	(240)		Express Connect String
SETUP1	VARCHAR2	(80)		Express Setup field
SETUP2	VARCHAR2	(80)		Express Setup field
SETUP3	VARCHAR2	(80)		Express Setup field
SETUP4	VARCHAR2	(80)		Express Setup field
SETUP5	VARCHAR2	(80)		Express Setup field
AMT_THRESHOLD	NUMBER			Amount Threshold
AMT_DECIMAL_PLACES	NUMBER			Amount Decimal Places
DP_BUILD_REFRESH_NUM	NUMBER			DP build refresh number
G_MIN_TIM_LVL_ID	NUMBER			Gregorian Calendar Minimum Time Level
M_MIN_TIM_LVL_ID	NUMBER			Manufacturing Calendar Minimum Time Level
F_MIN_TIM_LVL_ID	NUMBER			Fiscal Calendar Minimum Time Level
C_MIN_TIM_LVL_ID	NUMBER			Composite Calendar Minimum Time Level
STRIPE_FLAG	VARCHAR2	(1)		Stripe Flag
STRIPE_INSTANCE	VARCHAR2	(40)		Stripe instance
STRIPE_LEVEL_ID	VARCHAR2	(240)		Stripe Level Id
STRIPE_SR_LEVEL_PK	VARCHAR2	(240)		Stripe Source Pk
BUILD_STRIPE_LEVEL_PK	VARCHAR2	(240)		Level Pk last used to build stripe.
ROUNDING_LEVEL_ID	NUMBER			Rounding Flag
STRIPE_STREAM_NAME	VARCHAR2	(240)		Stripe Stream Name
STRIPE_STREAM_DESIG	VARCHAR2	(320)		Stripe Stream Designator
BUILD_STRIPE_STREAM_NAME	VARCHAR2	(240)		Build Stripe Stream Name
BUILD_STRIPE_STREAM_DESIG	VARCHAR2	(320)		Build Stripe Stream Designator
BUILD_STRIPE_STREAM_REF_NUM	NUMBER			Build Stripe Stream Refresh Number
USE_ORG_SPECIFIC_BOM_FLAG	VARCHAR2	(30)		Specifies Which BOM should be used for Forecast Explosion
USE_ORG_SPECIFIC_BOM_FLAG_DESC	VARCHAR2	(80)		Use Org Specific BOM Description
DELETE_REQUEST_ID	NUMBER			Delete Request Id
TEMPLATE_ID	NUMBER			Identifier for the template on which the plan is based
TEMPLATE_FLAG	VARCHAR2	(15)		Indicates that the plan is a template
DEFAULT_TEMPLATE	VARCHAR2	(15)		Indicates whether the template is the default for the given plan type.
PLAN_TYPE	VARCHAR2	(15)		Identifies the plan type like S&OP Plan or Liability Plan. There can be only one plan type for a template.
PLAN_START_DATE	DATE			Plan Start Date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      STRIPE_FLAG
,      STRIPE_INSTANCE
,      STRIPE_LEVEL_ID
,      STRIPE_SR_LEVEL_PK
,      BUILD_STRIPE_LEVEL_PK
,      ROUNDING_LEVEL_ID
,      STRIPE_STREAM_NAME
,      STRIPE_STREAM_DESIG
,      BUILD_STRIPE_STREAM_NAME
,      BUILD_STRIPE_STREAM_DESIG
,      BUILD_STRIPE_STREAM_REF_NUM
,      USE_ORG_SPECIFIC_BOM_FLAG
,      USE_ORG_SPECIFIC_BOM_FLAG_DESC
,      DELETE_REQUEST_ID
,      TEMPLATE_ID
,      TEMPLATE_FLAG
,      DEFAULT_TEMPLATE
,      PLAN_TYPE
,      PLAN_START_DATE
FROM APPS.MSD_DEMAND_PLANS_VL;

Dependencies

[top of page]

APPS.MSD_DEMAND_PLANS_VL references the following:

APPS: FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; MSC_CATEGORY_SETS; MSD_DEMAND_PLANS; MSD_DEMAND_PLANS_TL; MSD_DP_EXPRESS_SETUP

APPS.MSD_DEMAND_PLANS_VL is referenced by following:

APPS: MSD_DEMAND_PLANS_V