Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | This view is used to generate XML for Recipe Header information in Master Batch Record Generation |
Implementation/DBA Data: | APPS.GMD_MBR_RECIPE_HEADER_V1 |
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