Query to find Tax Recoverable

Query to find Tax Recoverable

SELECT NVL (attribute_value, ‘N’)
FROM jai_item_templ_hdr_v jih, jai_item_templ_dtls_v jid
WHERE 1 = 1
AND jih.template_hdr_id = jid.template_hdr_id
AND jid.attribute_code = ‘RECOVERABLE’
AND jih.inventory_item_id = lv_inv_item_id
AND jih.organization_id = lv_operating_unit
AND REGIME_ID=10000;