A

• Advanced Payment for IECEx03
  --open advanced payment for IECEx03 select im.Receipt_no ,(select referencenbr from tbl_grp_receipt_res rr where rr.invoiceno=im.invoice_no and resid is not null) as referencenbr ,im.Quotation_no, im.File_no,im.Company_Name, case when im.payment_type='Offline' then CONVERT(VARCHAR(10), im.verified_date_ph, ...