DBA Data[Home] [Help]

APPS.OKL_UBB_PVT dependencies on OKL_XTL_SELL_INVS_V

Line 670: OKL_XTL_SELL_INVS_V XTL,

666: CURSOR c_last_bill_date(c_khr_id in NUMBER, c_transaction_date in DATE) IS
667: select max(AR.DUE_DATE) last_bill_date, tai.description transaction_type
668: from okl_cnsld_ar_strms_b cnsld,
669: AR_PAYMENT_SCHEDULES_ALL AR,
670: OKL_XTL_SELL_INVS_V XTL,
671: okl_trx_ar_invoices_v tai,
672: okl_txl_ar_inv_lns_v til,
673: okl_txd_ar_ln_dtls_v tld
674: where cnsld.receivables_invoice_id = AR.customer_trx_id