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.PMIBV_FORMULA_SUMMARY_V

Object Details

Object Name:	PMIBV_FORMULA_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIBV_FORMULA_SUMMARY_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

The prod and effectivity info for a formula incl. routing info. This does'nt contain ingredient info.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FORMULA_NO	VARCHAR2	(32)	Yes	Alphanumeric formula name or number.
FORMULA_VERSION	NUMBER		Yes	Formula version.
FORMULA_TYPE	NUMBER	(5)	Yes	0=std formula; 1=packaged item formula (these are not currently used).
SCALE_TYPE	NUMBER	(5)	Yes	Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled.
FORMULA_DESC1	VARCHAR2	(240)	Yes	Formula description.
FORMULA_DESC2	VARCHAR2	(240)		Formula comment.
FORMULA_CLASS	VARCHAR2	(8)		Formula class. No programatic support (fm_form_cls).
FORMULA_CONTROL_CLASS	VARCHAR2	(8)		Not currently used. (fn_fmct_cls).
FORMULA_ID	NUMBER	(10)	Yes	Surrogate for formula_no + formula_vers.
FORMULA_EFECTIVITY_ID	NUMBER	(15)		Surrogate key for this effectivity row.
ORGNIZATION_CODE	VARCHAR2	(4)		The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.
EFFECTIVITY_ITEM_ID	NUMBER	(15)		Surrogate key for the item which is produced by the formula.
EFECTIVITY_ROUTING_ID	NUMBER	(15)		Surrogate key for the routing/routing version to be used, if any.
EFFECTIVITY_FORMULA_ID	NUMBER	(10)		Surrogate key for the formula /formula version to be used.
EFFECTIVITY_CUST_ID	NUMBER			Surrogate key for the customer for which this effectivity is used, if any.
EFFECTIVITY_FORMULA_USE	VARCHAR2	(30)		The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS.
EFFECTIVITY_END_DATE	DATE			The end date of the effectivity.
EFFECTIVITY_START_DATE	DATE			The start date of the effectivity.
MIN_OUTPUT_QTY_PRIMARY_UOM	NUMBER			The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item.
MAX_OUTPUT_QTY_PRIMARY_UOM	NUMBER			The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item.
MIN_OUTPUT_QTY_EFF_UOM	NUMBER			The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column.
MAX_OUTPUT_QTY_EFF_UOM	NUMBER			The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column.
PRODUCT_QTY	NUMBER			Standard batch size for this rec.
PRODUCT_UOM	VARCHAR2	(4)		UOM for min_qty and max_qty.
EFFECTIVITY_PREFERENCE	NUMBER	(15)		Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column.
CREATED_BY	VARCHAR2	(32)		Standard who column
CREATION_DATE	NUMBER	(5)		Standard who column
LAST_UPDATE_DATE	VARCHAR2	(240)		Standard who column
LAST_UPDATED_BY	VARCHAR2	(4)		Standard who column
ROUTING_NO	NUMBER			Routing name.
ROUTING_VERSION	VARCHAR2	(4)		Routing version.
ROUTING_DESCRIPTION	NUMBER	(15)	Yes	Routing description.
ROUTING_CLASS	DATE		Yes	User defined class for routings.
ROUTING_QTY	DATE		Yes	Used in ratio with formula and batch qty to scale individual step requirements.
ROUTING_ITEM_UOM	NUMBER	(15)	Yes	Uom of routing qty.

Query Text

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


SELECT FORMULA_NO
,      FORMULA_VERSION
,      FORMULA_TYPE
,      SCALE_TYPE
,      FORMULA_DESC1
,      FORMULA_DESC2
,      FORMULA_CLASS
,      FORMULA_CONTROL_CLASS
,      FORMULA_ID
,      FORMULA_EFECTIVITY_ID
,      ORGNIZATION_CODE
,      EFFECTIVITY_ITEM_ID
,      EFECTIVITY_ROUTING_ID
,      EFFECTIVITY_FORMULA_ID
,      EFFECTIVITY_CUST_ID
,      EFFECTIVITY_FORMULA_USE
,      EFFECTIVITY_END_DATE
,      EFFECTIVITY_START_DATE
,      MIN_OUTPUT_QTY_PRIMARY_UOM
,      MAX_OUTPUT_QTY_PRIMARY_UOM
,      MIN_OUTPUT_QTY_EFF_UOM
,      MAX_OUTPUT_QTY_EFF_UOM
,      PRODUCT_QTY
,      PRODUCT_UOM
,      EFFECTIVITY_PREFERENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ROUTING_NO
,      ROUTING_VERSION
,      ROUTING_DESCRIPTION
,      ROUTING_CLASS
,      ROUTING_QTY
,      ROUTING_ITEM_UOM
FROM APPS.PMIBV_FORMULA_SUMMARY_V;

Dependencies

[top of page]

APPS.PMIBV_FORMULA_SUMMARY_V references the following:

APPS: FM_FORM_EFF; FM_FORM_MST; FM_ROUT_HDR

APPS.PMIBV_FORMULA_SUMMARY_V is not referenced by any database object