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_PRODUCTFORMULA_INV_V

Object Details

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

View Type

A Business Intelligence System view

Formula Detail with Onhand Quantity of the Ingredients

[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.
PRODUCT_ITEM_ID	NUMBER	(10)		Surrogate key for the item on the formula line.
INGREDIENT_ITEM_ID	NUMBER	(10)		Surrogate key for the item on the formula line.
INGREDIENT_FORMULALINE_ID	NUMBER	(10)	Yes	Surrogate key for the formula line.
INGREDIENT_LINE_NO	NUMBER	(5)	Yes	List order on screen within a line_type.
INGREDIENT_QTY	NUMBER		Yes	Item qty produced or consumed.
INGREDIENT_ITEM_UOM	VARCHAR2	(4)		Uom of qty.
INGREDIENT_RELEASE_TYPE	NUMBER	(5)	Yes	0=automatic release; 1=partial release.
INGREDIENT_SCRAP_FACTOR	NUMBER		Yes	Scrap factor decimal used to calculate required qty.
INGREDIENT_SCALE_TYPE	NUMBER	(5)	Yes	0=fixed, no scaling; 1=proportional scaling.
COST_ALLOCATION	NUMBER			If product, fractional cost absorption.
PHANTOM_TYPE	NUMBER	(5)	Yes	Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom.
REWORK_TYPE	NUMBER	(5)	Yes	Not currently used.
PRODUCT_QTY	NUMBER		Yes	Item qty produced or consumed.
PRODUCT_UOM	VARCHAR2	(4)		Uom of qty.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column

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
,      PRODUCT_ITEM_ID
,      INGREDIENT_ITEM_ID
,      INGREDIENT_FORMULALINE_ID
,      INGREDIENT_LINE_NO
,      INGREDIENT_QTY
,      INGREDIENT_ITEM_UOM
,      INGREDIENT_RELEASE_TYPE
,      INGREDIENT_SCRAP_FACTOR
,      INGREDIENT_SCALE_TYPE
,      COST_ALLOCATION
,      PHANTOM_TYPE
,      REWORK_TYPE
,      PRODUCT_QTY
,      PRODUCT_UOM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PMIBV_PRODUCTFORMULA_INV_V;

Dependencies

[top of page]

APPS.PMIBV_PRODUCTFORMULA_INV_V references the following:

APPS: FM_FORM_MST; FM_MATL_DTL

APPS.PMIBV_PRODUCTFORMULA_INV_V is not referenced by any database object