VIEW: APPS.GME_BATCH_STEP_ACTIVITIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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