APPS.OKL_ARINTF_PVT dependencies on OKC_K_LINES_V

Line 2003: -- OKC_K_LINES_V KLE,

1999: OKL_TXL_AR_INV_LNS_V TIL,
2000: OKL_TRX_AR_INVOICES_V TAI,
2001: OKC_K_HEADERS_ALL_B KHR,
2002: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2003: -- OKC_K_LINES_V KLE,
2004: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2005: OKL_STRM_TYPE_V STY,
2006: OKL_TRX_TYPES_TL TRYT,
2007: OKL_PARALLEL_PROCESSES OPP

Line 2275: from OKC_K_LINES_V cle

2271: connect by cle.id = prior cle.cle_id;
2272:
2273: CURSOR get_top_line_name ( p_cle_id NUMBER ) IS
2274: select cle.name
2275: from OKC_K_LINES_V cle
2276: where cle.id = p_cle_id;
2277:
2278: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2279:

Line 2346: FROM okc_k_lines_v a,

2342: c.location_id = p_location;
2343:
2344: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
2345: SELECT '1'
2346: FROM okc_k_lines_v a,
2347: okc_line_styles_v b
2348: WHERE a.lse_id = b.id
2349: AND b.lty_code = 'SOLD_SERVICE'
2350: AND a.id = p_cle_id;

Line 2354: FROM okc_k_lines_v a,

2350: AND a.id = p_cle_id;
2351:
2352: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
2353: SELECT c.object1_id1
2354: FROM okc_k_lines_v a,
2355: okc_line_styles_v b,
2356: okc_k_items c
2357: WHERE a.lse_id = b.id
2358: AND b.lty_code = 'SOLD_SERVICE'