APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_K_LINES_FULL_V

Line 219: l_query := l_query || ' OKL_K_LINES_FULL_V LINE ';

215:
216: l_asset_query_present := 'F'; -- Checks the presence of Asset Related Criteria
217:
218: l_query := 'SELECT CON.ID, CON.CONTRACT_NUMBER, LINE.ID, CON.SHORT_DESCRIPTION FROM OKL_K_HEADERS_FULL_V CON, ';
219: l_query := l_query || ' OKL_K_LINES_FULL_V LINE ';
220:
221: --insert into dd_dummy values (1,l_query);
222:
223: FOR rbk_rec IN mass_rbk_csr(p_request_name)

Line 1284: FROM okl_k_lines_full_v

1280: l_api_version NUMBER := 1.0;
1281:
1282: CURSOR oec_csr (p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
1283: SELECT oec
1284: FROM okl_k_lines_full_v
1285: WHERE id = p_top_line_id;
1286:
1287: l_oec NUMBER;
1288: l_residual_ptg NUMBER;

Line 1393: FROM OKL_K_LINES_FULL_V

1389:
1390: CURSOR addl_line_csr (p_fa_line_id NUMBER) IS
1391: SELECT oec,
1392: name
1393: FROM OKL_K_LINES_FULL_V
1394: WHERE id = (SELECT cle_id
1395: FROM okl_k_lines_full_v
1396: WHERE id = p_fa_line_id);
1397:

Line 1395: FROM okl_k_lines_full_v

1391: SELECT oec,
1392: name
1393: FROM OKL_K_LINES_FULL_V
1394: WHERE id = (SELECT cle_id
1395: FROM okl_k_lines_full_v
1396: WHERE id = p_fa_line_id);
1397:
1398: CURSOR unit_csr (p_fa_line_id NUMBER) IS
1399: SELECT number_of_items

Line 1425: l_name OKL_K_LINES_FULL_V.NAME%TYPE;

1421:
1422: l_try_id NUMBER;
1423: l_fa_line_id NUMBER;
1424:
1425: l_name OKL_K_LINES_FULL_V.NAME%TYPE;
1426: l_oec OKL_K_LINES_FULL_V.OEC%TYPE;
1427: l_no_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;
1429:

Line 1426: l_oec OKL_K_LINES_FULL_V.OEC%TYPE;

1422: l_try_id NUMBER;
1423: l_fa_line_id NUMBER;
1424:
1425: l_name OKL_K_LINES_FULL_V.NAME%TYPE;
1426: l_oec OKL_K_LINES_FULL_V.OEC%TYPE;
1427: l_no_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;
1429:
1430: l_tax_count NUMBER;