APPS.OKL_RELEASE_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 1858: okl_txl_cntrct_lns tcl

1854: tcl.source_column_3,
1855: tcl.source_value_3
1856: FROM okc_k_lines_v cle,
1857: okc_line_styles_b lse,
1858: okl_txl_cntrct_lns tcl
1859: WHERE cle.chr_id = p_chr_id
1860: AND cle.dnz_chr_id = p_chr_id
1861: AND lse.lty_code = 'FREE_FORM1'
1862: AND cle.lse_id = lse.id

Line 2345: FROM okl_txl_cntrct_lns tcl,

2341: ,p_source_trx_id IN NUMBER)
2342: IS
2343: SELECT fin_ast_cle.id,
2344: fin_ast_cle.name
2345: FROM okl_txl_cntrct_lns tcl,
2346: okc_k_lines_v fin_ast_cle,
2347: okl_trx_quotes_b qte,
2348: okl_txl_quote_lines_b tql
2349: WHERE tcl.tcn_id = p_source_trx_id

Line 2388: FROM okl_txl_cntrct_lns tcl,

2384: ,p_source_trx_id IN NUMBER)
2385: IS
2386: SELECT fin_ast_cle.id,
2387: fin_ast_cle.name
2388: FROM okl_txl_cntrct_lns tcl,
2389: okc_k_lines_v fin_ast_cle,
2390: okl_trx_assets ota,
2391: okl_txl_assets_b otl
2392: WHERE tcl.tcn_id = p_source_trx_id

Line 2555: okl_txl_cntrct_lns tcl

2551: OKC_K_LINES_B USAGE,
2552: OKC_K_LINES_B USUB_LINE,
2553: okc_k_items LINK_ITEM,
2554: okc_k_lines_b top_line,
2555: okl_txl_cntrct_lns tcl
2556: where UITEM.dnz_chr_id=tcl.khr_id
2557: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'
2558: and UITEM.OBJECT1_ID2='#'
2559: and USAGE.id=UITEM.cle_id

Line 3291: FROM okl_txl_cntrct_lns tcl,

3287: ,p_source_trx_id IN NUMBER)
3288: IS
3289: SELECT fin_ast_cle.id,
3290: fin_ast_cle.name
3291: FROM okl_txl_cntrct_lns tcl,
3292: okc_k_lines_v fin_ast_cle
3293: WHERE tcl.tcn_id = p_source_trx_id
3294: AND tcl.before_transfer_yn = 'N'
3295: AND fin_ast_cle.chr_id = p_orig_chr_id

Line 7574: okl_txl_cntrct_lns tcl

7570: tcl.source_column_3,
7571: tcl.source_value_3
7572: FROM okc_k_lines_b cle,
7573: okc_line_styles_b lse,
7574: okl_txl_cntrct_lns tcl
7575: WHERE cle.chr_id = p_chr_id
7576: AND cle.dnz_chr_id = p_chr_id
7577: AND lse.lty_code = 'FREE_FORM1'
7578: AND cle.lse_id = lse.id

Line 8236: FROM okl_txl_cntrct_lns tcl

8232: AND cle.dnz_chr_id = p_new_chr_id
8233: AND lse.lty_code = 'FREE_FORM1'
8234: AND cle.lse_id = lse.id
8235: AND NOT EXISTS (SELECT 1
8236: FROM okl_txl_cntrct_lns tcl
8237: WHERE tcl.tcn_id = p_source_trx_id
8238: AND tcl.kle_id = cle.orig_system_id1
8239: AND tcl.before_transfer_yn = 'N');
8240: