APPS.OKL_AM_QUOTES_WF dependencies on OKC_K_LINES_V

Line 1553: FROM OKC_K_LINES_V OKLV,

1549:
1550: -- Get the total number of service lines
1551: CURSOR get_service_lines_csr ( p_khr_id IN NUMBER) IS
1552: SELECT COUNT(OKLV.id)
1553: FROM OKC_K_LINES_V OKLV,
1554: OKC_LINE_STYLES_V OLSV
1555: WHERE OKLV.chr_id = p_khr_id
1556: AND OKLV.lse_id = OLSV.id
1557: AND OLSV.lty_code = 'SOLD_SERVICE'

Line 2790: FROM OKC_K_LINES_V OKLV,

2786: -- Get the next asset id for the contract (only financial lines)
2787: CURSOR get_asset_for_k_csr ( p_khr_id IN NUMBER,
2788: p_current_asset_id IN NUMBER) IS
2789: SELECT OKLV.id cle_id
2790: FROM OKC_K_LINES_V OKLV,
2791: OKC_LINE_STYLES_V OLSV
2792: WHERE OKLV.chr_id = p_khr_id
2793: AND OKLV.id > NVL(p_current_asset_id , 0)
2794: AND OKLV.lse_id = OLSV.id

Line 7564: OKC_K_LINES_V kle

7560: , txl.QUOTE_QUANTITY QUOTE_QUANTITY
7561: FROM OKL_TRX_QUOTES_V trx,
7562: OKL_TXL_QUOTE_LINES_V txl,
7563: OKC_K_HEADERS_V khr,
7564: OKC_K_LINES_V kle
7565: WHERE trx.id = p_qte_id
7566: and txl.qte_id (+) = trx.id
7567: and trx.QST_CODE = 'DRAFTED'
7568: and trx.khr_id = khr.id