VIEW: APPS.GME_BATCH_HEADER_VW

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')