APPS.OKL_AM_UTIL_PVT dependencies on OKL_TXL_QTE_LINES_ALL_B

Line 403: FROM okl_txl_qte_lines_all_b l

399: l_result NUMBER := 0;
400:
401: CURSOR l_q_lines_csr (cp_quote_id NUMBER) IS
402: SELECT sum (nvl (l.amount,0))
403: FROM okl_txl_qte_lines_all_b l
404: WHERE l.qte_id = cp_quote_id
405: AND l.qlt_code <> 'AMCTAX'; -- rmunjulu sales_tax_enhancement exclude tax line as tax is coming from tax entities
406:
407: -- rmunjulu sales_tax_enhancement

Line 3706: OKL_TXL_QTE_LINES_ALL_B TQL,

3702: QTE.consolidated_yn consolidated_yn,
3703: QTE.qst_code qst_code,
3704: QTE.qtp_code qtp_code
3705: FROM OKL_TRX_QUOTES_B QTE,
3706: OKL_TXL_QTE_LINES_ALL_B TQL,
3707: OKC_K_LINES_B KLE,
3708: OKC_K_HEADERS_ALL_B KHR
3709: WHERE TQL.kle_id = KLE.id
3710: AND TQL.qte_id = QTE.id