eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_OPM_COGS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 271: hr_organization_information hoi,

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'
275: AND hoi.org_information1 = to_char(gsob.set_of_books_id)

Line 409: hr_organization_information hoi,

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'
413: AND hoi.org_information1 = to_char(gsob.set_of_books_id)

Line 672: hr_organization_information hoi,

668: ap_invoices_all ai,
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

Line 674: hr_organization_information hoi2

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
678: AND ai.source = 'Intercompany'

Line 831: hr_organization_information hoi,

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'
835: AND hoi.org_information1 = to_char(gsob.set_of_books_id)

Line 1006: hr_organization_information hoi,

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'
1010: AND hoi.org_information1 = to_char(gsob.set_of_books_id)