VIEW: APPS.GME_BATCH_STEPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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