Item Tariff Heading -- Oracle Apps R12

SELECT distinct e.attribute_value item_tarrif
FROM              apps.JAI_OM_WSH_LINES_ALL a,
                 OE_ORDER_LINES_ALL b,
                 mtl_system_items c,
                 jai_rgm_itm_regns d,
                 jai_rgm_itm_tmpl_attrs e
WHERE   a.order_line_id = b.line_id
and         b.flow_status_code    in ('SHIPPED','FULFILLMENT','CLOSED')
and   a.inventory_item_id = c.inventory_item_id
and   a.organization_id   = c.organization_id
and   c.inventory_item_id = d.inventory_item_id
and   c.organization_id   = d.organization_id
AND   d.rgm_item_regns_id = e.rgm_item_regns_id
AND e.attribute_code in ('ITEM TARIFF')
and   a.INVENTORY_ITEM_ID=:INVENTORY_ITEM_ID
and     b.header_id          =  :ORDER_HEADER_ID
and     a.delivery_id        =  nvl(:DELIVERY_ID,a.delivery_id);