DBA Data[Home] [Help]

APPS.OKL_OPI_PVT dependencies on OKC_LINE_STYLES_B

Line 1296: ,okc_line_styles_b ols

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';
1300:

Line 1317: ,okc_line_styles_b ols

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
1321: WHERE oki.cle_id = fa.id) oi

Line 1337: ,okc_line_styles_b ols

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
1341: WHERE okl.cle_id = cp_top_line_id

Line 1340: ,okc_line_styles_b ols

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
1344: WHERE okl.cle_id = ff2.id