266: (
267: SELECT hou.organization_id organization_id,
268: gsob.currency_code currency_code,
269: to_number(HOI.org_information3) ship_ou_id
270: FROM hr_all_organization_units hou,
271: hr_organization_information hoi,
272: gl_sets_of_books gsob
273: WHERE hou.organization_id = hoi.organization_id
274: AND ( hoi.org_information_context || '') ='Accounting Information'
404: (
405: SELECT hou.organization_id organization_id,
406: gsob.currency_code currency_code,
407: to_number(HOI.org_information3) ship_ou_id
408: FROM hr_all_organization_units hou,
409: hr_organization_information hoi,
410: gl_sets_of_books gsob
411: WHERE hou.organization_id = hoi.organization_id
412: AND ( hoi.org_information_context || '') ='Accounting Information'
826: SELECT /*+ PARALLEL(HOU) PARALLEL(HOI) PARALLEL(GSOB) */
827: hou.organization_id organization_id,
828: gsob.currency_code currency_code,
829: to_number(HOI.org_information3) ship_ou_id
830: FROM hr_all_organization_units hou,
831: hr_organization_information hoi,
832: gl_sets_of_books gsob
833: WHERE hou.organization_id = hoi.organization_id
834: AND ( hoi.org_information_context || '') ='Accounting Information'
1001: SELECT /*+ PARALLEL(HOU) PARALLEL(HOI) PARALLEL(GSOB) */
1002: hou.organization_id organization_id,
1003: gsob.currency_code currency_code,
1004: to_number(HOI.org_information3) ship_ou_id
1005: FROM hr_all_organization_units hou,
1006: hr_organization_information hoi,
1007: gl_sets_of_books gsob
1008: WHERE hou.organization_id = hoi.organization_id
1009: AND ( hoi.org_information_context || '') ='Accounting Information'