Find tax intended use for an Item

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 = 73838
AND jih.organization_id = 101