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.

[Home] [Help]

APPS.OKL_ACCOUNT_DIST_PVT dependencies on OKL_TXL_CNTRCT_LNS_ALL

Line 2505: FROM OKL_TXL_CNTRCT_LNS_ALL tcl

2501:
2502: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)
2503: IS
2504: SELECT tcl.tcn_id
2505: FROM OKL_TXL_CNTRCT_LNS_ALL tcl
2506: WHERE tcl.id = p_source_id;
2507:
2508:
2509: CURSOR get_tai_id_csr(p_source_id IN NUMBER)

Line 5128: FROM OKL_TXL_CNTRCT_LNS_ALL tcl

5124:
5125: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)
5126: IS
5127: SELECT tcl.tcn_id
5128: FROM OKL_TXL_CNTRCT_LNS_ALL tcl
5129: WHERE tcl.id = p_source_id;
5130:
5131: -- get the ledger based on the p_trx_header_id parameter
5132: CURSOR get_ledger_id_csr

Line 5157: okl_txl_cntrct_lns_all txl,

5153: CURSOR get_acc_event_id(p_tcn_id IN NUMBER)
5154: IS
5155: SELECT distinct dist.accounting_event_id
5156: FROM okl_trns_acc_dstrs_all dist,
5157: okl_txl_cntrct_lns_all txl,
5158: okl_trx_contracts_all trx
5159: WHERE dist.source_id = txl.id
5160: AND txl.tcn_id = trx.id
5161: and trx.id = p_tcn_id;