Product: | GME - Process Manufacturing Process Execution |
---|---|
Description: | Supplementary view based on table gme_batch_steps |
Implementation/DBA Data: | APPS.GME_BATCH_STEPS_V |
SELECT GBS.BATCH_ID
, GBS.BATCHSTEP_ID
, GBS.ROUTINGSTEP_ID
, GBS.BATCHSTEP_NO
, GBS.OPRN_ID
, GO.OPRN_NO OPERATION_NO
, GO.OPRN_VERS OPERATION_VERS
, GBS.PLAN_STEP_QTY
, GBS.ACTUAL_STEP_QTY
, GBS.BACKFLUSH_QTY
, GBS.PLAN_START_DATE
, GBS.ACTUAL_START_DATE
, GBS.DUE_DATE
, GBS.PLAN_CMPLT_DATE
, GBS.ACTUAL_CMPLT_DATE
, GBS.STEP_CLOSE_DATE
, FND_DATE.DATE_TO_DISPLAYDT(GBS.PLAN_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBS.ACTUAL_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBS.DUE_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBS.PLAN_CMPLT_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBS.ACTUAL_CMPLT_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBS.STEP_CLOSE_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, GBS.STEP_STATUS
, LKUP.MEANING
, GBS.PRIORITY_CODE
, GBS.PRIORITY_VALUE
, GBS.DELETE_MARK
, GBS.STEPRELEASE_TYPE
, GBS.MAX_STEP_CAPACITY
, GBS.PLAN_CHARGES
, GBS.ACTUAL_CHARGES
, GBS.PLAN_MASS_QTY
, GBS.PLAN_VOLUME_QTY
, GBS.TEXT_CODE
, GBS.ACTUAL_MASS_QTY
, GBS.ACTUAL_VOLUME_QTY
, GBS.QUALITY_STATUS
, GBS.MINIMUM_TRANSFER_QTY
, GBS.TERMINATED_IND
, GBS.STEP_QTY_UM
, GBS.MASS_REF_UM
, GBS.VOLUME_REF_UM
, GBS.MAX_STEP_CAPACITY_UM
, DECODE(GBS.TERMINATED_IND
, 1
, FND_MESSAGE.GET_STRING('GME'
, 'GME_TERMINATED')
, NULL) TERMINATED FROM GME_BATCH_STEPS GBS
, GMD_OPERATIONS GO
, GEM_LOOKUPS LKUP
WHERE GBS.OPRN_ID = GO.OPRN_ID
AND LKUP.LOOKUP_TYPE = 'GME_STEP_STATUS'
AND GBS.STEP_STATUS = LKUP.LOOKUP_CODE