eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BILL_STATUS_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 21: AR_PAYMENT_SCHEDULES_ALL AR,

17: CURSOR c_last_bill_date(c_khr_id in NUMBER, c_transaction_date in DATE) IS
18: select max(AR.DUE_DATE) last_bill_date, tai.description transaction_type
19: -- abindal bug 4529600 start --
20: from okl_cnsld_ar_strms_b cnsld,
21: AR_PAYMENT_SCHEDULES_ALL AR,
22: OKL_XTL_SELL_INVS_B XTL,
23: okl_trx_ar_invoices_tl tai,
24: okl_txl_ar_inv_lns_b til,
25: okl_txd_ar_ln_dtls_b tld

Line 114: AR_PAYMENT_SCHEDULES_ALL AR,

110: /* -- rmunjulu R12 Fixes -- commented this cursor out and redone below
111: CURSOR c_last_bill_date_1 (c_sel_id in NUMBER, c_khr_id in NUMBER ) IS
112: select AR.DUE_DATE last_bill_date
113: from okl_cnsld_ar_strms_b cnsld,
114: AR_PAYMENT_SCHEDULES_ALL AR,
115: OKL_XTL_SELL_INVS_V XTL,
116: okl_trx_ar_invoices_v tai,
117: okl_txl_ar_inv_lns_v til,
118: okl_txd_ar_ln_dtls_v tld

Line 133: AR_PAYMENT_SCHEDULES_ALL AR,

129: -- rmunjulu R12 Fixes - redone this cursor
130: CURSOR c_last_bill_date_1 (c_sel_id in NUMBER, c_khr_id in NUMBER ) IS
131: select AR.DUE_DATE last_bill_date
132: from --okl_cnsld_ar_strms_b cnsld,
133: AR_PAYMENT_SCHEDULES_ALL AR,
134: --OKL_XTL_SELL_INVS_V XTL,
135: --okl_trx_ar_invoices_v tai,
136: --okl_txl_ar_inv_lns_v til,
137: --okl_txd_ar_ln_dtls_v tld

Line 250: AR_PAYMENT_SCHEDULES_ALL AR,

246: ) IS
247:
248: SELECT max(AR.DUE_DATE) last_bill_date--, tai.description transaction_type
249: FROM okl_cnsld_ar_strms_b cnsld,
250: AR_PAYMENT_SCHEDULES_ALL AR,
251: OKL_XTL_SELL_INVS_V XTL,
252: okl_trx_ar_invoices_v tai,
253: okl_txl_ar_inv_lns_v til,
254: okl_txd_ar_ln_dtls_v tld

Line 296: AR_PAYMENT_SCHEDULES_ALL AR,

292: ) IS
293:
294: SELECT max(AR.DUE_DATE) last_bill_date--, tai.description transaction_type
295: FROM --okl_cnsld_ar_strms_b cnsld,
296: AR_PAYMENT_SCHEDULES_ALL AR,
297: --OKL_XTL_SELL_INVS_V XTL,
298: --okl_trx_ar_invoices_v tai,
299: --okl_txl_ar_inv_lns_v til,
300: --okl_txd_ar_ln_dtls_v tld

Line 440: AR_PAYMENT_SCHEDULES_ALL AR,

436: /* -- rmunjulu R12 Fixes -- commented this cursor out and redone below
437: CURSOR c_oks_last_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
438: select max(AR.DUE_DATE) last_bill_date, tai.description transaction_type
439: from okl_cnsld_ar_strms_b cnsld,
440: AR_PAYMENT_SCHEDULES_ALL AR,
441: OKL_XTL_SELL_INVS_V XTL,
442: okl_trx_ar_invoices_v tai,
443: okl_txl_ar_inv_lns_v til,
444: okl_txd_ar_ln_dtls_v tld

Line 460: AR_PAYMENT_SCHEDULES_ALL AR,

456: -- rmunjulu R12 Fixes - redone this cursor
457: CURSOR c_oks_last_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
458: select max(AR.DUE_DATE) last_bill_date, RACTRL.description transaction_type
459: from --okl_cnsld_ar_strms_b cnsld,
460: AR_PAYMENT_SCHEDULES_ALL AR,
461: --OKL_XTL_SELL_INVS_V XTL,
462: --okl_trx_ar_invoices_v tai,
463: --okl_txl_ar_inv_lns_v til,
464: --okl_txd_ar_ln_dtls_v tld