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.

VIEW: APPS.PMIFV_PRODUCTFORMULA_V

Source

View Text - Preformatted


SELECT fmaster.FORMULA_NO, /*regular attributes*/ fmaster.FORMULA_VERS, fmaster.FORMULA_TYPE, substr(pmi_cost_analz_pack.gmca_get_meaning( 'GMD_FORMULA_USE', fmaster.FORMULA_TYPE),1,80), 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, ingredient.item_no, ingredient.item_desc1, ingredient.item_desc2, product.item_no, product.item_desc1, product.item_desc2, fmaster.CREATED_BY, fmaster.CREATION_DATE, fmaster.LAST_UPDATE_DATE, fmaster.LAST_UPDATED_BY FROM fm_form_mst fmaster, fm_MATL_dtl fdetail, ( SELECT FORMULA_ID, ITEM_ID, ITEM_UM, SUM(QTY) QTY FROM FM_MATL_DTL WHERE LINE_TYPE=1 GROUP BY FORMULA_ID,ITEM_ID,ITEM_UM ) productdetail, ic_item_mst product, ic_item_mst ingredient WHERE fmaster.formula_id = fdetail.formula_id and fmaster.formula_id = productdetail.formula_id and fdetail.item_id = ingredient.item_id and productdetail.item_id = product.item_id and fdetail.line_type = -1 /* ingredient lines only */ and fmaster.INACTIVE_IND = 0 and fmaster.DELETE_MARK = 0 and 'TRUE' in (select PMI_SECURITY_PKG.show_record(orgn_code) from fm_form_eff where fm_form_eff.formula_id = fmaster.formula_id and fm_form_eff.orgn_code is not NULL union select 'TRUE'from fm_form_eff where fmaster.formula_id = fm_form_eff.formula_id(+) and fm_form_eff.orgn_code is NULL) with read only

View Text - HTML Formatted

SELECT FMASTER.FORMULA_NO
, /*REGULAR ATTRIBUTES*/ FMASTER.FORMULA_VERS
, FMASTER.FORMULA_TYPE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING( 'GMD_FORMULA_USE'
, FMASTER.FORMULA_TYPE)
, 1
, 80)
, 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
, INGREDIENT.ITEM_NO
, INGREDIENT.ITEM_DESC1
, INGREDIENT.ITEM_DESC2
, PRODUCT.ITEM_NO
, PRODUCT.ITEM_DESC1
, PRODUCT.ITEM_DESC2
, FMASTER.CREATED_BY
, FMASTER.CREATION_DATE
, FMASTER.LAST_UPDATE_DATE
, FMASTER.LAST_UPDATED_BY
FROM FM_FORM_MST FMASTER
, FM_MATL_DTL FDETAIL
, ( SELECT FORMULA_ID
, ITEM_ID
, ITEM_UM
, SUM(QTY) QTY
FROM FM_MATL_DTL
WHERE LINE_TYPE=1 GROUP BY FORMULA_ID
, ITEM_ID
, ITEM_UM ) PRODUCTDETAIL
, IC_ITEM_MST PRODUCT
, IC_ITEM_MST INGREDIENT
WHERE FMASTER.FORMULA_ID = FDETAIL.FORMULA_ID
AND FMASTER.FORMULA_ID = PRODUCTDETAIL.FORMULA_ID
AND FDETAIL.ITEM_ID = INGREDIENT.ITEM_ID
AND PRODUCTDETAIL.ITEM_ID = PRODUCT.ITEM_ID
AND FDETAIL.LINE_TYPE = -1 /* INGREDIENT LINES ONLY */
AND FMASTER.INACTIVE_IND = 0
AND FMASTER.DELETE_MARK = 0
AND 'TRUE' IN (SELECT PMI_SECURITY_PKG.SHOW_RECORD(ORGN_CODE)
FROM FM_FORM_EFF
WHERE FM_FORM_EFF.FORMULA_ID = FMASTER.FORMULA_ID
AND FM_FORM_EFF.ORGN_CODE IS NOT NULL UNION SELECT 'TRUE'FROM FM_FORM_EFF
WHERE FMASTER.FORMULA_ID = FM_FORM_EFF.FORMULA_ID(+)
AND FM_FORM_EFF.ORGN_CODE IS NULL) WITH READ ONLY