View: GMD_ERES_RECIPES_VW

Product:	GMD - Process Manufacturing Product Development
Description:
Implementation/DBA Data:	APPS.GMD_ERES_RECIPES_VW

View Text

SELECT A.RECIPE_ID
, A.RECIPE_NO
, A.RECIPE_VERSION
, A.RECIPE_DESCRIPTION
, A.RECIPE_STATUS
, A.ROW_ID
, A.OWNER_ORGANIZATION_ID
, A.CREATION_ORGANIZATION_ID
, A.FORMULA_ID
, A.ROUTING_ID
, A.PROJECT_ID
, A.PLANNED_PROCESS_LOSS
, A.OWNER_ID
, A.OWNER_LAB_TYPE
, A.CALCULATE_STEP_QUANTITY
, A.TEXT_CODE
, A.DELETE_MARK
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.ATTRIBUTE21
, A.ATTRIBUTE22
, A.ATTRIBUTE23
, A.ATTRIBUTE24
, A.ATTRIBUTE25
, A.ATTRIBUTE26
, A.ATTRIBUTE27
, A.ATTRIBUTE28
, A.ATTRIBUTE29
, A.ATTRIBUTE30
, B.FORMULA_NO
, B.FORMULA_VERS
, B.FORMULA_DESC1
, B.FORMULA_STATUS
, C.ROUTING_NO
, C.ROUTING_VERS
, C.ROUTING_DESC
, C.ROUTING_STATUS
, A.RECIPE_TYPE
FROM GMD_RECIPES A
, FM_FORM_MST B
, GMD_ROUTINGS C
WHERE A.FORMULA_ID = B.FORMULA_ID
AND A.ROUTING_ID = C.ROUTING_ID(+)

Columns