SELECT DISTINCT T2."DocEntry",T2."DocNum" AS "RR NO",T2."CardName" AS "Name of the Supplier/Manufacturer",T3."ItemCode" AS "Itemcode",T3."Dscription" AS "Item Description",T4."InvntryUom" AS "UOM",T15."U_UTL_BTNO" AS "Mfg Batchno",T15."U_UTL_MFDT",T1...

SELECT distinct T0."ItemCode" AS "Itemcode",T1."U_UTL_BTNO",T0."DocDate",T0."Dscription" AS "Item",T3."InvntryUom" as "UoM", T4."ItmsGrpNam",/*select d."ItmsGrpNam" from oitb d where d."ItmsGrpNam"=[%3]*/T2."PlannedQty" AS "Std. Qty",T0."Quantity" AS...

SELECT distinct T0."ItemCode" AS "Itemcode",T1."U_UTL_BTNO",T0."DocDate",T0."Dscription" AS "Item",T3."InvntryUom" as "UoM", T4."ItmsGrpNam",/*select d."ItmsGrpNam" from oitb d where d."ItmsGrpNam"=[%3]*/T2."PlannedQty" AS "Std. Qty",T0."Quantity" AS...

SELECT distinct T0."ItemCode" AS "Itemcode",T1."U_UTL_BTNO",T0."DocDate",T0."Dscription" AS "Item",T3."InvntryUom" as "UoM", T4."ItmsGrpNam",/*select d."ItmsGrpNam" from oitb d where d."ItmsGrpNam"=[%3]*/T2."PlannedQty" AS "Std. Qty",T0."Quantity" AS...