GMF Cost Organization Association

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Financials
Source: Cost Organization Association Report (XML)
Short Name: CMRCWA_XML
DB package: GMF_CMRCWA_XMLP_PKG
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
Non Block Sql
 
LOV Oracle
SY ALL
 
Sort By
 
LOV Oracle
To Inventory Organization
 
LOV Oracle
From Inventory Organization
 
LOV Oracle
To Cost Organization
 
LOV Oracle
From Cost Organization
 
LOV Oracle