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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Inventory Valuation (1) GMF OPM Lot Cost Detail GMF OPM Lot Cost History OPM2 CAC Inventory Organization Summary GMF GL Expense Allocation Detail CAC OPM Costed Formulas - using lexicals for cost components OPM WIP Value - V2
Blitz Report™

Blitz Report™ provides multiple benefits: