426: AND NOT EXISTS
427: --(select xls1.lsm_id from
428: (SELECT tld.id
429: FROM --okl_xtl_sell_invs_v xls1
430: okl_txd_ar_ln_dtls_b tld
431: ,okl_txl_ar_inv_lns_v til1
432: ,okl_trx_ar_invoices_v tai1
433: WHERE tai1.id = til1.tai_id
434: AND
590: select count( ps.payment_schedule_id)
591: from ar_payment_schedules_all ps
592: ,okl_bpd_tld_ar_lines_v stream
593: --,okl_xtl_sell_invs_v xls
594: ,okl_txd_ar_ln_dtls_b tld
595: ,okl_txl_ar_inv_lns_v til
596: ,okl_trx_ar_invoices_v tai
597: where ps.class ='INV'
598: and ps.amount_due_remaining = 0
654: AND not exists
655: --( select xls1.lsm_id from
656: ( select tld.id from
657: --okl_xtl_sell_invs_v xls1
658: okl_txd_ar_ln_dtls_b tld
659: ,okl_txl_ar_inv_lns_v til1
660: ,okl_trx_ar_invoices_v tai1 where
661: tai1.id = til1.tai_id
662: --and til1.id = xls1.til_id and