TAAS

SELECT 
    MIN(doc.vhr_document_no) AS vhr_document_no,
    MIN(doc.dat_document) AS dat_document,
    MIN(doc.vhr_reference) AS vhr_reference,
    MIN(doc.txt_remarks) AS txt_remarks,
    MIN(doc.fk_branch_id) AS fk_branch_id,
    MIN(br.vhr_branch_code) AS vhr_branch_code,
    MIN(br.vhr_branch_name) AS vhr_branch_name,
    MIN(qm.dat_valid_up_to) AS dat_valid_up_to,
    MIN(doc.fk_ledger_id) AS fk_ledger_id,
    MIN(qm.vhr_phone) AS vhr_phone,
    MIN(qm.vhr_email) AS vhr_email,
    MIN(qm.vhr_address) AS vhr_address,
    MIN(qm.sin_quotation_status) AS sin_quotation_status,
    MIN(qm.txt_cancel_reason) AS txt_cancel_reason,
    SUM(qd.dbl_price) AS dbl_price
FROM quotation.tbl_quotation_details AS qd
LEFT JOIN quotation.tbl_quotation_master AS qm
    ON qd.fk_quotation_master_id = qm.pk_quotation_master_id
LEFT JOIN document.tbl_documents AS doc
    ON qm.fk_documents_id = doc.pk_documents_id
LEFT JOIN organization.tbl_branch AS br
    ON doc.fk_branch_id = br.pk_branch_id
WHERE doc.int_sys_action_id != -1 
    AND vhr_sys_module_name = 'QUOTATION'
    AND doc.dat_document BETWEEN '?' AND '?'
    AND doc.fk_branch_id = ?
    AND doc.fk_department_id = ?
    AND qm.sin_quotation_status = ANY('.?.')
    AND doc.fk_ledger_id = ?
    AND qm.vhr_phone ILIKE '%%' || '?' || '%%' 
    AND doc.vhr_email ILIKE '%%' || '?' || '%%' 
    AND doc.vhr_address ILIKE '%%' || '?' || '%%' 
    AND doc.dat_document ILIKE '%%' || '?' || '%%' 
    AND doc.fk_sub_customer_id = ? / doc.fk_sub_ledger_id = ?
    AND doc.fk_responsible_user_id = ? / doc.fk_responsible_emp_id = ?
GROUP BY qd.fk_quotation_master_id

TESTING DONE

TESTING DONE