DBA Data[Home] [Help]

APPS.OKL_VENDOR_REFUND_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 430: okl_txd_ar_ln_dtls_b tld

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

Line 594: ,okl_txd_ar_ln_dtls_b tld

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

Line 658: okl_txd_ar_ln_dtls_b tld

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