Comes back correct Eg. with the .0012 Code I select is:-

SELECT internal_id, ctrpty_id, agreement_number, 

     master_agreement_type, agreement_type, agreement_ccy, 

     one_two_way, business_unit, substitution, 
     recall_period, 
     reset_agreement, valuation_freq, our_threshold_marker, 

     our_threshold_ccy, our_threshold_amount, 

     cparty_threshold_marker, cparty_threshold_ccy, 

     cparty_threshold_amount, our_mta_ccy, our_mta_amount, 

     cparty_mta_ccy, cparty_mta_amount, finance_net_amount, 

     finance_nominal, finance_base_ccy, gcs_pre_haircut, 

     gcs_post_haircut

FROM history..collateral_agreement_h

WHERE effective_to = '01-jan-2079'
  AND internal_id = 1059 
  AND ctrpty_id = 2383
[download]