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_LTE_CHRG_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 276: and sel.source_table='RA_CUSTOMER_TRX_LINES_ALL'

272: WHERE last_arl.sel_id = sel.id
273: and orig_arv.pay_sch_class = 'INV'
274: AND orig_arv.STATUS = 'OP'
275: and orig_arl.receivables_invoice_id = sel.source_id
276: and sel.source_table='RA_CUSTOMER_TRX_LINES_ALL'
277: and orig_arl.late_charge_ass_yn = 'Y'
278: and nvl(last_arl.late_charge_ass_yn, 'N') = 'N'
279: and orig_arv.invoice_id = orig_arl.invoice_id
280: and last_arv.invoice_id = last_arl.invoice_id

Line 303: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=orig_arv.invoice_id and

299: and rgp.id = rul_hld.rgp_id
300: and rul_hld.rule_information_category = 'LAHUDT'
301: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
302: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
303: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=orig_arv.invoice_id and
304: trxl.interface_line_attribute6=khr.contract_number)
305: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=last_arv.invoice_id and
306: trxl.interface_line_attribute6=khr.contract_number)
307:

Line 305: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=last_arv.invoice_id and

301: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
302: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
303: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=orig_arv.invoice_id and
304: trxl.interface_line_attribute6=khr.contract_number)
305: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=last_arv.invoice_id and
306: trxl.interface_line_attribute6=khr.contract_number)
307:
308: group by lte.name, khr.currency_code, orig_arl.contract_id,orig_arl.contract_number
309: ,orig_arl.receivables_invoice_number, orig_arl.receivables_invoice_id

Line 469: cns_AR_source_table constant varchar2(25) := 'RA_CUSTOMER_TRX_LINES_ALL';

465: ------------------------------------------------------------
466: cns_late_fee constant varchar2(50) := 'LATE_FEE';
467: cns_late_interest constant varchar2(50) := 'LATE_INTEREST';
468: cns_late_charge_payable constant varchar2(50) := 'INVESTOR_LATE_FEE_PAYABLE';
469: cns_AR_source_table constant varchar2(25) := 'RA_CUSTOMER_TRX_LINES_ALL';
470: cns_cons_source_table constant varchar2(25) := 'OKL_CNSLD_AR_STRMS_V';
471:
472: /* ------------------------------------------------------------
473: -- Stream Id Cursor