Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | Recipe Validity Rules |
Implementation/DBA Data: | APPS.PMITS_RECIPE_VALIDITY_RULE_V |
SELECT RVR.RECIPE_VALIDITY_RULE_ID
, RVR.RECIPE_ID
, RVR.ORGN_CODE
, RVR.ITEM_ID
, RCPU_LKP.MEANING AS RECIPE_USE
, RVR.PREFERENCE
, RVR.START_DATE
, RVR.END_DATE
, RVR.MIN_QTY
, RVR.MAX_QTY
, RVR.STD_QTY
, RVR.ITEM_UM
, RVR.INV_MIN_QTY
, RVR.INV_MAX_QTY
, RVR.TEXT_CODE
, RVR.DELETE_MARK
, RVR.VALIDITY_RULE_STATUS
, RVR.LAB_TYPE
, RC.RECIPE_NO
, RC.RECIPE_VERSION
, IM.ITEM_NO
, IM.ITEM_DESC1
, FM.FORMULA_NO
, FM.FORMULA_VERS
, RT.ROUTING_NO
, RT.ROUTING_VERS
, GS.MEANING AS STATUS
FROM GMD_RECIPE_VALIDITY_RULES RVR
, GMD_RECIPES_VL RC
, IC_ITEM_MST IM
, FM_FORM_MST FM
, FM_ROUT_HDR RT
, GMD_STATUS GS
, GEM_LOOKUPS RCPU_LKP
WHERE RVR.RECIPE_ID = RC.RECIPE_ID
AND RC.FORMULA_ID = FM.FORMULA_ID
AND RC.ROUTING_ID = RT.ROUTING_ID(+)
AND RVR.ITEM_ID = IM.ITEM_ID
AND RVR.VALIDITY_RULE_STATUS = GS.STATUS_CODE
AND RCPU_LKP.LOOKUP_TYPE = 'GMD_FORMULA_USE'
AND RCPU_LKP.LOOKUP_CODE = RVR.RECIPE_USE
AND ((RVR.ORGN_CODE IS NULL) OR ('TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(RVR.ORGN_CODE)))