GMF Item Cost Detail

➜ Back to Library
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 
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
Download
Related Blitz Reports
GMF OPM Lot Cost Detail GMF Actual Cost Adjustments GMF GL Expense Allocation Detail GMF GL Expense Allocation Definition CAC Inventory and Intransit Value (Period-End) - Discrete/OPM CAC OPM Costed Formula CAC Inventory Lot and Locator OPM Value (Period-End) ECC Cost Management, WIP Valuation (Process) GMF GL Item Cost Detail
Blitz Report™

Blitz Report™ provides multiple benefits: