DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 2850: FROM ZX_OUTPUT_CLASSIFICATIONS_V

2846: /* Fix for bug 7162580- Tax Codes are stored at O.U. level, so added a subquery
2847: to fetch the operating_unit */
2848: /*Bug 6843376 Modified the query which fetch the Operating unit */
2849: SELECT 1 INTO l_exists
2850: FROM ZX_OUTPUT_CLASSIFICATIONS_V
2851: WHERE lookup_code = l_item_rec.TAX_CODE
2852: AND enabled_flag = 'Y'
2853: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
2854: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information