[Home] [Help] [Dependency Information]
Object Name: | MSD_DP_PARAMETERS_CS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_DP_PARAMETERS_CS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
this view provied Demand Plans Input Parameters.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique Row ID. | |
DEMAND_PLAN_ID | NUMBER | Yes | Demand Plan Id. | |
DEMAND_PLAN_NAME | VARCHAR2 | (30) | Yes | Demand Plan Name. |
PARAMETER_ID | NUMBER | Yes | Primary Key. | |
PARAMETER_NAME | VARCHAR2 | (320) | Parameter Name. | |
PARAMETER_TYPE_ID | VARCHAR2 | (30) | Yes | Parameter Type ID. This identifies the type Input Parameter. |
PARAMETER_TYPE | VARCHAR2 | (252) | Parameter Type Description. | |
START_DATE | DATE | The Start Date from which the Input Data is read. | ||
END_DATE | DATE | The End Date from which the Input Data is read. | ||
INPUT_SCENARIO_ID | NUMBER | The Input Scenario ID that is to be used for Parameter Type of "Input Scenario". | ||
INPUT_SCENARIO_NAME | VARCHAR2 | (45) | Input Scenario Name. | |
INPUT_DEMAND_PLAN_ID | NUMBER | Input Scenario Demand Plan ID. | ||
INPUT_DEMAND_PLAN_NAME | VARCHAR2 | (30) | Input Demand Plan Name. | |
FORECAST_DATE_USED_ID | VARCHAR2 | (30) | The date column used for generating the forecast. | |
FORECAST_DATE_USED | VARCHAR2 | (100) | Forecast Date Used Description. | |
DATE_PLANNING_VIEW_CLMN | VARCHAR2 | (4000) | The column name that the Planning Server uses to store Date info. | |
QUANTITY_USED_ID | VARCHAR2 | (30) | Column Identifier of type Quantity | |
QUANTITY_USED | VARCHAR2 | (100) | How to Measure Quantity. | |
QUANTITY_PLANNING_VIEW_CLMN | VARCHAR2 | (4000) | The column name that the Planning Server uses to store Quantity info. | |
AMOUNT_USED_ID | VARCHAR2 | (30) | Column Identifier of type Amount | |
AMOUNT_USED | VARCHAR2 | (100) | How to Measure Amount. | |
AMOUNT_PLANNING_VIEW_CLMN | VARCHAR2 | (4000) | The column name that the Planning Server uses to store Amount info. | |
FORECAST_USED_ID | VARCHAR2 | (1) | Forecast Used ID. | |
FORECAST_USED | VARCHAR2 | (80) | Forecast Used. | |
FACT_TYPE_ID | VARCHAR2 | (1) | Forecast Type ID | |
FACT_TYPE | VARCHAR2 | (80) | Forecast Type | |
REVISION | VARCHAR2 | (40) | Revision | |
VIEW_NAME | VARCHAR2 | (240) | View Name | |
ALLO_AGG_BASIS_STREAM_ID | NUMBER | (15) | How Allocation/Aggregation will be based. | |
NUMBER_OF_PERIOD | NUMBER | (15) | Number of Periods | |
CS_DEFINITION_ID | NUMBER | (15) | Yes | Which Custom Stream Definition used. |
MULTIPLE_STREAM_FLAG | VARCHAR2 | (30) | Does this Custom Stream contain subsets | |
MEASUREMENT_TYPE | VARCHAR2 | (30) | How measures this Custom Stream | |
SYSTEM_FLAG | VARCHAR2 | (30) | Yes | flag for internal or custom defined stream. |
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 | Concurrent Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who Column | ||
EXCLUDE_FROM_ROLLING_CYCLE | VARCHAR2 | (30) | This is the flag for parameter to exclude from rolling cycle.Possible values are 1 (Exclude) and 2 or Null (Include). | |
SCN_BUILD_REFRESH_NUM | NUMBER | (15) | Scenario Build Refresh Number | |
ROUNDING_FLAG | VARCHAR2 | (30) | Rounding Flag | |
CS_CLASSIFICATION | VARCHAR2 | (30) | Yes | Custom Stream Classification |
STRICT_FLAG | VARCHAR2 | (30) | Yes | Strict Flag |
AGGREGATION_ALLOWED_FLAG | VARCHAR2 | (30) | Aggregation Allowed Flag | |
ALLOCATION_ALLOWED_FLAG | VARCHAR2 | (30) | Allocation Allowed Flag | |
STREAM_EDITABLE_FLAG | VARCHAR2 | (30) | Stream Editable Flag | |
PLANNING_SERVER_VIEW_NAME | VARCHAR2 | (30) | Planning Server View | |
CS_TYPE | VARCHAR2 | (30) | Yes | Custom Stream Type |
LOWEST_LEVEL_FLAG | VARCHAR2 | (30) | Lowest Level Flag | |
COMPOSITE_GROUP_CODE | NUMBER | Composite Group Code | ||
DEPENDENT_DATA_FLAG | VARCHAR2 | (30) | Dependent Data Flag | |
DEPENDENT_DEMAND_CODE | VARCHAR2 | (30) | Dependent Demand Code | |
CAPACITY_USAGE_RATIO | VARCHAR2 | (80) | Identifies the Designator to be used by DPE to identiy the Capacity Usage Object | |
DELETEABLE_FLAG | VARCHAR2 | (15) | Indicates whether the record is deleteable or not | |
ENABLE_NONSEED_FLAG | VARCHAR2 | (15) | Indicates whether the fields for this record need to be disabled for non seeded records also | |
SUPPLY_PLAN_FLAG | VARCHAR2 | (15) | Identifies whether the stream is ASCP plan specific or not. | |
PRICE_LIST_NAME | VARCHAR2 | (240) | Name of the price list attached to the Input Parameter | |
ASCP_STREAM_FLAG | VARCHAR2 | (30) | Specifies if this is an ASCP stream | |
STREAM_TYPE | VARCHAR2 | (30) | Specifies the type of the stream. Possible values - NULL, CALCULATED, ARCHIVED, ARCHIVED_WO_TIM | |
EQUATION | VARCHAR2 | (2000) | Equation for calculated type of streams in EOL | |
POST_CALCULATION | VARCHAR2 | (1000) | List of calculated streams to be recalcuated when this stream is recalculated | |
CALCULATED_ORDER | NUMBER | Calculation order for calculated type of streams | ||
DEPENDENT_DEMAND_DESC | VARCHAR2 | (240) | Description for Dependant demand. Added for EOL |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, DEMAND_PLAN_ID
, DEMAND_PLAN_NAME
, PARAMETER_ID
, PARAMETER_NAME
, PARAMETER_TYPE_ID
, PARAMETER_TYPE
, START_DATE
, END_DATE
, INPUT_SCENARIO_ID
, INPUT_SCENARIO_NAME
, INPUT_DEMAND_PLAN_ID
, INPUT_DEMAND_PLAN_NAME
, FORECAST_DATE_USED_ID
, FORECAST_DATE_USED
, DATE_PLANNING_VIEW_CLMN
, QUANTITY_USED_ID
, QUANTITY_USED
, QUANTITY_PLANNING_VIEW_CLMN
, AMOUNT_USED_ID
, AMOUNT_USED
, AMOUNT_PLANNING_VIEW_CLMN
, FORECAST_USED_ID
, FORECAST_USED
, FACT_TYPE_ID
, FACT_TYPE
, REVISION
, VIEW_NAME
, ALLO_AGG_BASIS_STREAM_ID
, NUMBER_OF_PERIOD
, CS_DEFINITION_ID
, MULTIPLE_STREAM_FLAG
, MEASUREMENT_TYPE
, SYSTEM_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, EXCLUDE_FROM_ROLLING_CYCLE
, SCN_BUILD_REFRESH_NUM
, ROUNDING_FLAG
, CS_CLASSIFICATION
, STRICT_FLAG
, AGGREGATION_ALLOWED_FLAG
, ALLOCATION_ALLOWED_FLAG
, STREAM_EDITABLE_FLAG
, PLANNING_SERVER_VIEW_NAME
, CS_TYPE
, LOWEST_LEVEL_FLAG
, COMPOSITE_GROUP_CODE
, DEPENDENT_DATA_FLAG
, DEPENDENT_DEMAND_CODE
, CAPACITY_USAGE_RATIO
, DELETEABLE_FLAG
, ENABLE_NONSEED_FLAG
, SUPPLY_PLAN_FLAG
, PRICE_LIST_NAME
, ASCP_STREAM_FLAG
, STREAM_TYPE
, EQUATION
, POST_CALCULATION
, CALCULATED_ORDER
, DEPENDENT_DEMAND_DESC
FROM APPS.MSD_DP_PARAMETERS_CS_V;
|
|
|