[Home] [Help]
3893: --
3894: AND tcn.khr_id = opp.khr_id)
3895: AND opp.khr_id NOT IN (
3896: SELECT NVL (qte.khr_id, -9999) khr_id
3897: FROM okl_trx_quotes_b qte
3898: WHERE NVL (qte.accepted_yn, 'N') = 'Y'
3899: AND NVL (qte.consolidated_yn, 'N') = 'N'
3900: AND qte.khr_id = opp.khr_id
3901: AND qte.ID NOT IN (