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]

TABLE: MSD.MSD_DP_FORMULAS

Object Details

Object Name:	MSD_DP_FORMULAS
Object Type:	TABLE
Owner:	MSD
Subobject Name:
Status:	VALID

This table contains metadata for seeded forumulas

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSD_DP_FORMULAS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEMAND_PLAN_ID FORMULA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_PLAN_ID	NUMBER		Yes	Demand Plan Identifier
FORMULA_ID	NUMBER		Yes	Unique Identifier for the formula
CREATION_SEQUENCE	NUMBER		Yes	Order in which the formula needs to be created.
FORMULA_NAME	VARCHAR2	(80)	Yes	Name of the formula
FORMULA_DESC	VARCHAR2	(80)		Name of the message containg the Description. Shall be replaced by the message text before plan build.
CUSTOM_FIELD1	VARCHAR2	(4000)		Script used to define the formula
CUSTOM_FIELD2	VARCHAR2	(4000)		Script used to define the formula
CUSTOM_TYPE	VARCHAR2	(15)		Type of The Formula Measure
CUSTOM_SUBTYPE	VARCHAR2	(100)		Subtype of the formula
CUSTOM_ADDTLCALC	VARCHAR2	(4000)		Additional Calculation
EQUATION	VARCHAR2	(4000)		Equation for the formula
ISBY	VARCHAR2	(4000)		ISBY
SUPPLY_PLAN_FLAG	VARCHAR2	(15)		Identifies whether the formula is ASCP plan specific or not.
SUPPLY_PLAN_NAME	VARCHAR2	(240)		Name of the Supply Plan
VALID_FLAG	VARCHAR2	(15)		Identifies whether the formula is valid or not.
NUMERATOR	VARCHAR2	(4000)		Stores the numerator String
DENOMINATOR	VARCHAR2	(4000)		Stores the Denominator String
PROGRAM_UPDATE_DATE	DATE			Extended Who Column.
LAST_UPDATE_DATE	DATE		Yes	Who Column.
FORMAT	VARCHAR2	(80)		Format for the formula measure
LAST_UPDATED_BY	NUMBER		Yes	Who Column.
LAST_UPDATE_LOGIN	NUMBER			Who Column.
REQUEST_ID	NUMBER			Extended Who Column.
PROGRAM_APPLICATION_ID	NUMBER			Extended Who Column.
PROGRAM_ID	NUMBER			Extended Who Column.
CREATION_DATE	DATE		Yes	Standard who column.
CREATED_BY	NUMBER		Yes	Standard who column.
UPLOAD_FORMULA_ID	VARCHAR2	(80)		Identifier for the formula that needs to be uploaded along with this formula.
START_PERIOD	VARCHAR2	(30)		Period from which the calculation should begin.

Query Text

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


SELECT DEMAND_PLAN_ID
,      FORMULA_ID
,      CREATION_SEQUENCE
,      FORMULA_NAME
,      FORMULA_DESC
,      CUSTOM_FIELD1
,      CUSTOM_FIELD2
,      CUSTOM_TYPE
,      CUSTOM_SUBTYPE
,      CUSTOM_ADDTLCALC
,      EQUATION
,      ISBY
,      SUPPLY_PLAN_FLAG
,      SUPPLY_PLAN_NAME
,      VALID_FLAG
,      NUMERATOR
,      DENOMINATOR
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      FORMAT
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      CREATION_DATE
,      CREATED_BY
,      UPLOAD_FORMULA_ID
,      START_PERIOD
FROM MSD.MSD_DP_FORMULAS;

Dependencies

[top of page]

MSD.MSD_DP_FORMULAS does not reference any database object

MSD.MSD_DP_FORMULAS is referenced by following:

APPS: MSD_DP_FORMULAS