DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 2612: FROM ZX_INPUT_CLASSIFICATIONS_V

2608: /* Fix for bug 7162580- Tax Codes are stored at O.U. level, so added a subquery
2609: to fetch the operating_unit */
2610: /*Bug 6843376 Modified the query which fetch the Operating unit */
2611: SELECT 1 INTO l_exists
2612: FROM ZX_INPUT_CLASSIFICATIONS_V
2613: WHERE tax_type not in ('AWT','OFFSET')
2614: AND enabled_flag = 'Y'
2615: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
2616: AND lookup_code = l_Item_rec.PURCHASING_TAX_CODE