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_CONTRACT_BOOK_PVT dependencies on OKC_LINE_STYLES_B

Line 1923: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts

1919:
1920: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1921: SELECT cle.ID,
1922: cle.price_negotiated amount
1923: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1924: WHERE cle.lse_id = ls.ID
1925: AND ls.lty_code = ltycode
1926: AND cle.dnz_chr_id = chrid
1927: AND sts.code = cle.sts_code

Line 2638: okc_line_styles_b fa_lse,

2634: fab.current_units current_units
2635: FROM okl_txl_cntrct_lns tcl,
2636: okc_k_lines_b fin_ast_cle,
2637: okc_k_lines_b fa_cle,
2638: okc_line_styles_b fa_lse,
2639: okc_k_items cim,
2640: fa_additions_b fab
2641: WHERE tcl.tcn_id = p_source_trx_id
2642: AND tcl.before_transfer_yn = 'N'

Line 2661: okc_line_styles_b fin_ast_lse,

2657: fab.current_units current_units
2658: FROM okc_k_lines_b fin_ast_cle,
2659: okc_k_lines_b fa_cle,
2660: okc_k_headers_b CHR,
2661: okc_line_styles_b fin_ast_lse,
2662: okc_line_styles_b fa_lse,
2663: okc_k_items cim,
2664: fa_additions_b fab
2665: WHERE CHR.ID = p_orig_chr_id

Line 2662: okc_line_styles_b fa_lse,

2658: FROM okc_k_lines_b fin_ast_cle,
2659: okc_k_lines_b fa_cle,
2660: okc_k_headers_b CHR,
2661: okc_line_styles_b fin_ast_lse,
2662: okc_line_styles_b fa_lse,
2663: okc_k_items cim,
2664: fa_additions_b fab
2665: WHERE CHR.ID = p_orig_chr_id
2666: AND fin_ast_cle.chr_id = CHR.ID

Line 2743: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse

2739:
2740: --Bug# 4631549
2741: CURSOR off_lease_ast_csr (p_orig_chr_id IN NUMBER) IS
2742: SELECT fin_ast_cle.ID
2743: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse
2744: WHERE fin_ast_cle.chr_id = p_orig_chr_id
2745: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
2746: AND fin_ast_cle.lse_id = fin_ast_lse.ID
2747: AND fin_ast_lse.lty_code = 'FREE_FORM1'

Line 2756: okc_line_styles_b fin_ast_lse,

2752: SELECT tas.ID,
2753: tas.tsu_code,
2754: txl.hold_period_days
2755: FROM okc_k_lines_b fin_ast_cle,
2756: okc_line_styles_b fin_ast_lse,
2757: okl_trx_assets tas,
2758: okl_txl_assets_b txl
2759: WHERE fin_ast_cle.chr_id = p_orig_chr_id
2760: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id