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_VARIABLE_INTEREST_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1619: ar_receivable_applications_all raa,

1615: ra_customer_trx_lines_all ractrl,
1616: okl_txl_ar_inv_lns_b til,
1617: okl_trx_ar_invoices_b tai,
1618: ar_payment_schedules_all aps,
1619: ar_receivable_applications_all raa,
1620: ar_cash_receipts_all cra,
1621: okl_strm_type_b sty,
1622: ar_distributions_all ad
1623: WHERE tai.trx_status_code = 'PROCESSED'

Line 1652: ar_receivable_applications_all raa,

1648: ra_customer_trx_lines_all ractrl,
1649: okl_txl_ar_inv_lns_b til,
1650: okl_trx_ar_invoices_b tai,
1651: ar_payment_schedules_all aps,
1652: ar_receivable_applications_all raa,
1653: ar_cash_receipts_all cra,
1654: okl_strm_type_b sty
1655: WHERE tai.trx_status_code = 'PROCESSED'
1656: AND tai.khr_id = p_contract_id

Line 1710: ar_receivable_applications_all raa,

1706: ra_customer_trx_lines_all ractrl,
1707: okl_txl_ar_inv_lns_b til,
1708: okl_trx_ar_invoices_b tai,
1709: ar_payment_schedules_all aps,
1710: ar_receivable_applications_all raa,
1711: ra_customer_trx_all cm,
1712: okl_strm_type_b sty,
1713: ar_distributions_all ad
1714: WHERE tai.trx_status_code = 'PROCESSED'

Line 1743: ar_receivable_applications_all raa,

1739: ra_customer_trx_lines_all ractrl,
1740: okl_txl_ar_inv_lns_b til,
1741: okl_trx_ar_invoices_b tai,
1742: ar_payment_schedules_all aps,
1743: ar_receivable_applications_all raa,
1744: ra_customer_trx_all cm,
1745: okl_strm_type_b sty
1746: WHERE tai.trx_status_code = 'PROCESSED'
1747: AND tai.khr_id = p_contract_id

Line 2332: ar_receivable_applications_all raa,

2328: sum(raa.line_applied) txn_amount, -- 4884843, 4872370
2329: 'R' txn_type
2330: FROM okl_bpd_tld_ar_lines_v tld,
2331: ar_payment_schedules_all aps,
2332: ar_receivable_applications_all raa,
2333: ar_cash_receipts_all cra,
2334: okl_strm_type_v sty
2335: WHERE tld.trx_status_code = 'PROCESSED'
2336: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)

Line 2354: ar_receivable_applications_all raa,

2350: sum(raa.line_applied) txn_amount,
2351: 'R' txn_type
2352: FROM okl_bpd_tld_ar_lines_v tld,
2353: ar_payment_schedules_all aps,
2354: ar_receivable_applications_all raa,
2355: ra_customer_trx_all cm,
2356: okl_strm_type_v sty
2357: WHERE tld.trx_status_code = 'PROCESSED'
2358: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)

Line 4534: ,ar_receivable_applications_all raa

4530: ,ra_customer_trx_lines_all ractrl
4531: ,okl_txl_ar_inv_lns_b til
4532: ,okl_trx_ar_invoices_b tai
4533: ,ar_payment_schedules_all aps
4534: ,ar_receivable_applications_all raa
4535: ,ar_cash_receipts_all cra
4536: ,okl_strm_type_b sty
4537: WHERE tai.trx_status_code = 'PROCESSED'
4538: AND tai.khr_id = cp_khr_id

Line 4555: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'

4551: AND tld.til_id_details = til.id
4552: AND til.tai_id = tai.id
4553: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4554: WHERE vpb.khr_id = tld.khr_id
4555: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
4556: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4557: AND vpb.source_id = raa.receivable_application_id)
4558: AND EXISTS (SELECT 1
4559: FROM ar_distributions_all ad

Line 4615: ,ar_receivable_applications_all raa

4611: ,ra_customer_trx_lines_all ractrl
4612: ,okl_txl_ar_inv_lns_b til
4613: ,okl_trx_ar_invoices_b tai
4614: ,ar_payment_schedules_all aps
4615: ,ar_receivable_applications_all raa
4616: ,ra_customer_trx_all cm
4617: ,okl_strm_type_b sty
4618: WHERE tai.trx_status_code = 'PROCESSED'
4619: AND tai.khr_id = cp_khr_id

Line 4636: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'

4632: AND tld.til_id_details = til.id
4633: AND til.tai_id = tai.id
4634: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4635: WHERE vpb.khr_id = tld.khr_id
4636: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
4637: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4638: AND vpb.source_id = raa.receivable_application_id)
4639: AND EXISTS (SELECT 1
4640: FROM ar_distributions_all ad

Line 4950: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table

4946: --Bug# 7007130: Fetch unique receipt application ids for
4947: -- a contract
4948: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4949: SELECT DISTINCT raa.receivable_application_id source_id
4950: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
4951: FROM okl_txd_ar_ln_dtls_b tld
4952: ,ra_customer_trx_lines_all ractrl
4953: ,okl_txl_ar_inv_lns_b til
4954: ,okl_trx_ar_invoices_b tai

Line 4956: ,ar_receivable_applications_all raa

4952: ,ra_customer_trx_lines_all ractrl
4953: ,okl_txl_ar_inv_lns_b til
4954: ,okl_trx_ar_invoices_b tai
4955: ,ar_payment_schedules_all aps
4956: ,ar_receivable_applications_all raa
4957: ,ar_cash_receipts_all cra
4958: ,okl_strm_type_b sty
4959: WHERE tai.trx_status_code = 'PROCESSED'
4960: AND tai.khr_id = cp_khr_id

Line 4977: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'

4973: AND tld.til_id_details = til.id
4974: AND til.tai_id = tai.id
4975: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4976: WHERE vpb.khr_id = tld.khr_id
4977: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
4978: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4979: AND vpb.source_id = raa.receivable_application_id)
4980: AND EXISTS (SELECT 1
4981: FROM ar_distributions_all ad

Line 5034: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table

5030: --Bug# 14179413: Include Credit Memos and Adjustments when calculating
5031: -- Actual Principal Balance
5032: CURSOR l_credit_memo_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
5033: SELECT DISTINCT raa.receivable_application_id source_id
5034: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
5035: FROM okl_txd_ar_ln_dtls_b tld
5036: ,ra_customer_trx_lines_all ractrl
5037: ,okl_txl_ar_inv_lns_b til
5038: ,okl_trx_ar_invoices_b tai

Line 5040: ,ar_receivable_applications_all raa

5036: ,ra_customer_trx_lines_all ractrl
5037: ,okl_txl_ar_inv_lns_b til
5038: ,okl_trx_ar_invoices_b tai
5039: ,ar_payment_schedules_all aps
5040: ,ar_receivable_applications_all raa
5041: ,ra_customer_trx_all cm
5042: ,okl_strm_type_b sty
5043: WHERE tai.trx_status_code = 'PROCESSED'
5044: AND tai.khr_id = cp_khr_id

Line 5061: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'

5057: AND tld.til_id_details = til.id
5058: AND til.tai_id = tai.id
5059: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
5060: WHERE vpb.khr_id = tld.khr_id
5061: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
5062: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
5063: AND vpb.source_id = raa.receivable_application_id)
5064: AND EXISTS (SELECT 1
5065: FROM ar_distributions_all ad