997: FROM opi_dbi_wip_scrap_stg) to_conv,
998: (SELECT
999: DISTINCT hoi.organization_id, gsob.currency_code
1000: FROM hr_organization_information hoi,
1001: gl_sets_of_books gsob
1002: WHERE hoi.org_information_context = 'Accounting Information'
1003: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1004: curr_codes
1005: WHERE curr_codes.organization_id = to_conv.organization_id;