DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 2332: FROM okl_txl_cntrct_lns tcl,

2328: ) IS
2329: SELECT fin_ast_cle.ID asset_id,
2330: fab.asset_number asset_number,
2331: fab.current_units current_units
2332: FROM okl_txl_cntrct_lns tcl,
2333: okc_k_lines_b fin_ast_cle,
2334: okc_k_lines_b fa_cle,
2335: okc_line_styles_b fa_lse,
2336: okc_k_items cim,

Line 2382: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle

2378: p_source_trx_id IN NUMBER
2379: ) IS
2380: SELECT fin_ast_cle.ID,
2381: fin_ast_cle.sts_code
2382: FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle
2383: WHERE tcl.tcn_id = p_source_trx_id
2384: AND tcl.before_transfer_yn = 'N'
2385: AND fin_ast_cle.chr_id = p_orig_chr_id
2386: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id