View: PMIFV_FORMULA_SUMMARY_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	The product and effectivity information for a formula including routing information. This does not contain ingredient information.
Implementation/DBA Data:	APPS.PMIFV_FORMULA_SUMMARY_V

View Text

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 */ EFFECTIVITY.FMEFF_ID
, EFFECTIVITY.ORGN_CODE
, EFFECTIVITY.ITEM_ID
, EFFECTIVITY.ROUTING_ID
, EFFECTIVITY.FORMULA_ID
, EFFECTIVITY.CUST_ID
, /* RESOLVED FOREIGN KEYS */ EFFECTIVITY.FORMULA_USE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING( 'GMD_FORMULA_USE'
, EFFECTIVITY.FORMULA_USE)
, 1
, 80)
, EFFECTIVITY.END_DATE
, EFFECTIVITY.START_DATE
, EFFECTIVITY.INV_MIN_QTY
, EFFECTIVITY.INV_MAX_QTY
, EFFECTIVITY.MIN_QTY
, EFFECTIVITY.MAX_QTY
, EFFECTIVITY.STD_QTY
, EFFECTIVITY.ITEM_UM
, EFFECTIVITY.PREFERENCE
, PRODUCT.ITEM_NO
, PRODUCT.ITEM_DESC1
, PRODUCT.ITEM_DESC2
, CUSTOMER.CUST_NO
, CUSTOMER.CUST_NAME
, ROUTING.ROUTING_NO
, ROUTING.ROUTING_VERS
, ROUTING.ROUTING_DESC
, ROUTING.ROUTING_CLASS
, ROUTING.ROUTING_QTY
, ROUTING.ITEM_UM
, FMASTER.CREATED_BY
, FMASTER.CREATION_DATE
, FMASTER.LAST_UPDATE_DATE
, FMASTER.LAST_UPDATED_BY
FROM FM_FORM_MST FMASTER
, IC_ITEM_MST PRODUCT
, FM_FORM_EFF EFFECTIVITY
, OP_CUST_MST CUSTOMER
, FM_ROUT_HDR ROUTING
WHERE EFFECTIVITY.FORMULA_ID(+) = FMASTER.FORMULA_ID
AND PRODUCT.ITEM_ID(+) = EFFECTIVITY.ITEM_ID
AND CUSTOMER.CUST_ID(+) = EFFECTIVITY.CUST_ID
AND ROUTING.ROUTING_ID(+) = EFFECTIVITY.ROUTING_ID
AND FMASTER.INACTIVE_IND = 0
AND FMASTER.DELETE_MARK = 0
AND EFFECTIVITY.DELETE_MARK = 0
AND (EFFECTIVITY.ORGN_CODE IS NULL OR EFFECTIVITY.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY

Columns