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_INT_EXT_CSH_APP_PVT dependencies on OKL_TXL_RCPT_APPS_V

Line 163: okl_txl_rcpt_apps_v rca

159: rct.attribute14,
160: rct.attribute15
161: FROM okl_trx_csh_batch_v btc,
162: okl_trx_csh_receipt_v rct,
163: okl_txl_rcpt_apps_v rca
164: WHERE btc.ID = rct.btc_id
165: AND rct.ID = rca.rct_id_details
166: AND rct.btc_id = cp_btc_id;
167:

Line 180: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE

176: l_amount okl_trx_csh_receipt_v.amount%TYPE
177: DEFAULT NULL;
178: l_api_version NUMBER DEFAULT 1.0;
179: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
180: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE
181: DEFAULT NULL;
182: l_attribute_category okl_trx_csh_receipt_v.attribute_category%TYPE
183: DEFAULT NULL;
184: l_attribute1 okl_trx_csh_receipt_v.attribute1%TYPE

Line 218: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;

214: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
215: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
216: l_check_number okl_trx_csh_receipt_v.check_number%TYPE
217: DEFAULT NULL;
218: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;
219: l_conversion_rate NUMBER;
220: l_counter NUMBER;
221: l_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
222: DEFAULT NULL;

Line 246: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;

242: l_invoice_currency_code okl_trx_csh_receipt_v.currency_code%TYPE
243: DEFAULT NULL;
244: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
245: DEFAULT NULL;
246: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2 (2000);
249: l_msg_index_out NUMBER;
250: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;

Line 250: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;

246: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2 (2000);
249: l_msg_index_out NUMBER;
250: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;
251: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
252: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
253: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
254: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;

Line 251: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;

247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2 (2000);
249: l_msg_index_out NUMBER;
250: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;
251: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
252: l_rcpt_rec okl_receipts_pvt.rcpt_rec_type;
253: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
254: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
255: l_receipt_currency okl_trx_csh_receipt_v.currency_code%TYPE

Line 684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;

680: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;
683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
686: DEFAULT NULL;
687: l_irm_id okl_trx_csh_receipt_v.irm_id%TYPE
688: DEFAULT NULL;

Line 705: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;

701: l_date_effective okl_trx_csh_receipt_v.date_effective%TYPE
702: DEFAULT NULL;
703: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
704: DEFAULT NULL;
705: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;
706: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
707: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE
708: DEFAULT NULL;
709: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

Line 706: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;

702: DEFAULT NULL;
703: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
704: DEFAULT NULL;
705: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;
706: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
707: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE
708: DEFAULT NULL;
709: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
710: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;

Line 707: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE

703: l_gl_date okl_trx_csh_receipt_v.gl_date%TYPE
704: DEFAULT NULL;
705: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;
706: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
707: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE
708: DEFAULT NULL;
709: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
710: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;
711: l_cust_num ar_cash_receipts_all.pay_from_customer%TYPE

Line 710: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;

706: l_khr_id okl_txl_rcpt_apps_v.khr_id%TYPE DEFAULT NULL;
707: l_ar_inv_id okl_txl_rcpt_apps_v.ar_invoice_id%TYPE
708: DEFAULT NULL;
709: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
710: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;
711: l_cust_num ar_cash_receipts_all.pay_from_customer%TYPE
712: DEFAULT NULL;
713: l_remit_bank_id NUMBER;
714: l_curr_con_type okl_trx_csh_batch_v.currency_conversion_type%TYPE

Line 835: FROM okl_trx_csh_receipt_v rct, okl_txl_rcpt_apps_v rca

831: rca.ar_invoice_id,
832: rca.org_id,
833: rct.gl_date,
834: rct.date_effective
835: FROM okl_trx_csh_receipt_v rct, okl_txl_rcpt_apps_v rca
836: WHERE rct.ID = rca.rct_id_details
837: AND rct.btc_id IS NULL
838: AND rct.btc_id = -1; --to be reviewed and tested later
839: