APPS.OKL_LTE_CHRG_PVT dependencies on OKL_CNSLD_AR_LINES_B

Line 176: ,OKL_CNSLD_AR_LINES_B LN

172: from AR_PAYMENT_SCHEDULES_ALL PS
173: ,OKL_CNSLD_AR_STRMS_B ST
174: ,OKL_CNSLD_AR_HDRS_B HD
175: ,OKC_K_HEADERS_ALL_B CN
176: ,OKL_CNSLD_AR_LINES_B LN
177: ,OKL_STRM_TYPE_B SM
178: ,okl_k_headers_full_v khr
179: ,okc_rule_groups_b rgp
180: ,okc_rules_b rul

Line 339: OKL_CNSLD_AR_LINES_B LN,

335: FROM AR_PAYMENT_SCHEDULES_ALL PS,
336: OKL_CNSLD_AR_STRMS_B ST,
337: OKL_CNSLD_AR_HDRS_B HD,
338: OKC_K_HEADERS_ALL_B CN,
339: OKL_CNSLD_AR_LINES_B LN,
340: OKL_STRM_TYPE_B SM
341: WHERE PS.CLASS IN ('INV', 'CM')
342: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
343: AND CN.ID = ST.KHR_ID

Line 364: OKL_CNSLD_AR_LINES_B LN,

360: FROM AR_PAYMENT_SCHEDULES_ALL PS,
361: OKL_CNSLD_AR_STRMS_B ST,
362: OKL_CNSLD_AR_HDRS_B HD,
363: OKC_K_HEADERS_ALL_B CN,
364: OKL_CNSLD_AR_LINES_B LN,
365: OKL_STRM_TYPE_B SM
366: WHERE PS.CLASS IN ('INV', 'CM')
367: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
368: AND CN.ID = ST.KHR_ID

Line 437: OKL_CNSLD_AR_LINES_B lln,

433: SELECT lsm.id
434: , LATE_CHARGE_ASS_YN
435: , LATE_CHARGE_ASSESS_DATE
436: FROM OKL_CNSLD_AR_STRMS_B lsm,
437: OKL_CNSLD_AR_LINES_B lln,
438: OKL_CNSLD_AR_HDRS_B cnr
439: WHERE cnr.id = l_consolidated_invoice_id
440: and lln.cnr_id = cnr.id
441: and lsm.lln_id = lln.id

Line 549: , okl_cnsld_ar_lines_b lln

545: select lsm.id cnsld_strm_id, pol.khr_id, ps.amount_due_remaining,lsm.kle_id
546: from
547: okl_cnsld_ar_strms_b lsm
548: , okl_cnsld_ar_hdrs_b cnr
549: , okl_cnsld_ar_lines_b lln
550: , okl_pool_contents_v pk
551: -- , okl_pools_v pol
552: , okl_pools pol
553: , ar_payment_schedules_all ps