GMF Actual Cost Adjustments

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Actual Cost Adjustments Report of OPM CM
Application: Process Manufacturing Financials
Source: Actual Cost Adjustments Report (XML)
Short Name: CMR12USR_XML
DB package: GMF_CMR12USR_XMLP_PKG
Run GMF Actual Cost Adjustments and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 
    itm.item_number item_no, 
    itm.description item_desc1, 
    mtl.organization_code , 
    cpt.cost_cmpntcls_code, 
    cpt.cost_cmpntcls_desc, 
    adj.cost_analysis_code, 
    adj.adjust_qty, 
    adj.adjust_qty_uom, 
    adj.adjust_cost, 
    adj.reason_code, 
    rsn.reason_desc
FROM cm_adjs_dtl adj, 
    mtl_item_flexfields itm , 
    cm_cmpt_mst cpt, 
    cm_reas_cds rsn, 
    mtl_parameters mtl,
   gmd_org_access_vw oa 
WHERE adj.inventory_item_id = itm.inventory_item_id 
    AND adj.organization_id = itm.organization_id 
    AND adj.cost_cmpntcls_id = cpt.cost_cmpntcls_id 
    AND adj.reason_code = rsn.reason_code 
    --AND adj.period_id = :period_id 
	AND adj.period_id = :period_id1 
    AND adj.cost_type_id = :p_cost_type_id 
    AND adj.delete_mark = 0 
    AND adj.organization_id = mtl.organization_id 
    AND adj.organization_id = oa.organization_id
    &ItemCP 
    &OrganizationCP 
ORDER BY itm.item_number, itm.organization_id asc
Parameter Name SQL text Validation
Legal Entity 
 
 LOV Oracle
CALENDAR_CODE 
 
 LOV Oracle
Period Code 
 
 LOV Oracle
Cost Type 
 
 LOV Oracle
From Organization 
 
 LOV Oracle
To Organization 
 
 LOV Oracle
From Item 
 
 Char
To Item 
 
 Char
Download
Related Blitz Reports
GMF Item Cost Detail GMF GL Expense Allocation Detail GMF GL Expense Allocation Definition GMF OPM Lot Cost Detail GMD MUV Detail GMF Costed Indented Bill of Materials OPM Actual Item Cost Transaction ECC Cost Management, WIP Valuation (Process) GMF MUV Detail
Blitz Report™

Blitz Report™ provides multiple benefits: