GMF Actual Cost Adjustments

Description
Categories: BI Publisher
Columns: Item No, Item Desc1, Org Code, Cost Cmpntcls Code, Cost Cmpntcls Desc, Cost Analysis Code, Adjust Qty, Adjust Qty Uom, Adjust Cost, Reason Code ...
Application: Process Manufacturing Financials
Source: Actual Cost Adjustments Report (XML)
Short Name: CMR12USR_XML
DB package: GMF_CMR12USR_XMLP_PKG
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
 
To Item
 
SY ALL
 
Non Block Sql
 
LOV Oracle