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

TABLE: MSD.MSD_DEMAND_PLANS

Object Details
Object Name: MSD_DEMAND_PLANS
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_DEMAND_PLANS
Subobject Name:
Status: VALID


This table stores the Demand Plan Definitions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_DEMAND_PLANS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEMAND_PLAN_ID
ColumnORGANIZATION_ID
ColumnZD_EDITION_NAME
MSD_DEMAND_PLANS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_TYPE
ColumnDEMAND_PLAN_NAME
ColumnZD_EDITION_NAME
MSD_DEMAND_PLANS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIAB_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER
Yes Demand Plan Unique ID. This is the primary key.
ORGANIZATION_ID NUMBER
Yes The Organization Id. This is the same as the trading partner Id from the source instance.
DEMAND_PLAN_NAME VARCHAR2 (30) Yes Demand Plan Name.
DESCRIPTION VARCHAR2 (240)
Demand Plan Description
CALENDAR_TYPE VARCHAR2 (1)
Demand Plan Calendar Type. The possible values are : 1. Gregorian Calendar, 2. Manufacturing Calendar, and 3. Fiscal Calendar. This is based out of the MSD_CALENDAR_TYPE lookup.
CALENDAR_CODE VARCHAR2 (10)
Manufacturing Calendar used.
PERIOD_SET_NAME VARCHAR2 (15)
Fiscal Calendar used.
BASE_UOM VARCHAR2 (3)
Demand Plan base UOM.
AVERAGE_DISCOUNT NUMBER

Average Discount for the Demand Plan.
CATEGORY_SET_ID NUMBER

The Catergory Set used for the Demand Plan inorder to aggregate the product along the Product Category hierarchy.
LOWEST_PERIOD_TYPE VARCHAR2 (1)
This is the lowest time level that is used for the demand plan. The value for this is based on the MSD_PERIOD_TYPE lookup. The possible values are : 1. Manufacturing Week, 2. Manufacturing Period, 3. Fiscal Month, 4. Fiscal Quarter, 5. Fiscal Year, 6. Gregorian Month, 7. Gregorian Quarter, 8. Gregorian Year, 9. Day.
HISTORY_START_DATE DATE

The first date of the history used for this demand plan.
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 defining 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
SR_INSTANCE_ID NUMBER
Yes The source instance id for the trading partner.
VALID_FLAG VARCHAR2 (30)
Status of the Demand Plan.
ENABLE_FCST_EXPLOSION VARCHAR2 (30)
Enable Forecast Explosion Flag
DELETE_PLAN_FLAG VARCHAR2 (30)
The plan will be deleted via a concurrent process.
ROUNDOFF_THREASHOLD NUMBER

Null Means No Rounding
ROUNDOFF_DECIMAL_PLACES NUMBER

Null means No Rounding
AMT_THRESHOLD NUMBER

Amount Threshold
AMT_DECIMAL_PLACES NUMBER

Amount Decimal Places
DP_BUILD_ERROR_FLAG VARCHAR2 (30)
Status of DP Build Error
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_INSTANCE VARCHAR2 (40)
Stripe Instance
STRIPE_LEVEL_ID VARCHAR2 (240)
Stripe Level Id
STRIPE_SR_LEVEL_PK VARCHAR2 (240)
Stripe Source Level Pk
BUILD_STRIPE_LEVEL_PK VARCHAR2 (240)
Build Stripe Level Pk
ROUNDING_LEVEL_ID NUMBER

Rounding Level Id
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
DELETE_REQUEST_ID NUMBER

Holds the concurrent request id of the deleted demand plan request.
TEMPLATE_FLAG VARCHAR2 (15)
Indicates that the plan is a template
TEMPLATE_ID NUMBER

Identifier for the template on which the plan is based
DEFAULT_TEMPLATE VARCHAR2 (15)
Indicates whether the template is the defualt 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.
LIAB_PLAN_ID NUMBER

ASCP Plan ID or -1 in case of CP Plan
LIAB_PLAN_NAME VARCHAR2 (80)
ASCP Plan Name or Some Value for CP
PLAN_START_DATE DATE

The Plan Start Date of the Present Liability Plan Run
PLAN_END_DATE DATE

Plan End Date of the Present Liability Plan Run
PREV_LIAB_PUB_PLAN_START_DATE DATE

Last Plan Start Date for which Liability was uploaded
PREVIOUS_PLAN_START_DATE DATE

The Plan start Date for previous Liability Run
LIABILITY_REVISION_NUM NUMBER

Stores the revision no of the uploaded plan
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT DEMAND_PLAN_ID
,      ORGANIZATION_ID
,      DEMAND_PLAN_NAME
,      DESCRIPTION
,      CALENDAR_TYPE
,      CALENDAR_CODE
,      PERIOD_SET_NAME
,      BASE_UOM
,      AVERAGE_DISCOUNT
,      CATEGORY_SET_ID
,      LOWEST_PERIOD_TYPE
,      HISTORY_START_DATE
,      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
,      SR_INSTANCE_ID
,      VALID_FLAG
,      ENABLE_FCST_EXPLOSION
,      DELETE_PLAN_FLAG
,      ROUNDOFF_THREASHOLD
,      ROUNDOFF_DECIMAL_PLACES
,      AMT_THRESHOLD
,      AMT_DECIMAL_PLACES
,      DP_BUILD_ERROR_FLAG
,      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_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
,      DELETE_REQUEST_ID
,      TEMPLATE_FLAG
,      TEMPLATE_ID
,      DEFAULT_TEMPLATE
,      PLAN_TYPE
,      LIAB_PLAN_ID
,      LIAB_PLAN_NAME
,      PLAN_START_DATE
,      PLAN_END_DATE
,      PREV_LIAB_PUB_PLAN_START_DATE
,      PREVIOUS_PLAN_START_DATE
,      LIABILITY_REVISION_NUM
,      ZD_EDITION_NAME
FROM MSD.MSD_DEMAND_PLANS;

Dependencies

[top of page]

MSD.MSD_DEMAND_PLANS does not reference any database object

MSD.MSD_DEMAND_PLANS is referenced by following:

SchemaMSD
ViewMSD_DEMAND_PLANS#