DBA Data[Home] [Help]

APPS.OKL_OPI_PVT dependencies on OKC_K_LINES_V

Line 1295: FROM okc_k_lines_v okl

1291:
1292: CURSOR l_top_line_csr(cp_contract_id IN NUMBER) IS
1293: SELECT ols.lty_code
1294: ,okl.id
1295: FROM okc_k_lines_v okl
1296: ,okc_line_styles_b ols
1297: WHERE okl.dnz_chr_id = cp_contract_id
1298: AND okl.lse_id = ols.id
1299: AND ols.lty_code = 'FREE_FORM1';

Line 1316: FROM okc_k_lines_v okl

1312: ,(select oki.object1_id1
1313: ,oki.object1_id2
1314: FROM okc_k_items_v oki
1315: ,(SELECT ols.lty_code, okl.id
1316: FROM okc_k_lines_v okl
1317: ,okc_line_styles_b ols
1318: WHERE okl.cle_id = cp_top_line_id
1319: AND okl.lse_id = ols.id
1320: AND ols.lty_code = 'FIXED_ASSET') fa

Line 1336: FROM okc_k_lines_v okl

1332: ,oki.object1_id2
1333: FROM okc_k_items_v oki
1334: ,(SELECT ols.lty_code
1335: ,okl.id
1336: FROM okc_k_lines_v okl
1337: ,okc_line_styles_b ols
1338: ,(SELECT ols.lty_code, okl.id
1339: FROM okc_k_lines_v okl
1340: ,okc_line_styles_b ols

Line 1339: FROM okc_k_lines_v okl

1335: ,okl.id
1336: FROM okc_k_lines_v okl
1337: ,okc_line_styles_b ols
1338: ,(SELECT ols.lty_code, okl.id
1339: FROM okc_k_lines_v okl
1340: ,okc_line_styles_b ols
1341: WHERE okl.cle_id = cp_top_line_id
1342: AND okl.lse_id = ols.id
1343: AND ols.lty_code = 'FREE_FORM2') ff2