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_LTE_CHRG_PVT dependencies on OKL_CNSLD_AR_LINES_B

Line 172: ,OKL_CNSLD_AR_LINES_B LN

168: from AR_PAYMENT_SCHEDULES_ALL PS
169: ,OKL_CNSLD_AR_STRMS_B ST
170: ,OKL_CNSLD_AR_HDRS_B HD
171: ,OKC_K_HEADERS_ALL_B CN
172: ,OKL_CNSLD_AR_LINES_B LN
173: ,OKL_STRM_TYPE_B SM
174: ,okl_k_headers_full_v khr
175: ,okc_rule_groups_b rgp
176: ,okc_rules_b rul

Line 334: OKL_CNSLD_AR_LINES_B LN,

330: FROM AR_PAYMENT_SCHEDULES_ALL PS,
331: OKL_CNSLD_AR_STRMS_B ST,
332: OKL_CNSLD_AR_HDRS_B HD,
333: OKC_K_HEADERS_ALL_B CN,
334: OKL_CNSLD_AR_LINES_B LN,
335: OKL_STRM_TYPE_B SM
336: WHERE PS.CLASS IN ('INV', 'CM')
337: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
338: AND CN.ID = ST.KHR_ID

Line 359: OKL_CNSLD_AR_LINES_B LN,

355: FROM AR_PAYMENT_SCHEDULES_ALL PS,
356: OKL_CNSLD_AR_STRMS_B ST,
357: OKL_CNSLD_AR_HDRS_B HD,
358: OKC_K_HEADERS_ALL_B CN,
359: OKL_CNSLD_AR_LINES_B LN,
360: OKL_STRM_TYPE_B SM
361: WHERE PS.CLASS IN ('INV', 'CM')
362: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
363: AND CN.ID = ST.KHR_ID

Line 432: OKL_CNSLD_AR_LINES_B lln,

428: SELECT lsm.id
429: , LATE_CHARGE_ASS_YN
430: , LATE_CHARGE_ASSESS_DATE
431: FROM OKL_CNSLD_AR_STRMS_B lsm,
432: OKL_CNSLD_AR_LINES_B lln,
433: OKL_CNSLD_AR_HDRS_B cnr
434: WHERE cnr.id = l_consolidated_invoice_id
435: and lln.cnr_id = cnr.id
436: and lsm.lln_id = lln.id

Line 544: , okl_cnsld_ar_lines_b lln

540: select lsm.id cnsld_strm_id, pol.khr_id, ps.amount_due_remaining,lsm.kle_id
541: from
542: okl_cnsld_ar_strms_b lsm
543: , okl_cnsld_ar_hdrs_b cnr
544: , okl_cnsld_ar_lines_b lln
545: , okl_pool_contents_v pk
546: -- , okl_pools_v pol
547: , okl_pools pol
548: , ar_payment_schedules_all ps