Product: | GME - Process Manufacturing Process Execution |
---|---|
Description: | Supplementary view based on table gme_batch_step_resources |
Implementation/DBA Data: | APPS.GME_BATCH_STEP_RESOURCES_V |
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