SELECT Nvl(ooha.cUst_po_Number,'          ')
       ||','
       ||jsPl.Excise_Invoice_No
       ||','
       ||To_char(To_date(jsPl.Excise_Invoice_Date),'dd/mm/yyyy')
       ||','
       ||jsl.Line_Number
       ||','
       ||mcir.Customer_Item_Number
       ||','
       ||mcir.Customer_Item_desc
       ||','
       ||ooha.Order_Number
       ||','
       ||wdd.Requested_Quantity
       ||','
       ||((wdd.Requested_Quantity * jsl.AssessAble_Value) + jptl.Tax_Amount + cess.cess + Nvl(Sales_Tax.Sales_Tax,0) + Nvl(Surcharge.Surcharge,0) + Nvl(Vat.Vat,0))
       ||','
       ||jptl.Tax_Amount
       ||','
       ||cess.cess
       ||','
       ||Nvl(Sales_Tax.Sales_Tax,0)
       ||','
       ||Nvl(Surcharge.Surcharge,0)
       ||','
       ||msi.Attribute4
       ||','
       ||Vat.Vat
FROM   oe_Order_Headers_All ooha,
       oe_Order_Lines_All oola,
       wsh_New_Deliveries wnd,
       wsh_Delivery_Details wdd,
       wsh_Delivery_Assignments wda,
       mtl_System_Items msi,
       ja_In_So_Lines jsl,
       ja_In_So_PickIng_Lines jsPl,
       ja_In_Tax_Codes jtc,
       hz_cUst_Site_Uses_All Ship_su,
       mtl_Customer_Item_xrefs_v mcir,
       ra_Customers rAs,
       ja_In_So_PickIng_Tax_Lines jptl,
       (SELECT   /*+ first_rows(1) */
	             SUM(jtl.Tax_Amount) cess,
                 Delivery_Id ja_Delivery_Id
        FROM     ja_In_Tax_Codes jtc,
                 ja_In_So_PickIng_Tax_Lines jtl,
                 ja_In_So_PickIng_Lines jsPl
        WHERE    jtc.Tax_Id = jtl.Tax_Id
                 AND jtl.Delivery_Detail_Id = jsPl.Delivery_Detail_Id
                 AND jsPl.Excise_Invoice_No BETWEEN &Invoice_No_From
                                                    AND &Invoice_No_UpTo
                 AND Upper(jtc.Tax_Type) IN ('OTHER EXCISE',
                                             'EXCISE_EDUCATION_CESS')
                 AND jtc.Org_Id = jsPl.Org_Id
                 AND jsPl.Org_Id = 146
        GROUP BY Delivery_Id) cess,
       (SELECT Nvl(jtl.Tax_Amount,0) Sales_Tax,
               jtl.Line_Id
        FROM   ja_In_Tax_Codes jtc,
               ja_In_So_Tax_Lines jtl
        WHERE  jtc.Tax_Id = jtl.Tax_Id
               AND Upper(jtc.Tax_Type) IN ('CST',
                                           'SALES TAX')) Sales_Tax,
       (SELECT Nvl(jtl.Tax_Amount,0) Surcharge,
               jtl.Line_Id
        FROM   ja_In_Tax_Codes jtc,
               ja_In_So_Tax_Lines jtl
        WHERE  jtc.Tax_Id = jtl.Tax_Id
               AND Upper(jtc.Tax_Type) LIKE '%SURCHARGE%') Surcharge,
       (SELECT jtl.Tax_Amount Vat,
               jtl.Line_Id
        FROM   ja_In_Tax_Codes jtc,
               ja_In_So_Tax_Lines jtl
        WHERE  jtc.Tax_Id = jtl.Tax_Id
               AND Upper(jtc.Tax_Type) IN ('VALUE ADDED TAX')) Vat
WHERE  ooha.Header_Id = oola.Header_Id
       AND oola.Line_Id = jsl.Line_Id
       AND oola.Header_Id = jsl.Header_Id
       AND wdd.Delivery_Detail_Id = jsPl.Delivery_Detail_Id
       AND wdd.Delivery_Detail_Id = wda.Delivery_Detail_Id
       AND wda.Delivery_Id = wnd.Delivery_Id
       AND wdd.Source_Line_Id = oola.Line_Id
       AND wdd.Source_Header_Id = oola.Header_Id
       AND wdd.Inventory_Item_Id = msi.Inventory_Item_Id
       AND wdd.Organization_Id = msi.Organization_Id
       AND wdd.Source_Code = 'OE'
       AND wdd.Released_Status = 'C'
       AND ooha.Org_Id = 146
                         --AND JSPL.EXCISE_INVOICE_NO  BETWEEN :invoice_no_from AND :invoice_no_upto 	
       AND jtc.Tax_Id = jptl.Tax_Id
       AND Upper(jtc.Tax_Type) = 'EXCISE'
       AND jsPl.Delivery_Detail_Id = jptl.Delivery_Detail_Id
       AND cess.ja_Delivery_Id = wda.Delivery_Id
       AND Sales_Tax.Line_Id (+)  = jsPl.Order_Line_Id
       AND Surcharge.Line_Id (+)  = jsPl.Order_Line_Id
       AND Vat.Line_Id = jsPl.Order_Line_Id
       AND mcir.Inventory_Item_Id = msi.Inventory_Item_Id
       AND mcir.Customer_Id = ooha.Sold_To_Org_Id
       AND ooha.Ship_To_Org_Id = Ship_su.Site_Use_Id (+) 
       AND mcir.Address_Id = Ship_su.cUst_acct_Site_Id
       AND mcir.InActive_Flag = 'N'
       AND mcir.Item_Level = 'Address'
       AND mcir.Customer_Id = 1260
       AND mcir.Customer_Id = rAs.Customer_Id
       AND rAs.Customer_Name = 'HYUNDAI MOTOR  INDIA LTD'