Product: | GME - Process Manufacturing Process Execution |
---|---|
Description: | Supplementary view based on table gme_batch_step_activities |
Implementation/DBA Data: | APPS.GME_BATCH_STEP_ACTIVITIES_V |
SELECT GBSA.BATCH_ID
, GBSA.ACTIVITY
, GBSA.BATCHSTEP_ID
, GBSA.BATCHSTEP_ACTIVITY_ID
, GBSA.OPRN_LINE_ID
, GBSA.OFFSET_INTERVAL
, GBSA.PLAN_START_DATE
, GBSA.ACTUAL_START_DATE
, GBSA.PLAN_CMPLT_DATE
, GBSA.ACTUAL_CMPLT_DATE
, FND_DATE.DATE_TO_DISPLAYDT(GBSA.PLAN_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBSA.ACTUAL_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBSA.PLAN_CMPLT_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBSA.ACTUAL_CMPLT_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, GBSA.PLAN_ACTIVITY_FACTOR
, GBSA.ACTUAL_ACTIVITY_FACTOR
, GBSA.DELETE_MARK
, GBSA.TEXT_CODE
, GBSA.SEQUENCE_DEPENDENT_IND
, GBSA.MAX_BREAK
, GBSA.BREAK_IND
, GBSA.MATERIAL_IND
, GBS.BATCHSTEP_NO
, GBS.OPERATION_NO OPERATION_NO
, GBS.OPERATION_VERS OPERATION_VERS
, FAM.ACTIVITY_DESC FROM GME_BATCH_STEP_ACTIVITIES GBSA
, GME_BATCH_STEPS_V GBS
, GMD_ACTIVITIES_VL FAM
WHERE GBSA.BATCHSTEP_ID = GBS.BATCHSTEP_ID
AND FAM.ACTIVITY = GBSA.ACTIVITY