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
Read More