DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on MTL_SYSTEM_ITEMS

Line 277: FROM mtl_system_items si

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

Line 295: FROM mtl_system_items si

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