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 271: and sel.source_table='RA_CUSTOMER_TRX_LINES_ALL'

267: WHERE last_arl.sel_id = sel.id
268: and orig_arv.pay_sch_class = 'INV'
269: AND orig_arv.STATUS = 'OP'
270: and orig_arl.receivables_invoice_id = sel.source_id
271: and sel.source_table='RA_CUSTOMER_TRX_LINES_ALL'
272: and orig_arl.late_charge_ass_yn = 'Y'
273: and nvl(last_arl.late_charge_ass_yn, 'N') = 'N'
274: and orig_arv.invoice_id = orig_arl.invoice_id
275: and last_arv.invoice_id = last_arl.invoice_id

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

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

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

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

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

460: ------------------------------------------------------------
461: cns_late_fee constant varchar2(50) := 'LATE_FEE';
462: cns_late_interest constant varchar2(50) := 'LATE_INTEREST';
463: cns_late_charge_payable constant varchar2(50) := 'INVESTOR_LATE_FEE_PAYABLE';
464: cns_AR_source_table constant varchar2(25) := 'RA_CUSTOMER_TRX_LINES_ALL';
465: cns_cons_source_table constant varchar2(25) := 'OKL_CNSLD_AR_STRMS_V';
466:
467: /* ------------------------------------------------------------
468: -- Stream Id Cursor