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 AR_PAYMENT_SCHEDULES_ALL

Line 1145: ,ar_payment_schedules_all aps

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'
1149: AND aps.due_date < sysdate

Line 1155: ,ar_payment_schedules_all aps

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'
1159: AND aps.due_date < sysdate

Line 1165: ,ar_payment_schedules_all aps

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
1169: AND aps.class = 'INV'