APPS.OKL_BILLING_RECON_RPT_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 62: okl_trx_ar_invoices_v tai,

58: COUNT(*) cnt,
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,

Line 89: okl_trx_ar_invoices_v tai,

85: SUM (NVL(xls.amount,0)) invoice_amount,
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

Line 174: okl_trx_ar_invoices_v tai,

170: xls.xtrx_contract,
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

Line 214: okl_trx_ar_invoices_v tai,

210: tai.trx_status_code tai,
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