273: CURSOR c_item IS
274: SELECT si.tax_code,
275: NULL,
276: si.inventory_item_id
277: FROM mtl_system_items si
278: WHERE si.inventory_item_id = p_inventory_item_id
279: AND si.organization_id = p_inventory_organization_id
280: AND exists (select 1
281: from ar_vat_tax vt
291: UNION
292: SELECT tg.tax_code,
293: NULL,
294: si.inventory_item_id
295: FROM mtl_system_items si
296: ,ar_vat_tax vt
297: ,jl_zz_ar_tx_groups tg
298: ,ar_vat_tax vt1
299: WHERE si.inventory_item_id = p_inventory_item_id