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 5132: FROM OKL_TXL_CNTRCT_LNS_ALL tcl

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

Line 5161: okl_txl_cntrct_lns_all txl,

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