VIEW: APPS.GMD_MBR_RECIPE_HEADER_V1

Source

View Text - Preformatted

SELECT RECIPE.RECIPE_ID ,RECIPE.RECIPE_DESCRIPTION ,RECIPE.RECIPE_NO ,RECIPE.RECIPE_VERSION ,RECIPE.OWNER_ORGANIZATION_ID ,RECIPE.CREATION_ORGANIZATION_ID ,RECIPE.FORMULA_ID ,RECIPE.ROUTING_ID ,RECIPE.PROJECT_ID ,RECIPE.RECIPE_STATUS ,RECIPE.PLANNED_PROCESS_LOSS ,RECIPE.CONTIGUOUS_IND ,RECIPE.OWNER_ID ,RECIPE.OWNER_LAB_TYPE ,RECIPE.CALCULATE_STEP_QUANTITY ,FORMULA.FORMULA_NO ,FORMULA.FORMULA_DESC1 ,FORMULA.FORMULA_DESC2 ,FORMULA.FORMULA_VERS ,FORMULA.FORMULA_TYPE ,FORMULA.SCALE_TYPE ,FORMULA.FORMULA_CLASS ,FORMULA.FMCONTROL_CLASS ,FORMULA.INACTIVE_IND ,FORMULA.FORMULA_STATUS ,FORMULA.OWNER_ID ,FORMULA.TOTAL_INPUT_QTY ,FORMULA.TOTAL_OUTPUT_QTY ,FORMULA.YIELD_UOM ,FORMULA.OWNER_ORGANIZATION_ID ,FORMULA.MASTER_FORMULA_ID ,ROUTING.ROUTING_NO ,ROUTING.ROUTING_VERS ,ROUTING.ROUTING_CLASS ,ROUTING.ROUTING_QTY ,ROUTING.ITEM_UM ,ROUTING.INACTIVE_IND ,FND_DATE.DATE_TO_DISPLAYDT(ROUTING.EFFECTIVE_START_DATE , FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,FND_DATE.DATE_TO_DISPLAYDT(ROUTING.EFFECTIVE_END_DATE , FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,ROUTING.OWNER_ID ,ROUTING.PROCESS_LOSS ,ROUTING.ROUTING_STATUS ,ROUTING.ENFORCE_STEP_DEPENDENCY ,ROUTING.ROUTING_DESC ,ROUTING.ROUTING_UOM ,ROUTING.OWNER_ORGANIZATION_ID FROM GMD_RECIPES_VL RECIPE, FM_FORM_MST_VL FORMULA, GMD_ROUTINGS_VL ROUTING, GMD_STATUS_VL ROUTING_STATUS, GMD_STATUS_VL FORMULA_STATUS, GMD_STATUS_VL RECIPE_STATUS WHERE RECIPE.FORMULA_ID = FORMULA.FORMULA_ID AND RECIPE.ROUTING_ID = ROUTING.ROUTING_ID(+) AND ROUTING.ROUTING_STATUS = ROUTING_STATUS.STATUS_CODE(+) AND FORMULA.FORMULA_STATUS = FORMULA_STATUS.STATUS_CODE AND RECIPE.RECIPE_STATUS = RECIPE_STATUS.STATUS_CODE

View Text - HTML Formatted

SELECT RECIPE.RECIPE_ID
, RECIPE.RECIPE_DESCRIPTION
, RECIPE.RECIPE_NO
, RECIPE.RECIPE_VERSION
, RECIPE.OWNER_ORGANIZATION_ID
, RECIPE.CREATION_ORGANIZATION_ID
, RECIPE.FORMULA_ID
, RECIPE.ROUTING_ID
, RECIPE.PROJECT_ID
, RECIPE.RECIPE_STATUS
, RECIPE.PLANNED_PROCESS_LOSS
, RECIPE.CONTIGUOUS_IND
, RECIPE.OWNER_ID
, RECIPE.OWNER_LAB_TYPE
, RECIPE.CALCULATE_STEP_QUANTITY
, FORMULA.FORMULA_NO
, FORMULA.FORMULA_DESC1
, FORMULA.FORMULA_DESC2
, FORMULA.FORMULA_VERS
, FORMULA.FORMULA_TYPE
, FORMULA.SCALE_TYPE
, FORMULA.FORMULA_CLASS
, FORMULA.FMCONTROL_CLASS
, FORMULA.INACTIVE_IND
, FORMULA.FORMULA_STATUS
, FORMULA.OWNER_ID
, FORMULA.TOTAL_INPUT_QTY
, FORMULA.TOTAL_OUTPUT_QTY
, FORMULA.YIELD_UOM
, FORMULA.OWNER_ORGANIZATION_ID
, FORMULA.MASTER_FORMULA_ID
, ROUTING.ROUTING_NO
, ROUTING.ROUTING_VERS
, ROUTING.ROUTING_CLASS
, ROUTING.ROUTING_QTY
, ROUTING.ITEM_UM
, ROUTING.INACTIVE_IND
, FND_DATE.DATE_TO_DISPLAYDT(ROUTING.EFFECTIVE_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(ROUTING.EFFECTIVE_END_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, ROUTING.OWNER_ID
, ROUTING.PROCESS_LOSS
, ROUTING.ROUTING_STATUS
, ROUTING.ENFORCE_STEP_DEPENDENCY
, ROUTING.ROUTING_DESC
, ROUTING.ROUTING_UOM
, ROUTING.OWNER_ORGANIZATION_ID
FROM GMD_RECIPES_VL RECIPE
, FM_FORM_MST_VL FORMULA
, GMD_ROUTINGS_VL ROUTING
, GMD_STATUS_VL ROUTING_STATUS
, GMD_STATUS_VL FORMULA_STATUS
, GMD_STATUS_VL RECIPE_STATUS
WHERE RECIPE.FORMULA_ID = FORMULA.FORMULA_ID
AND RECIPE.ROUTING_ID = ROUTING.ROUTING_ID(+)
AND ROUTING.ROUTING_STATUS = ROUTING_STATUS.STATUS_CODE(+)
AND FORMULA.FORMULA_STATUS = FORMULA_STATUS.STATUS_CODE
AND RECIPE.RECIPE_STATUS = RECIPE_STATUS.STATUS_CODE