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 1252: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC,

1248:
1249: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1250: Cursor Principal_Paid_Cur (p_chr_id IN NUMBER, p_date IN DATE) IS
1251: SELECT NVL(SUM(AR_REC.AMOUNT_APPLIED),0) AMOUNT
1252: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC,
1253: AR_PAYMENT_SCHEDULES_ALL AR_PAY,
1254: okl_bpd_tld_ar_lines_v TLD,
1255: OKL_STRM_TYPE_B STRM
1256: WHERE AR_REC.APPLY_DATE <= p_date -- TO BE REPLACED WITH APPLY DATE

Line 3543: ,ar_receivable_applications_all raa

3539: okl_cnsld_ar_strms_b lsm
3540: ,okl_cnsld_ar_lines_b lln
3541: ,okl_cnsld_ar_hdrs_b cnr
3542: ,ar_payment_schedules_all aps
3543: ,ar_receivable_applications_all raa
3544: ,ar_cash_receipts_all cra
3545: ,okl_strm_type_v sty
3546: WHERE lsm.receivables_invoice_id > 0
3547: AND lsm.lln_id = lln.id

Line 3579: ar_receivable_applications_all raa,

3575: okl_cnsld_ar_strms_b lsm,
3576: okl_cnsld_ar_lines_b lln,
3577: okl_cnsld_ar_hdrs_b cnr,
3578: ar_payment_schedules_all aps,
3579: ar_receivable_applications_all raa,
3580: ar_cash_receipts_all cra,
3581: okl_strm_type_v sty_ln_pmt,
3582: okl_strm_elements_v sel_ln_pmt
3583: WHERE lsm.receivables_invoice_id > 0

Line 3916: ar_receivable_applications_all raa,

3912: FROM okl_cnsld_ar_strms_b lsm,
3913: okl_cnsld_ar_lines_b lln,
3914: okl_cnsld_ar_hdrs_b cnr,
3915: ar_payment_schedules_all aps,
3916: ar_receivable_applications_all raa,
3917: ar_cash_receipts_all cra,
3918: okl_strm_type_v sty
3919: WHERE lsm.receivables_invoice_id > 0
3920: AND lsm.lln_id = lln.id

Line 3967: ar_receivable_applications_all raa,

3963: FROM okl_cnsld_ar_strms_b lsm,
3964: okl_cnsld_ar_lines_b lln,
3965: okl_cnsld_ar_hdrs_b cnr,
3966: ar_payment_schedules_all aps,
3967: ar_receivable_applications_all raa,
3968: ar_cash_receipts_all cra,
3969: okl_strm_type_v sty
3970: WHERE lsm.receivables_invoice_id > 0
3971: AND lsm.lln_id = lln.id

Line 4283: ar_receivable_applications_all raa,

4279: ra_customer_trx_lines_all ractrl,
4280: okl_txl_ar_inv_lns_b til,
4281: okl_trx_ar_invoices_b tai,
4282: ar_payment_schedules_all aps,
4283: ar_receivable_applications_all raa,
4284: ar_cash_receipts_all cra,
4285: okl_strm_type_b sty,
4286: ar_distributions_all ad
4287: WHERE tai.trx_status_code = 'PROCESSED'

Line 4314: ar_receivable_applications_all raa,

4310: ra_customer_trx_lines_all ractrl,
4311: okl_txl_ar_inv_lns_b til,
4312: okl_trx_ar_invoices_b tai,
4313: ar_payment_schedules_all aps,
4314: ar_receivable_applications_all raa,
4315: ar_cash_receipts_all cra,
4316: okl_strm_type_b sty
4317: WHERE tai.trx_status_code = 'PROCESSED'
4318: AND tai.khr_id = p_contract_id

Line 4890: ar_receivable_applications_all raa,

4886: sum(raa.line_applied) txn_amount, -- 4884843, 4872370
4887: 'R' txn_type
4888: FROM okl_bpd_tld_ar_lines_v tld,
4889: ar_payment_schedules_all aps,
4890: ar_receivable_applications_all raa,
4891: ar_cash_receipts_all cra,
4892: okl_strm_type_v sty
4893: WHERE tld.trx_status_code = 'PROCESSED'
4894: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)

Line 7842: ,ar_receivable_applications_all raa

7838: ,ra_customer_trx_lines_all ractrl
7839: ,okl_txl_ar_inv_lns_b til
7840: ,okl_trx_ar_invoices_b tai
7841: ,ar_payment_schedules_all aps
7842: ,ar_receivable_applications_all raa
7843: ,ar_cash_receipts_all cra
7844: ,okl_strm_type_b sty
7845: WHERE tai.trx_status_code = 'PROCESSED'
7846: AND tai.khr_id = cp_khr_id

Line 7862: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'

7858: AND tld.til_id_details = til.id
7859: AND til.tai_id = tai.id
7860: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7861: WHERE vpb.khr_id = tld.khr_id
7862: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
7863: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7864: AND vpb.source_id = raa.receivable_application_id)
7865: AND EXISTS (SELECT 1
7866: FROM ar_distributions_all ad

Line 8129: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table

8125: --Bug# 7007130: Fetch unique receipt application ids for
8126: -- a contract
8127: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8128: SELECT DISTINCT raa.receivable_application_id source_id
8129: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
8130: FROM okl_txd_ar_ln_dtls_b tld
8131: ,ra_customer_trx_lines_all ractrl
8132: ,okl_txl_ar_inv_lns_b til
8133: ,okl_trx_ar_invoices_b tai

Line 8135: ,ar_receivable_applications_all raa

8131: ,ra_customer_trx_lines_all ractrl
8132: ,okl_txl_ar_inv_lns_b til
8133: ,okl_trx_ar_invoices_b tai
8134: ,ar_payment_schedules_all aps
8135: ,ar_receivable_applications_all raa
8136: ,ar_cash_receipts_all cra
8137: ,okl_strm_type_b sty
8138: WHERE tai.trx_status_code = 'PROCESSED'
8139: AND tai.khr_id = cp_khr_id

Line 8155: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'

8151: AND tld.til_id_details = til.id
8152: AND til.tai_id = tai.id
8153: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8154: WHERE vpb.khr_id = tld.khr_id
8155: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
8156: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8157: AND vpb.source_id = raa.receivable_application_id)
8158: AND EXISTS (SELECT 1
8159: FROM ar_distributions_all ad