VIEW: APPS.PMITS_RECIPE_VALIDITY_RULE_V

Source

View Text - Preformatted

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)))

View Text - HTML Formatted

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)))