GMF Actual Cost Adjustments

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
Blitz Report™