GMF Cost Organization Association

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Cost Organization Association Report of OPM CM
Application: Process Manufacturing Financials
Source: Cost Organization Association Report (XML)
Short Name: CMRCWA_XML
DB package: GMF_CMRCWA_XMLP_PKG
Run GMF Cost Organization Association and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  gle.legal_entity_name,
        cwa.cost_organization_id,
        --cmp.organization_code cost_organization_code,
        cmp.organization_code cost_organization_code2,
        chaou.name cost_organization_name,
        gle.legal_entity_id cost_organization_le,
        cwa.organization_id,
        imp.organization_code inv_organization_code,
        haou.name inv_organization_name,
        fnd_date.displaydt_to_date(cwa.eff_start_date) eff_start_date,
        fnd_date.displaydt_to_date(cwa.eff_end_date)  eff_end_date
FROM   cm_whse_Asc cwa,
        hr_all_organization_units chaou,
        hr_organization_information choi,
        mtl_parameters cmp,
        hr_all_organization_units haou,
        mtl_parameters imp,
        gmf_legal_entities_vw2 gle,
        gmd_org_access_vw oa
 WHERE  cwa.cost_organization_id = chaou.organization_id
 AND    cwa.cost_organization_id = cmp.organization_id
 AND    chaou.organization_id = choi.organization_id
 AND    chaou.organization_id = cmp.organization_id
 AND    choi.org_information_context = 'Accounting Information'
 AND    gle.legal_entity_id = choi.org_information2
 AND    cmp.process_enabled_flag = 'Y'
 AND    cwa.organization_id = haou.organization_id
 AND    cwa.organization_id = imp.organization_id
 AND    haou.organization_id = imp.organization_id
 AND    imp.process_enabled_flag = 'Y'
 AND    cwa.delete_mark = 0
 AND    oa.organization_id = cwa.organization_id
       &Cost_OrgnCF
        &Inv_OrgnCF
 ORDER BY
        cmp.organization_code,
        cwa.eff_start_date,
        imp.organization_code
Parameter Name SQL text Validation
From Cost Organization 
 
 LOV Oracle
To Cost Organization 
 
 LOV Oracle
From Inventory Organization 
 
 LOV Oracle
To Inventory Organization 
 
 LOV Oracle
Sort By 
 
 LOV Oracle
Download
Related Blitz Reports
GMF Inventory Valuation GMF OPM Lot Cost Detail GMF OPM Lot Cost History OPM WIP Value OPM2 CAC Inventory Organization Summary GMF GL Expense Allocation Detail OPM WIP Value - V2 GMF GL Expense Allocation Definition
Blitz Report™

Blitz Report™ provides multiple benefits: