GMF Item Cost Detail

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Financials
Source: Item Cost Detail Report (XML)
Short Name: CMR05USR_XML
DB package: GMF_CMR05USR_XMLP_PKG
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
Non Block Sql
 
LOV Oracle
SY ALL
 
Structure Id
 
LOV Oracle
Exchange Rate
 
Number
Report Currency
 
LOV Oracle
To Cost Category
 
From Cost Category
 
To Item
 
From Item
 
To Organization
 
LOV Oracle
From Organization
 
LOV Oracle
Cost Type
 
LOV Oracle
Period
 
LOV Oracle
CALENDAR_CODE
 
LOV Oracle
Legal Entity
 
LOV Oracle