SELECT 
        CAST(RAV.INVO_NO AS VARCHAR(50)) as Invoice_Number,
        RAV.INVO_CLNTNO as Client_Number,
        TRIM(RAV.INVO_DEBC_DEBC) as Client_Customer_Reference,
        RAV.INVO_DEBC_NO as Debtor_Number,
        RAV.INVO_INVDATE as Invoice_Date,
        RAV.INVO_CLIENT_DUEDATE as Due_Date,
        RAV.INVO_CURRENCY as Currency,
        RAV.INVO_AINITIALI as Document_Amount,
        CAST(RAV.INVO_MARKCODERISK AS VARCHAR(50)) as Risk_Mark_Code,
        CAST(RAV.INVO_COLLECTIONMARKCODE AS VARCHAR(50)) as Collection_Mark_Code,
        RAV.INVO_INVOICENO as Document_Number,
        RAV.INVO_ADMNO as Admin_Number,
        RAV.INVO_DEBH_NO as Heller_Debtor_Number,
        RAV.INVO_DISPUTE_YN as Disputed,
        DEBH.DEBH_HADR_NAME1 as Heller_Debtor_Name,
        RAV.INVO_AACTUALI as Actual_Balance,
        CAST(DEBH.DEBH_LEGALOWNER_DEBH AS VARCHAR(50)) as Legal_Owner,
        INVA_ACTA_NR_F + INVA_ACTA_NR_NF AS NR_Amount,
        INVA_ACTA_R_F + INVA_ACTA_R_NF AS R_Amount,
        DT.CODE_DESCRIPTION as Debtor_Type,        
        CAST(ISFS.ISFS_STATUS AS VARCHAR(50)) as Item_Status,        
        VIN.EFID_VALUE AS VAT_Invoice_Number,
        VID.EFID_VALUE AS VAT_Invoice_Date,
        EC.EFID_VALUE AS End_Customer,
        CN.EFID_VALUE AS Contract_Number
FROM 
        RAV
        INNER JOIN INVA 
        ON INVA.INVA_NO = RAV.INVO_NO
        AND RAV.INVO_CURRENCY = INVA.INVA_CURRENCY
        INNER JOIN DEBH
        ON DEBH.DEBH_NO = RAV.INVO_DEBH_NO
        LEFT JOIN CWCS DT
        ON DT.CODE_NUMBERN = DEBH.DEBH_DEBTORTYPE
        AND DT.CODE_TYPE = 135
        AND DT.CODE_LANGUAGE = 'GB'
        LEFT JOIN ISFS
       ON ISFS.ISFS_INVO_NO = RAV.INVO_NO
       LEFT JOIN EFID VIN
        ON VIN.EFID_INVO_NO = RAV.INVO_NO
        AND VIN.EFID_FIELD_NAME = 'VAT INVOICE NUMBER'
        LEFT JOIN EFID VID
        ON VID.EFID_INVO_NO = RAV.INVO_NO
        AND VID.EFID_FIELD_NAME = 'VAT INVOICE DATE'
        LEFT JOIN EFID VIA
        ON VIA.EFID_INVO_NO = RAV.INVO_NO
       AND VIA.EFID_FIELD_NAME = 'VAT INVOICE AMOUNT'   
       LEFT JOIN EFID EC
        ON EC.EFID_INVO_NO = RAV.INVO_NO
        AND EC.EFID_FIELD_NAME = 'END CUSTOMER'     
        LEFT JOIN EFID CN
        ON CN.EFID_INVO_NO = RAV.INVO_NO
        AND CN.EFID_FIELD_NAME = 'CONTRACT NUMBER'
          
WHERE
        RAV.INVO_AACTUALI > 0 
        AND RAV.INVO_ACCRUAL <> 'Y'
        AND RAV.INVO_MARKCODESPEC <> 943 
        AND RAV.INVO_MARKCODERISK <> 149
        AND (RAV.INVO_CURRENCY = 'USD')
        AND RAV.INVO_INVOICENO IN ('24584667',
'24584666','24584665','24584664','24584663','24584662','24584661','24584660','24584659','24584658',
'24584657','24584656','24584655','24584654','24584653','24584652','24584651','24584650','24584649',
'24584648','24584647','24584646','24584645','24584644','24584643')           
AND ROWNUM <= 5000 ;