DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 2589: FROM ZX_OUTPUT_CLASSIFICATIONS_V

2585: /* Fix for bug 7162580- Tax Codes are stored at O.U. level, so added a subquery
2586: to fetch the operating_unit */
2587: /*Bug 6843376 Modified the query which fetch the Operating unit */
2588: SELECT 1 INTO l_exists
2589: FROM ZX_OUTPUT_CLASSIFICATIONS_V
2590: WHERE lookup_code = l_item_rec.TAX_CODE
2591: AND enabled_flag = 'Y'
2592: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
2593: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information