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_DP_FORMULAS_V

Object Details

Object Name:	MSD_DP_FORMULAS_V
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 shows all valid formulas

[View Source]

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_TYPE	VARCHAR2	(15)		Type of The Formula Measure
EQUATION	VARCHAR2	(4000)		Equation for the formula
CUSTOM_FIELD1	VARCHAR2	(4000)		Script used to define the formula
CUSTOM_FIELD2	VARCHAR2	(4000)		Script used to define the formula
CUSTOM_SUBTYPE	VARCHAR2	(100)		Subtype of the formula
CUSTOM_ADDTLCALC	VARCHAR2	(4000)		Additional Calculation
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
LAST_UPDATED_BY	NUMBER		Yes	Who Column.
CREATION_DATE	DATE		Yes	Standard who column.
CREATED_BY	NUMBER		Yes	Standard 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.
PROGRAM_UPDATE_DATE	DATE			Extended Who Column.
LAST_UPDATE_DATE	DATE		Yes	Who Column.
FORMAT	VARCHAR2	(80)		Format for the formula measure
UPLOAD_FORMULA_ID	VARCHAR2	(80)		Identifier of the formula that needs to be uploaded 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_TYPE
,      EQUATION
,      CUSTOM_FIELD1
,      CUSTOM_FIELD2
,      CUSTOM_SUBTYPE
,      CUSTOM_ADDTLCALC
,      ISBY
,      SUPPLY_PLAN_FLAG
,      SUPPLY_PLAN_NAME
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      FORMAT
,      UPLOAD_FORMULA_ID
,      START_PERIOD
FROM APPS.MSD_DP_FORMULAS_V;

Dependencies

[top of page]

APPS.MSD_DP_FORMULAS_V references the following:

APPS: MSD_DP_FORMULAS

APPS.MSD_DP_FORMULAS_V is not referenced by any database object