VIEW: APPS.GME_BATCH_STEP_RESOURCES_V

Source

View Text - Preformatted

SELECT gbsr.BATCHSTEP_RESOURCE_ID ,gbsr.BATCHSTEP_ACTIVITY_ID ,gbsr.RESOURCES ,gbsr.BATCHSTEP_ID ,gbsr.BATCH_ID ,gbsr.COST_ANALYSIS_CODE ,gbsr.COST_CMPNTCLS_ID ,gbsr.PRIM_RSRC_IND ,gbsr.SCALE_TYPE ,gbsr.PLAN_RSRC_COUNT ,gbsr.ACTUAL_RSRC_COUNT ,gbsr.PLAN_RSRC_USAGE ,gbsr.ACTUAL_RSRC_USAGE ,gbsr.PLAN_RSRC_QTY ,gbsr.ACTUAL_RSRC_QTY ,gbsr.PLAN_START_DATE ,gbsr.ACTUAL_START_DATE ,gbsr.PLAN_CMPLT_DATE ,gbsr.ACTUAL_CMPLT_DATE ,FND_DATE.DATE_TO_DISPLAYDT(gbsr.PLAN_START_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,FND_DATE.DATE_TO_DISPLAYDT(gbsr.ACTUAL_START_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,FND_DATE.DATE_TO_DISPLAYDT(gbsr.PLAN_CMPLT_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,FND_DATE.DATE_TO_DISPLAYDT(gbsr.ACTUAL_CMPLT_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,gbsr.OFFSET_INTERVAL ,gbsr.MIN_CAPACITY ,gbsr.MAX_CAPACITY ,gbsr.CALCULATE_CHARGES ,gbsr.TEXT_CODE ,gbsr.CAPACITY_TOLERANCE ,gbsr.ORIGINAL_RSRC_QTY ,gbsr.ORIGINAL_RSRC_USAGE ,gbsr.SEQUENCE_DEPENDENT_ID ,gbsr.SEQUENCE_DEPENDENT_USAGE ,gbsr.FIRM_TYPE ,gbsr.GROUP_SEQUENCE_ID ,gbsr.GROUP_SEQUENCE_NUMBER ,gbsr.ORGANIZATION_ID ,gbsr.CAPACITY_UM ,gbsr.USAGE_UM ,gbsr.RESOURCE_QTY_UM ,crm.resource_desc FROM GME_BATCH_STEP_RESOURCES gbsr, cr_rsrc_mst crm WHERE crm.resources = gbsr.resources

View Text - HTML Formatted

SELECT GBSR.BATCHSTEP_RESOURCE_ID
, GBSR.BATCHSTEP_ACTIVITY_ID
, GBSR.RESOURCES
, GBSR.BATCHSTEP_ID
, GBSR.BATCH_ID
, GBSR.COST_ANALYSIS_CODE
, GBSR.COST_CMPNTCLS_ID
, GBSR.PRIM_RSRC_IND
, GBSR.SCALE_TYPE
, GBSR.PLAN_RSRC_COUNT
, GBSR.ACTUAL_RSRC_COUNT
, GBSR.PLAN_RSRC_USAGE
, GBSR.ACTUAL_RSRC_USAGE
, GBSR.PLAN_RSRC_QTY
, GBSR.ACTUAL_RSRC_QTY
, GBSR.PLAN_START_DATE
, GBSR.ACTUAL_START_DATE
, GBSR.PLAN_CMPLT_DATE
, GBSR.ACTUAL_CMPLT_DATE
, FND_DATE.DATE_TO_DISPLAYDT(GBSR.PLAN_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBSR.ACTUAL_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBSR.PLAN_CMPLT_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(GBSR.ACTUAL_CMPLT_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, GBSR.OFFSET_INTERVAL
, GBSR.MIN_CAPACITY
, GBSR.MAX_CAPACITY
, GBSR.CALCULATE_CHARGES
, GBSR.TEXT_CODE
, GBSR.CAPACITY_TOLERANCE
, GBSR.ORIGINAL_RSRC_QTY
, GBSR.ORIGINAL_RSRC_USAGE
, GBSR.SEQUENCE_DEPENDENT_ID
, GBSR.SEQUENCE_DEPENDENT_USAGE
, GBSR.FIRM_TYPE
, GBSR.GROUP_SEQUENCE_ID
, GBSR.GROUP_SEQUENCE_NUMBER
, GBSR.ORGANIZATION_ID
, GBSR.CAPACITY_UM
, GBSR.USAGE_UM
, GBSR.RESOURCE_QTY_UM
, CRM.RESOURCE_DESC
FROM GME_BATCH_STEP_RESOURCES GBSR
, CR_RSRC_MST CRM
WHERE CRM.RESOURCES = GBSR.RESOURCES