Hi
In below code i am getting error
ELECT 'a' AS "Vendor Code",'b' AS "Vendor Name",'b','d', 'e', 'Opening Balance',v_opgDebit,v_opgCredit Union All SELECT T2."CardCode" AS "Vendor Code",T2."CardName" AS "Vendor Name",T2."BPLName",T2."DocNum", T2."DocDate", 'A/p Invoice',0,(T2."DocTotal") + (T2."DpmAmnt") + (T2."DpmVat") FROM "OPCH" T2 WHERE T2."DocDate" >= TO_DATE(:FromDate) and T2."DocDate" <= TO_DATE(:ToDate) AND (T2."CardCode"=:BpCode )
Thanks