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_OPI_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 1144: FROM okl_cnsld_ar_strms_b ocas

1140: l_interest_type NUMBER;
1141:
1142: CURSOR l_khr_past_due_csr(cp_contract_id IN NUMBER) IS
1143: SELECT sum(nvl(aps.amount_due_remaining, 0)) past_due_amount
1144: FROM okl_cnsld_ar_strms_b ocas
1145: ,ar_payment_schedules_all aps
1146: WHERE ocas.khr_id = cp_contract_id
1147: AND ocas.receivables_invoice_id = aps.customer_trx_id
1148: AND aps.class = 'INV'

Line 1154: FROM okl_cnsld_ar_strms_b ocas

1150: AND nvl(aps.amount_due_remaining, 0) > 0;
1151:
1152: CURSOR l_khr_due_date(cp_contract_id IN NUMBER) IS
1153: SELECT min(aps.due_date) due_date
1154: FROM okl_cnsld_ar_strms_b ocas
1155: ,ar_payment_schedules_all aps
1156: WHERE ocas.khr_id = cp_contract_id
1157: AND ocas.receivables_invoice_id = aps.customer_trx_id
1158: AND aps.class = 'INV'

Line 1164: FROM okl_cnsld_ar_strms_b ocas

1160: AND nvl(aps.amount_due_remaining, 0) > 0;
1161:
1162: CURSOR l_khr_last_pymt_date(cp_contract_id IN NUMBER) IS
1163: SELECT min(ara.apply_date) apply_date
1164: FROM okl_cnsld_ar_strms_b ocas
1165: ,ar_payment_schedules_all aps
1166: ,ar_receivable_applications_all ara
1167: WHERE ocas.khr_id = cp_contract_id
1168: AND ocas.receivables_invoice_id = aps.customer_trx_id