Site Wise Movement is wrong in SQL Query for customers

Hi all ,

I am using below query to extract entire movement with in a set of period for Customer . So for customer this is giving me correct data , but if I filter same data site wise ( passing site id ) then data doesnt match .

Please help me in closing this . Thanks 

SELECT

    le.ledger_id,

    le.legal_entity_name           company,

    hca.account_name               customer_name,

    hca.account_number             customer_account_no,

    dd.customer_site_use_id,

    dd.gl_date,

    DECODE(dd.class, 'INV', 'INVOICE', 'DM', 'DEBIT NOTE', 'PMT', 'PAYMENT', 'CM', 'CREDIT NOTE') transaction_type,

    dd.trx_number                  receipt_number,

    rct.interface_header_context   transaction_source,