View: PMITS_RECIPE_MASTER_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Recipe Master
Implementation/DBA Data:	APPS.PMITS_RECIPE_MASTER_V

View Text

SELECT RC.RECIPE_ID
, RC.RECIPE_DESCRIPTION
, RC.RECIPE_NO
, RC.RECIPE_VERSION
, RC.OWNER_ORGN_CODE
, RC.CREATION_ORGN_CODE
, RC.FORMULA_ID
, RC.ROUTING_ID
, RC.PROJECT_ID
, RC.RECIPE_STATUS
, RC.PLANNED_PROCESS_LOSS
, RC.TEXT_CODE
, RC.DELETE_MARK
, RC.OWNER_ID
, RC.OWNER_LAB_TYPE
, CALQ_LKP.MEANING AS CALCULATE_STEP_QUANTITY
, UR.USER_NAME AS OWNER
, FM.FORMULA_NO
, FM.FORMULA_VERS
, FM.FORMULA_UOM AS RECIPE_UOM
, FM.TOTAL_OUTPUT_QTY
, RT.ROUTING_NO
, RT.ROUTING_VERS
, IM.ITEM_NO AS PRODUCT
, IM.ITEM_UM AS PRODUCT_UOM
, MD.QTY AS PRODUCT_QTY
, GS.MEANING AS STATUS
FROM GMD_RECIPES_VL RC
, FND_USER UR
, FM_FORM_MST FM
, FM_MATL_DTL MD
, FM_ROUT_HDR RT
, IC_ITEM_MST IM
, GMD_STATUS GS
, GEM_LOOKUPS CALQ_LKP
WHERE RC.OWNER_ID = UR.USER_ID
AND RC.FORMULA_ID = FM.FORMULA_ID
AND RC.ROUTING_ID = RT.ROUTING_ID(+)
AND IM.ITEM_ID = MD.ITEM_ID
AND MD.LINE_TYPE = 1
AND MD.LINE_NO = 1
AND MD.FORMULA_ID = FM.FORMULA_ID
AND RC.RECIPE_STATUS = GS.STATUS_CODE
AND CALQ_LKP.LOOKUP_TYPE = 'GME_YES_NO'
AND CALQ_LKP.LOOKUP_CODE = RC.CALCULATE_STEP_QUANTITY
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(RC.OWNER_ORGN_CODE)

Columns