APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_ADJUSTMENTS_ALL

Line 1777: ar_adjustments_all adj,

1773: ra_customer_trx_lines_all ractrl,
1774: okl_txl_ar_inv_lns_b til,
1775: okl_trx_ar_invoices_b tai,
1776: ar_payment_schedules_all aps,
1777: ar_adjustments_all adj,
1778: okl_strm_type_b sty,
1779: ar_distributions_all ad
1780: WHERE tai.trx_status_code = 'PROCESSED'
1781: AND tai.khr_id = p_contract_id

Line 2376: ar_adjustments_all adj,

2372: sum( -1 * NVL(adj.amount,0)) txn_amount,
2373: 'R' txn_type
2374: FROM okl_bpd_tld_ar_lines_v tld,
2375: ar_payment_schedules_all aps,
2376: ar_adjustments_all adj,
2377: okl_strm_type_v sty
2378: WHERE tld.trx_status_code = 'PROCESSED'
2379: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)
2380: AND tld.customer_trx_id = aps.customer_trx_id

Line 4656: ,ar_adjustments_all adj

4652: ,ra_customer_trx_lines_all ractrl
4653: ,okl_txl_ar_inv_lns_b til
4654: ,okl_trx_ar_invoices_b tai
4655: ,ar_payment_schedules_all aps
4656: ,ar_adjustments_all adj
4657: ,okl_strm_type_b sty
4658: WHERE tai.trx_status_code = 'PROCESSED'
4659: AND tai.khr_id = cp_khr_id
4660: AND tld.khr_id = cp_khr_id

Line 4673: AND vpb.source_table = 'AR_ADJUSTMENTS_ALL'

4669: AND tld.til_id_details = til.id
4670: AND til.tai_id = tai.id
4671: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4672: WHERE vpb.khr_id = tld.khr_id
4673: AND vpb.source_table = 'AR_ADJUSTMENTS_ALL'
4674: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4675: AND vpb.source_id = adj.adjustment_id);
4676:
4677: BEGIN

Line 5075: , 'AR_ADJUSTMENTS_ALL' source_table

5071: --Bug# 14179413: Include Credit Memos and Adjustments when calculating
5072: -- Actual Principal Balance
5073: CURSOR l_adjustment_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
5074: SELECT DISTINCT adj.adjustment_id source_id
5075: , 'AR_ADJUSTMENTS_ALL' source_table
5076: FROM okl_txd_ar_ln_dtls_b tld
5077: ,ra_customer_trx_lines_all ractrl
5078: ,okl_txl_ar_inv_lns_b til
5079: ,okl_trx_ar_invoices_b tai

Line 5081: ,ar_adjustments_all adj

5077: ,ra_customer_trx_lines_all ractrl
5078: ,okl_txl_ar_inv_lns_b til
5079: ,okl_trx_ar_invoices_b tai
5080: ,ar_payment_schedules_all aps
5081: ,ar_adjustments_all adj
5082: ,okl_strm_type_b sty
5083: WHERE tai.trx_status_code = 'PROCESSED'
5084: AND tai.khr_id = cp_khr_id
5085: AND tld.khr_id = cp_khr_id

Line 5098: AND vpb.source_table = 'AR_ADJUSTMENTS_ALL'

5094: AND tld.til_id_details = til.id
5095: AND til.tai_id = tai.id
5096: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
5097: WHERE vpb.khr_id = tld.khr_id
5098: AND vpb.source_table = 'AR_ADJUSTMENTS_ALL'
5099: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
5100: AND vpb.source_id = adj.adjustment_id);
5101:
5102: BEGIN