Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by pet ( 13 years ago )
select min(m.schedule_date) as refix_date"
+" from LH_MTG_ORACLE_CONTRACT c"
+" join LH_MTG_ORACLE_CONTRACT_LOAN l on l.mtg_oracle_contract_fk = c.mtg_oracle_contract_pk"
+" join LH_MTG_ORACLE_CON_MILESTONE m on m.mtg_oracle_contract_loan_fk = l.mtg_oracle_contract_loan_pk"
+" where type = '01'"
+" and c.mortgage_fk = ?"
+" and m.schedule_date > ?
Revise this Paste