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_BILLING_RECON_RPT_PVT dependencies on OKL_TXL_AR_INV_LNS_V

Line 63: okl_txl_ar_inv_lns_v til,

59: SUM (NVL(xls.amount,0)) invoice_amount,
60: xsi.currency_code
61: FROM
62: okl_trx_ar_invoices_v tai,
63: okl_txl_ar_inv_lns_v til,
64: okl_txd_ar_ln_dtls_v tld,
65: okl_ext_sell_invs_v xsi,
66: okl_xtl_sell_invs_v xls,
67: okl_k_headers_full_v khr

Line 90: okl_txl_ar_inv_lns_v til,

86: xsi.currency_code
87: FROM okl_ext_sell_invs_v xsi,
88: okl_xtl_sell_invs_v xls,
89: okl_trx_ar_invoices_v tai,
90: okl_txl_ar_inv_lns_v til,
91: okl_k_headers_full_v khr
92: WHERE tai.id = til.tai_id
93: AND xsi.id = xls.xsi_id_details
94: AND xls.til_id = til.id

Line 175: okl_txl_ar_inv_lns_v til,

171: tai.trx_status_code tai,
172: xsi.trx_status_code
173: FROM
174: okl_trx_ar_invoices_v tai,
175: okl_txl_ar_inv_lns_v til,
176: okl_txd_ar_ln_dtls_v tld,
177: okl_ext_sell_invs_v xsi,
178: okl_xtl_sell_invs_v xls
179: WHERE tai.id = til.tai_id

Line 215: okl_txl_ar_inv_lns_v til

211: xsi.trx_status_code
212: FROM okl_ext_sell_invs_v xsi,
213: okl_xtl_sell_invs_v xls,
214: okl_trx_ar_invoices_v tai,
215: okl_txl_ar_inv_lns_v til
216: WHERE tai.id = til.tai_id
217: AND xsi.id = xls.xsi_id_details
218: AND xsi.currency_code = p_currency
219: AND xls.til_id = til.id