Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | The prod and effectivity info for a formula incl. routing info. This does'nt contain ingredient info. |
Implementation/DBA Data: | APPS.PMIBV_FORMULA_SUMMARY_V |
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 */ EFFECTIVITY.FMEFF_ID
, EFFECTIVITY.ORGN_CODE
, EFFECTIVITY.ITEM_ID
, EFFECTIVITY.ROUTING_ID
, EFFECTIVITY.FORMULA_ID
, EFFECTIVITY.CUST_ID
, /* RESOLVED FOREIGN KEYS */ EFFECTIVITY.FORMULA_USE
, 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
, 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
, FM_FORM_EFF EFFECTIVITY
, FM_ROUT_HDR ROUTING
WHERE EFFECTIVITY.FORMULA_ID(+) = FMASTER.FORMULA_ID
AND ROUTING.ROUTING_ID(+) = EFFECTIVITY.ROUTING_ID
AND FMASTER.INACTIVE_IND = 0
AND FMASTER.DELETE_MARK = 0
AND EFFECTIVITY.DELETE_MARK = 0 WITH READ ONLY