GMF Item Cost Detail

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Item Cost Detail Report of OPM CM
Application: Process Manufacturing Financials
Source: Item Cost Detail Report (XML)
Short Name: CMR05USR_XML
DB package: GMF_CMR05USR_XMLP_PKG
Run GMF Item Cost Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Legal Entity
 
LOV Oracle
CALENDAR_CODE
 
LOV Oracle
Period
 
LOV Oracle
Cost Type
 
LOV Oracle
From Organization
 
LOV Oracle
To Organization
 
LOV Oracle
From Item
 
Char
To Item
 
Char
From Cost Category
 
Char
To Cost Category
 
Char
Report Currency
 
LOV Oracle
Exchange Rate
 
Number
Blitz Report™