APPS.OKL_ARINTF_PVT dependencies on OKC_K_LINES_V

Line 1151: -- OKC_K_LINES_V KLE,

1147: OKL_TXL_AR_INV_LNS_V TIL,
1148: OKL_TRX_AR_INVOICES_V TAI,
1149: OKC_K_HEADERS_ALL_B KHR,
1150: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1151: -- OKC_K_LINES_V KLE,
1152: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1153: OKL_STRM_TYPE_V STY,
1154: OKL_TRX_TYPES_TL TRYT,
1155: OKL_PARALLEL_PROCESSES OPP

Line 1310: from OKC_K_LINES_V cle

1306: connect by cle.id = prior cle.cle_id;
1307:
1308: CURSOR get_top_line_name ( p_cle_id NUMBER ) IS
1309: select cle.name
1310: from OKC_K_LINES_V cle
1311: where cle.id = p_cle_id;
1312:
1313: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1314:

Line 1380: FROM okc_k_lines_v a,

1376: c.location_id = p_location;
1377:
1378: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
1379: SELECT '1'
1380: FROM okc_k_lines_v a,
1381: okc_line_styles_v b
1382: WHERE a.lse_id = b.id
1383: AND b.lty_code = 'SOLD_SERVICE'
1384: AND a.id = p_cle_id;

Line 1388: FROM okc_k_lines_v a,

1384: AND a.id = p_cle_id;
1385:
1386: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1387: SELECT c.object1_id1
1388: FROM okc_k_lines_v a,
1389: okc_line_styles_v b,
1390: okc_k_items c
1391: WHERE a.lse_id = b.id
1392: AND b.lty_code = 'SOLD_SERVICE'