DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 2635: FROM okl_txl_cntrct_lns tcl,

2631: ) IS
2632: SELECT fin_ast_cle.ID asset_id,
2633: fab.asset_number asset_number,
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,

Line 2685: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle

2681: p_source_trx_id IN NUMBER
2682: ) IS
2683: SELECT fin_ast_cle.ID,
2684: fin_ast_cle.sts_code
2685: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle
2686: WHERE tcl.tcn_id = p_source_trx_id
2687: AND tcl.before_transfer_yn = 'N'
2688: AND fin_ast_cle.chr_id = p_orig_chr_id
2689: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id