SELECT "PO_Header"."PO_No", "RateMaster_Detail"."Conversion_Factor", "PO_Detail"."Qty", "PO_Detail"."Rate", "PO_Detail"."Discount", "Unit_LIB"."Unit_Name", "PO_Header"."Transporter_Id", "PO_Header"."Transport_Amt", "PO_Header"."Loading_Amt", "PO_Header"."OC2_Amt", "supplier"."suppnm", "PO_Header"."Po_Date", "Brand"."Brand", "contractor"."ContNm", "PO_Header"."OC1_Remark", "PO_Header"."OC2_Remark", "PO_Header"."Transport_Incl", "PO_Header"."Loading_Incl", "PO_Header"."OC2_Incl", "PO_Tax"."T1_Amt", "PO_Tax"."T2_Amt", "PO_Tax"."T3_Amt", "PO_Tax"."T4_Amt", "PO_Tax"."T5_Amt", "PO_Tax"."T6_Amt", "PO_Tax"."T7_Amt", "PO_Tax"."T8_Amt", "PO_Detail"."PODetail_Status", "PO_Header"."OC1_Amt", "PO_Header"."OC1_Incl",
 "Material_lib"."Material_Name", "PO_Detail"."Brand_Id", "supplier"."phoneoff", "Project"."Address", "PO_Header"."Remark_Print", "Company"."STReg_No", "Project"."Legal_Address", "Company"."PAN", "Project"."CST_No", "Company"."LST_No", "PO_Detail"."Specifications", "Project"."Company_No", "Company"."Corporate_Id_No", "supplier"."email", "V_Supplier_GSTN"."Address", "V_Supplier_GSTN"."Reg_No", "V_Supplier_GSTN"."State", "V_Company_GSTN"."Reg_No", "V_Company_GSTN"."State", "RateMaster_Detail"."HSN_Code", "Tax"."Tax_Scheme_Name", "Tax"."ReverseCharge", "PO_Header"."Project_Id" FROM   (((((((((((("Supplier" "supplier" INNER JOIN "PO_Header" "PO_Header" ON "supplier"."suppno"="PO_Header"."Supplier_Id") INNER JOIN "PO_Detail" "PO_Detail" ON "PO_Header"."PO_No"="PO_Detail"."PO_No")
 INNER JOIN HighriseEngineering.."Project" "Project" ON "PO_Header"."Project_Id"="Project"."ProjNo")
 LEFT OUTER JOIN HighriseContracting.."Contractor" "contractor" ON "PO_Header"."Transporter_Id"="contractor"."ContNo") LEFT OUTER JOIN "V_Supplier_GSTN" "V_Supplier_GSTN" ON ("PO_Header"."Supplier_Id"="V_Supplier_GSTN"."SuppNo") AND ("PO_Header"."State_Id"="V_Supplier_GSTN"."State_Id")) INNER JOIN "RateMaster_Detail" "RateMaster_Detail" ON "PO_Detail"."RMDetail_Id"="RateMaster_Detail"."RMDetail_Id") INNER JOIN "PO_Tax" "PO_Tax" ON "PO_Detail"."PODetail_Id"="PO_Tax"."PO_No")
 INNER JOIN HighriseEngineering.."Material_Lib" "Material_lib" ON "RateMaster_Detail"."Material_Id"="Material_lib"."Material_No")
 LEFT OUTER JOIN HighriseEngineering.."Unit_Lib" "Unit_LIB" ON "RateMaster_Detail"."Unit_Commercial"="Unit_LIB"."Unit_No") LEFT OUTER JOIN "Brand" "Brand" ON "RateMaster_Detail"."Brand_Id"="Brand"."Brand_Id") INNER JOIN "Tax" "Tax" ON "PO_Tax"."Tax_Scheme_Id"="Tax"."Tax_Scheme_Id")
 INNER JOIN Accounts.."Company" "Company" ON "Project"."Company_No"="Company"."Company_No") LEFT OUTER JOIN
 Accounts.."V_Company_GSTN" ON ("Project"."Company_No"="V_Company_GSTN"."Company_No") AND ("Project"."State_Id"="V_Company_GSTN"."State_Id")
 WHERE  "PO_Header"."PO_No"=3613 AND "PO_Header"."Project_Id"=103 ORDER BY "PO_Header"."PO_No"