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.INVPVDR4 dependencies on HR_ORGANIZATION_INFORMATION

Line 434: Table hr_organization_information is used instead of org_organization_defintions*/

430: BEGIN
431: /* Fix for bug 6804003 - Tax Codes are stored at O.U. level, so added
432: an inner subquery to fetch the operating_unit */
433: /*Bug 7437620 Modified the query to fetch the operating unit
434: Table hr_organization_information is used instead of org_organization_defintions*/
435:
436: SELECT 'valid_tax_code' into pur_dummy
437: FROM dual
438: WHERE EXISTS( SELECT NULL

Line 445: AND org_id IN (-99,(SELECT org_information3 FROM hr_organization_information

441: WHERE nvl(tax_type,'X') not in ('AWT','OFFSET')
442: AND enabled_flag = 'Y'
443: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
444: AND lookup_code = cr.purchasing_tax_code
445: AND org_id IN (-99,(SELECT org_information3 FROM hr_organization_information
446: WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
447: AND ORGANIZATION_ID=cr.organization_id)))
448: AND ROWNUM = 1;
449: EXCEPTION