View: GME_BATCH_HEADER_VW

Product:	GME - Process Manufacturing Process Execution
Description:	Batch Header view
Implementation/DBA Data:	APPS.GME_BATCH_HEADER_VW

View Text

SELECT B.BATCH_ID
, MP.ORGANIZATION_CODE PLANT_CODE
, MP.ORGANIZATION_CODE
, B.BATCH_NO
, B.BATCH_TYPE
, B.PROD_ID
, B.PROD_SEQUENCE
, B.RECIPE_VALIDITY_RULE_ID
, B.FORMULA_ID
, B.ROUTING_ID
, B.PLAN_START_DATE
, FND_DATE.DATE_TO_DISPLAYDT(B.PLAN_START_DATE) PLAN_START_DATE_DT
, B.ACTUAL_START_DATE
, FND_DATE.DATE_TO_DISPLAYDT(B.ACTUAL_START_DATE) ACTUAL_START_DATE_DT
, B.DUE_DATE
, B.ACTUAL_CMPLT_DATE
, FND_DATE.DATE_TO_DISPLAYDT(B.ACTUAL_CMPLT_DATE) ACTUAL_CMPLT_DATE_DT
, B.BATCH_STATUS
, FLV1.MEANING BATCH_STATUS_DESC
, B.PRIORITY_VALUE
, B.PRIORITY_CODE
, B.PRINT_COUNT
, B.FMCONTROL_CLASS
, B.BATCH_CLOSE_DATE
, FND_DATE.DATE_TO_DISPLAYDT(B.BATCH_CLOSE_DATE) BATCH_CLOSE_DATE_DT
, B.POC_IND
, B.ACTUAL_COST_IND
, B.GL_POSTED_IND
, B.UPDATE_INVENTORY_IND
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.DELETE_MARK
, B.TEXT_CODE
, B.PARENTLINE_ID
, B.FPO_ID
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE16
, B.ATTRIBUTE17
, B.ATTRIBUTE18
, B.ATTRIBUTE19
, B.ATTRIBUTE20
, B.ATTRIBUTE21
, B.ATTRIBUTE22
, B.ATTRIBUTE23
, B.ATTRIBUTE24
, B.ATTRIBUTE25
, B.ATTRIBUTE26
, B.ATTRIBUTE27
, B.ATTRIBUTE28
, B.ATTRIBUTE29
, B.ATTRIBUTE30
, B.ATTRIBUTE31
, B.ATTRIBUTE32
, B.ATTRIBUTE33
, B.ATTRIBUTE34
, B.ATTRIBUTE35
, B.ATTRIBUTE36
, B.ATTRIBUTE37
, B.ATTRIBUTE38
, B.ATTRIBUTE39
, B.ATTRIBUTE40
, B.ATTRIBUTE_CATEGORY
, B.AUTOMATIC_STEP_CALCULATION
, B.PLAN_CMPLT_DATE
, FND_DATE.DATE_TO_DISPLAYDT(B.PLAN_CMPLT_DATE) PLAN_CMPLT_DATE_DT
, F.FORMULA_NO
, F.FORMULA_VERS
, F.FORMULA_DESC1
, R.ROUTING_NO
, R.ROUTING_VERS
, R.ROUTING_DESC
, REC.RECIPE_NO
, REC.RECIPE_VERSION
, REC.RECIPE_DESCRIPTION
, B.FIRMED_IND
, B.FINITE_SCHEDULED_IND
, B.ORDER_PRIORITY
, B.MIGRATED_BATCH_IND
, B.ENFORCE_STEP_DEPENDENCY
, B.TERMINATED_IND
, DECODE(B.TERMINATED_IND
, 1
, FND_MESSAGE.GET_STRING('GME'
, 'GME_TERMINATED')
, NULL) TERMINATED
, MTR.REASON_NAME TERMINATE_REASON
, B.LABORATORY_IND
, FLV2.MEANING LABORATORY
, B.MOVE_ORDER_HEADER_ID
, B.ORGANIZATION_ID
, FND_DATE.DATE_TO_DISPLAYDT(B.DUE_DATE) DUE_DATE_DT
, B.ENHANCED_PI_IND
FROM GME_BATCH_HEADER B
, FM_FORM_MST F
, FM_ROUT_HDR R
, GMD_RECIPES REC
, GMD_RECIPE_VALIDITY_RULES V
, MTL_PARAMETERS MP
, MTL_TRANSACTION_REASONS MTR
, FND_LOOKUP_VALUES FLV1
, FND_LOOKUP_VALUES FLV2
WHERE B.FORMULA_ID = F.FORMULA_ID (+)
AND (B.FORMULA_ID IS NULL OR B.FORMULA_ID = F.FORMULA_ID)
AND B.ROUTING_ID = R.ROUTING_ID (+)
AND B.RECIPE_VALIDITY_RULE_ID = V.RECIPE_VALIDITY_RULE_ID (+)
AND V.RECIPE_ID = REC.RECIPE_ID (+)
AND MP.ORGANIZATION_ID = B.ORGANIZATION_ID
AND MTR.REASON_ID (+) = B.TERMINATE_REASON_ID
AND FLV1.LOOKUP_TYPE = 'GME_BATCH_STATUS'
AND FLV1.LOOKUP_CODE = B.BATCH_STATUS
AND FLV1.LANGUAGE (+) = USERENV('LANG')
AND FLV2.LOOKUP_TYPE = 'GME_LABORATORY_IND'
AND FLV2.LOOKUP_CODE = B.LABORATORY_IND
AND FLV2.LANGUAGE (+) = USERENV('LANG')

Columns