select  COST_CMPNTCLS_CODE, 
      --  crd.RESOURCES, 
        NOMINAL_COST, 
       cmm.COST_MTHD_CODE, 
      -- crd.COST_TYPE_ID,
        gps.period_code,
from CM_RSRC_DTL crd,
gmf_period_statuses gps,
CM_MTHD_MST cmm,
CR_RSRC_MST crm,
CM_CMPT_MST ccm
where gps.period_id = crd.PERIOD_ID 
and crd.cost_type_id = cmm.cost_type_id 
and crd.RESOURCES = crm.RESOURCES
and crm.COST_CMPNTCLS_ID = ccm.COST_CMPNTCLS_ID 
and gps.period_code in (:period1, :period2, :period3)
group by COST_CMPNTCLS_CODE, cmm.COST_MTHD_CODE, gps.period_code,NOMINAL_COST
order by 1,2,3,4