[Home] [Help]
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'
275: AND hoi.org_information1 = to_char(gsob.set_of_books_id)
276: ) OU,
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'
413: AND hoi.org_information1 = to_char(gsob.set_of_books_id)
414: ) OU,
669: ra_customer_trx_lines_all rcl,
670: oe_order_lines_all l,
671: oe_order_lines_all pl,
672: hr_organization_information hoi,
673: gl_sets_of_books gsob,
674: hr_organization_information hoi2
675: WHERE aid.invoice_distribution_id >= p_last_dist_id
676: AND aid.invoice_distribution_id < p_new_dist_id
677: AND ai.invoice_id = aid.invoice_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'
835: AND hoi.org_information1 = to_char(gsob.set_of_books_id)
836: ) OU,
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'
1010: AND hoi.org_information1 = to_char(gsob.set_of_books_id)
1011: ) OU,