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_BPD_ADV_MON_RPT_PVT dependencies on OKL_RECEIPT_APPLICATIONS_UV

Line 56: FROM okl_receipt_applications_uv

52: c.Contract_Number Contract_number ,
53: a.invoice_number invoice_number,
54: d.trx_date trx_date,
55: ( SELECT NVL(SUM(a.line_applied + a.tax_applied), 0)
56: FROM okl_receipt_applications_uv
57: WHERE cash_receipt_id = a.cash_receipt_id) amount_applied
58: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,
59: ar_payment_schedules_all d, okl_trx_csh_receipt_b e, okx_customer_accounts_v f,
60: ar_receivable_applications_all g

Line 58: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,

54: d.trx_date trx_date,
55: ( SELECT NVL(SUM(a.line_applied + a.tax_applied), 0)
56: FROM okl_receipt_applications_uv
57: WHERE cash_receipt_id = a.cash_receipt_id) amount_applied
58: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,
59: ar_payment_schedules_all d, okl_trx_csh_receipt_b e, okx_customer_accounts_v f,
60: ar_receivable_applications_all g
61: WHERE a.cash_receipt_id = b.cash_receipt_id
62: AND b.cash_receipt_id = e.cash_receipt_id

Line 108: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,

104: FROM AR_RECEIVABLE_APPLICATIONS_ALL
105: WHERE status = 'ACC'
106: AND cash_Receipt_id = a.cash_receipt_id) Amount,
107: c.Contract_Number Contract_number
108: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,
109: okl_trx_csh_receipt_b e, okx_customer_accounts_v f
110: WHERE a.cash_receipt_id = b.cash_receipt_id
111: AND b.cash_receipt_id = e.cash_receipt_id
112: AND b.pay_from_customer = f.ID1