With Invoice, SV, BPV, Receipt

Select
branch, invoice,sv,bpv,decode(sv_status,'A', 'ACTIVE','V','VOIDED') SV_STATUS, provider_name,ap_code,
--------------------- Get IB ----------------------
(select TBK_BOOKING_NUMBER
from
ke074t3.id_tb_booking_header a,ke074t3.ID_TB_SERVICE_VOUCHER_DETAILS B, ke074t3.id_tb_service_voucher_header c
where TBK_BOOKING_NUMBER=TBSVD_BOOKING_NUMBER
and TBSVD_SV_SERIAL=TBSVH_SERIAL
and tbsvh_sv_number=SV and rownum=1) IB,
---------------------- GET Pax Name --------------------
(select TBK_TMP_CUST_NAME
from
ke074t3.id_tb_booking_header a,ke074t3.ID_TB_SERVICE_VOUCHER_DETAILS B, ke074t3.id_tb_service_voucher_header c
where TBK_BOOKING_NUMBER=TBSVD_BOOKING_NUMBER
and TBSVD_SV_SERIAL=TBSVH_SERIAL
and tbsvh_sv_number=SV and rownum=1) PAX_NAME,
-----------------------Get From date & To Date-------------------
(select TBSVH_SERVICE_FROM_DATE from ke074t3.id_tb_service_voucher_header where TBSVH_SV_NUMBER=SV and rownum=1) From_date,
----------------------------------------------------------------
(select TBSVH_SERVICE_TO_DATE from ke074t3.id_tb_service_voucher_header where TBSVH_SV_NUMBER=SV and rownum=1) To_date,
(select TBSVH_LOCAL_AMOUNT from ke074t3.id_tb_service_voucher_header where TBSVH_SV_NUMBER=SV and rownum=1) Cost_KES,
(select TBSVH_CREATED_BY from ke074t3.id_tb_service_voucher_header where TBSVH_SV_NUMBER=SV and rownum=1) Created_by,
-------------------------------------------------------------
----------------Get Receipt Number -------------------------
(select receipt from ke014t3_support.BCD_ICT_S0171_RECEIPT_WITH_INV where invoice=a.invoice and rownum=1) Receipt

from ke014t3_support.bcd_ict_Inv_bpv_sv a

--select * from id_tb_service_voucher_header  --TBSVH_VOUCHER_REMARKS