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_LOSS_PROV_PVT dependencies on OKL_BPD_CONTRACT_INVOICES_V

Line 1202: -- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.

1198:
1199: -- cursor for retrieving the unpaid invoices for a contract
1200: --Bug 2969989. Not all outstanding invoices need to be considered.Consider
1201: --only those less than or equal to provision date.
1202: -- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.
1203: -- Also adding new where condition to exclude invoices subject to cash receipt.
1204: CURSOR cntrct_invcs_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_entry_date DATE) IS
1205: SELECT amount_due_remaining, due_date
1206: FROM okl_bpd_contract_invoices_v

Line 1206: FROM okl_bpd_contract_invoices_v

1202: -- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.
1203: -- Also adding new where condition to exclude invoices subject to cash receipt.
1204: CURSOR cntrct_invcs_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_entry_date DATE) IS
1205: SELECT amount_due_remaining, due_date
1206: FROM okl_bpd_contract_invoices_v
1207: WHERE contract_id = p_khr_id
1208: AND status = 'OP'
1209: AND amount_due_remaining > 0
1210: AND revenue_rec_basis <> 'CASH_RECEIPT'

Line 1237: -- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.

1233:
1234:
1235: -- GSCC validation error. Removing hardcoded schema name APPS
1236: -- cursor to select open items for a contract
1237: -- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.
1238: -- Also adding new where condition to exclude invoices subject to cash receipt.
1239: CURSOR open_items_csr (p_khr_id NUMBER, p_sty_id NUMBER) IS
1240: SELECT amount_due_remaining, due_date
1241: FROM okl_bpd_contract_invoices_v

Line 1241: FROM okl_bpd_contract_invoices_v

1237: -- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.
1238: -- Also adding new where condition to exclude invoices subject to cash receipt.
1239: CURSOR open_items_csr (p_khr_id NUMBER, p_sty_id NUMBER) IS
1240: SELECT amount_due_remaining, due_date
1241: FROM okl_bpd_contract_invoices_v
1242: WHERE contract_id = p_khr_id
1243: AND status = 'OP'
1244: AND amount_due_remaining > 0
1245: AND revenue_rec_basis <> 'CASH_RECEIPT'