[Home] [Help]
3810: --
3811: AND tcn.khr_id = opp.khr_id)
3812: AND opp.khr_id NOT IN (
3813: SELECT NVL (qte.khr_id, -9999) khr_id
3814: FROM okl_trx_quotes_b qte
3815: WHERE NVL (qte.accepted_yn, 'N') = 'Y'
3816: AND NVL (qte.consolidated_yn, 'N') = 'N'
3817: AND qte.khr_id = opp.khr_id
3818: AND qte.ID NOT IN (