DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 2873: FROM ZX_INPUT_CLASSIFICATIONS_V

2869: /* Fix for bug 7162580- Tax Codes are stored at O.U. level, so added a subquery
2870: to fetch the operating_unit */
2871: /*Bug 6843376 Modified the query which fetch the Operating unit */
2872: SELECT 1 INTO l_exists
2873: FROM ZX_INPUT_CLASSIFICATIONS_V
2874: WHERE nvl(tax_type,'X') not in ('AWT','OFFSET') --Modified to fix bug 7588091
2875: AND enabled_flag = 'Y'
2876: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
2877: AND lookup_code = l_Item_rec.PURCHASING_TAX_CODE