org1.organization_id,
mp.organization_code,
org1.name Organization_Name,
org2.name Operating_Unit,
aa_cc.segment1||'-'||aa_cc.segment2||'-'||aa_cc.segment3||'-'||aa_cc.segment4
||'-'||aa_cc.segment5||'-'||aa_cc.segment6 ap_accrual_account
from
hr_all_organization_units org1,
mtl_parameters mp,
hr_organization_information oi1,
hr_all_organization_units org2,
hr_organization_information oi2,
gl_code_combinations aa_cc
where
org1.organization_id=mp.organization_id
and oi1.organization_id=org1.organization_id
and oi2.organization_id=oi1.organization_id
and aa_cc.code_combination_id=mp.ap_accrual_account
and oi1.org_information_context='CLASS'
and oi1.org_information1='INV'
and oi2.org_information_context='Accounting Information'
and oi2.org_information3=org2.organization_id
order by
mp.organization_code
No comments:
Post a Comment