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
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 |