GMF Item Cost Detail

SELECT  /*+ leading(cmd) cardinality(cmd,1) */
        distinct iim.item_number item_no1,
        mp.organization_code orgn_code,
        iim.description item_desc,
        decode(cmd.cost_level, 0 ,'This Level Cost',1,'Lower Level','None') Cost_level,
        cmm.cost_cmpntcls_code component_code,
        cmd.cost_analysis_code analysis_code,
        cmd.cmpnt_cost * :P_EXCHANGE_RATE   component_cost,
        iim.primary_uom_code uom,
        cmm.sort_sequence sequence,
        cmm.cost_cmpntcls_id component_id,
        cmm.cost_cmpntcls_desc component_desc
FROM mtl_item_flexfields iim,
     cm_cmpt_dtl_vw cmd,
     mtl_parameters mp,
     cm_cmpt_mst cmm,
     mtl_categories_kfv mckfv,
     mtl_item_categories mic ,
    gmd_org_access_vw  oa
WHERE  cmd.period_id = :period_id
   AND cmd.cost_type_id = :p_cost_type_id
   AND iim.inventory_item_id = cmd.inventory_item_id
   AND cmd.organization_id = iim.organization_id   
   AND iim.organization_id = mp.organization_id
   AND cmm.cost_cmpntcls_id = cmd.cost_cmpntcls_id
   AND cmd.delete_mark = 0
   AND iim.inventory_item_id = mic.inventory_item_id(+)
   AND iim.organization_id = mic.organization_id(+)  
   AND mic.category_id = mckfv.category_id(+) 
   and  mckfv.structure_id(+) = :p_category_structure_id
   AND mp.organization_id = oa.organization_id
   &OrganizationCP
   &ItemCP
   &CostCategoryCP
ORDER BY iim.item_number,
         mp.organization_code,
         cmm.sort_sequence,
         cmm.cost_cmpntcls_code,
         cmd.cost_analysis_code