View: PMIBV_PRODUCTFORMULA_INV_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Formula Detail with Onhand Quantity of the Ingredients
Implementation/DBA Data:	APPS.PMIBV_PRODUCTFORMULA_INV_V

View Text

SELECT FMASTER.FORMULA_NO
, /*REGULAR ATTRIBUTES*/ FMASTER.FORMULA_VERS
, FMASTER.FORMULA_TYPE
, FMASTER.SCALE_TYPE
, FMASTER.FORMULA_DESC1
, FMASTER.FORMULA_DESC2
, FMASTER.FORMULA_CLASS
, FMASTER.FMCONTROL_CLASS
, FMASTER.FORMULA_ID
, /* ID */ PRODUCTDETAIL.ITEM_ID
, FDETAIL.ITEM_ID
, /* RESOLVED FOREIGN KEYS */ FDETAIL.FORMULALINE_ID
, FDETAIL.LINE_NO
, FDETAIL.QTY
, FDETAIL.ITEM_UM
, FDETAIL.RELEASE_TYPE
, FDETAIL.SCRAP_FACTOR
, FDETAIL.SCALE_TYPE
, FDETAIL.COST_ALLOC
, FDETAIL.PHANTOM_TYPE
, FDETAIL.REWORK_TYPE
, PRODUCTDETAIL.QTY
, PRODUCTDETAIL.ITEM_UM
, FMASTER.CREATED_BY
, FMASTER.CREATION_DATE
, FMASTER.LAST_UPDATE_DATE
, FMASTER.LAST_UPDATED_BY
FROM FM_FORM_MST FMASTER
, FM_MATL_DTL FDETAIL
, FM_MATL_DTL PRODUCTDETAIL
WHERE FMASTER.FORMULA_ID = FDETAIL.FORMULA_ID
AND PRODUCTDETAIL.FORMULA_ID = FMASTER.FORMULA_ID
AND FDETAIL.LINE_TYPE = -1 /* INGREDIENT LINES ONLY */
AND PRODUCTDETAIL.LINE_TYPE = 1 /* PRODUCT LINES ONLY */
AND FMASTER.INACTIVE_IND = 0
AND FMASTER.DELETE_MARK = 0 WITH READ ONLY

Columns