TAAS

Search Query

 SELECT master.pk_adm_or_acm_id, 
    master.sin_type, 
    master.fk_documents_id, 
    doc.vhr_document_no, 

    master.fk_supplier_id, 
    ac.vhr_account_code AS vhr_supplier_code,
    ac.vhr_account_name AS vhr_supplier_name,

    doc.dat_document, 

    master.fk_airline_master_id, 
    air.vhr_airline_code,
    air.vhr_airline_name,

    trans.vhr_ledg_currency, 
    trans.dbl_ledg_cur_debit, 
    trans.dbl_ledg_cur_credit, 
    trans.dbl_ledg_cur_outstanding,

    master.vhr_supplier_currency,
    master.dbl_supplier_cur_roe,
    master.dbl_supplier_cur_amount,
    master.dbl_supplier_base_amount

FROM admacm.tbl_adm_or_acm as master 
LEFT JOIN document.tbl_documents AS doc 
    ON doc.pk_documents_id = master.fk_documents_id 
LEFT JOIN transaction.tbl_transaction as trans 
    ON master.fk_documents_id = trans.fk_documents_id AND trans.sin_record_type IN (42, 43)
LEFT JOIN airticket.tbl_airline_master  AS air
    ON air.pk_airline_master_id = master.fk_airline_master_id
LEFT JOIN accounts.tbl_account  AS ac
    ON ac.pk_account_id = master.fk_supplier_id
WHERE  doc.int_sys_action_id != -1
AND doc.dat_document BETWEEN ? AND ?
AND doc.fk_branch_id = ? 
AND doc.fk_department_id = ?
AND master.fk_supplier_id = ?
AND doc.vhr_document_no = '?'
AND master.fk_airline_master_id = ?
AND doc.vhr_reference = '?'
AND (master.arj_tickets_data = '{}' OR EXISTS ( SELECT 1 FROM unnest(master.arj_tickets_data) AS json_data WHERE json_data->>'TICKET_NO' = '?'))
AND master.sin_type = ?

TESTING DONE

TESTING DONE