DBA Data[Home] [Help]

APPS.OKL_LTE_CHRG_PVT dependencies on OKL_POOLS

Line 546: -- , okl_pools_v pol

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
549: , okl_strm_elements_v sel
550: where cnr.id = l_consolidated_invoice_id

Line 547: , okl_pools pol

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
549: , okl_strm_elements_v sel
550: where cnr.id = l_consolidated_invoice_id
551: and lln.cnr_id = cnr.id

Line 574: ,okl_pools pol

570: ,pol.khr_id, pk.kle_id kle_id
571: FROM okl_bpd_ar_inv_lines_v arl
572: ,okl_bpd_ar_invoices_v arv
573: ,okl_pool_contents_v pk
574: ,okl_pools pol
575: WHERE arl.trx_number = cp_con_inv_number
576: AND arl.contract_id = cp_contract_id
577: AND arl.contract_id = pk.khr_id
578: AND nvl(arl.contract_line_id, -99) = nvl(pk.kle_id, -99)