eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RELEASE_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 1837: okl_txl_cntrct_lns tcl

1833: tcl.source_column_3,
1834: tcl.source_value_3
1835: FROM okc_k_lines_v cle,
1836: okc_line_styles_b lse,
1837: okl_txl_cntrct_lns tcl
1838: WHERE cle.chr_id = p_chr_id
1839: AND cle.dnz_chr_id = p_chr_id
1840: AND lse.lty_code = 'FREE_FORM1'
1841: AND cle.lse_id = lse.id

Line 2321: FROM okl_txl_cntrct_lns tcl,

2317: ,p_source_trx_id IN NUMBER)
2318: IS
2319: SELECT fin_ast_cle.id,
2320: fin_ast_cle.name
2321: FROM okl_txl_cntrct_lns tcl,
2322: okc_k_lines_v fin_ast_cle,
2323: okl_trx_quotes_b qte,
2324: okl_txl_quote_lines_b tql
2325: WHERE tcl.tcn_id = p_source_trx_id

Line 2364: FROM okl_txl_cntrct_lns tcl,

2360: ,p_source_trx_id IN NUMBER)
2361: IS
2362: SELECT fin_ast_cle.id,
2363: fin_ast_cle.name
2364: FROM okl_txl_cntrct_lns tcl,
2365: okc_k_lines_v fin_ast_cle,
2366: okl_trx_assets ota,
2367: okl_txl_assets_b otl
2368: WHERE tcl.tcn_id = p_source_trx_id

Line 2531: okl_txl_cntrct_lns tcl

2527: OKC_K_LINES_B USAGE,
2528: OKC_K_LINES_B USUB_LINE,
2529: okc_k_items LINK_ITEM,
2530: okc_k_lines_b top_line,
2531: okl_txl_cntrct_lns tcl
2532: where UITEM.dnz_chr_id=tcl.khr_id
2533: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'
2534: and UITEM.OBJECT1_ID2='#'
2535: and USAGE.id=UITEM.cle_id

Line 3237: FROM okl_txl_cntrct_lns tcl,

3233: ,p_source_trx_id IN NUMBER)
3234: IS
3235: SELECT fin_ast_cle.id,
3236: fin_ast_cle.name
3237: FROM okl_txl_cntrct_lns tcl,
3238: okc_k_lines_v fin_ast_cle
3239: WHERE tcl.tcn_id = p_source_trx_id
3240: AND tcl.before_transfer_yn = 'N'
3241: AND fin_ast_cle.chr_id = p_orig_chr_id

Line 7254: okl_txl_cntrct_lns tcl

7250: tcl.source_column_3,
7251: tcl.source_value_3
7252: FROM okc_k_lines_b cle,
7253: okc_line_styles_b lse,
7254: okl_txl_cntrct_lns tcl
7255: WHERE cle.chr_id = p_chr_id
7256: AND cle.dnz_chr_id = p_chr_id
7257: AND lse.lty_code = 'FREE_FORM1'
7258: AND cle.lse_id = lse.id

Line 7912: FROM okl_txl_cntrct_lns tcl

7908: AND cle.dnz_chr_id = p_new_chr_id
7909: AND lse.lty_code = 'FREE_FORM1'
7910: AND cle.lse_id = lse.id
7911: AND NOT EXISTS (SELECT 1
7912: FROM okl_txl_cntrct_lns tcl
7913: WHERE tcl.tcn_id = p_source_trx_id
7914: AND tcl.kle_id = cle.orig_system_id1
7915: AND tcl.before_transfer_yn = 'N');
7916: