VIEW: APPS.GMD_ERES_RECIPES_VW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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