DBA Data[Home] [Help]

APPS.OKL_CURE_CALC_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 541: okl_txd_ar_ln_dtls_b tld

537: AND NVL(aps.amount_due_remaining, 0) > 0
538: and not exists
539: (select tld.id from
540: --okl_xtl_sell_invs_v xls1
541: okl_txd_ar_ln_dtls_b tld
542: ,okl_txl_ar_inv_lns_v til1
543: ,okl_trx_ar_invoices_v tai1 where
544: tai1.id = til1.tai_id and
545: --til1.id = xls1.til_id and

Line 670: okl_txd_ar_ln_dtls_b tld

666: AND (aps.due_date + p_grace_days) < sysdate
667: AND NVL(aps.amount_due_remaining, 0) > 0
668: and not exists
669: (select tld.id from
670: okl_txd_ar_ln_dtls_b tld
671: ,okl_txl_ar_inv_lns_v til1
672: ,okl_trx_ar_invoices_v tai1 where
673: tai1.id = til1.tai_id and
674: til1.id = tld.til_id_details and

Line 1185: okl_txd_ar_ln_dtls_b tld

1181: AND not exists
1182: --(select xls1.lsm_id from
1183: (select tld.id from
1184: --okl_xtl_sell_invs_v xls1
1185: okl_txd_ar_ln_dtls_b tld
1186: ,okl_txl_ar_inv_lns_v til1
1187: ,okl_trx_ar_invoices_v tai1 where
1188: tai1.id = til1.tai_id and
1189: --til1.id = xls1.til_id and

Line 1333: ,okl_txd_ar_ln_dtls_b tld

1329: select count( ps.payment_schedule_id)
1330: from ar_payment_schedules ps
1331: ,okl_bpd_tld_ar_lines_v stream
1332: --,okl_xtl_sell_invs_v xls
1333: ,okl_txd_ar_ln_dtls_b tld
1334: ,okl_txl_ar_inv_lns_v til
1335: ,okl_trx_ar_invoices_v tai
1336: where ps.class ='INV'
1337: and ps.amount_due_remaining = 0