GMF Actual Cost Adjustments

Description
Categories: BI Publisher, Manufacturing
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 NameSQL textValidation
Non Block Sql
 
LOV Oracle
SY ALL
 
To Item
 
From Item
 
To Organization
 
LOV Oracle
From Organization
 
LOV Oracle
Cost Type
 
LOV Oracle
Period Code
 
LOV Oracle
CALENDAR_CODE
 
LOV Oracle
Legal Entity
 
LOV Oracle