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_COMBI_CASH_APP_RLS_PVT dependencies on OKL_RCPT_CONSINV_BALANCES_UV

Line 78: FROM okl_rcpt_consinv_balances_uv

74:
75: -- get unique cons bill numbers
76: CURSOR c_get_cons_invs(cp_cust_num IN VARCHAR2,cp_org_id IN NUMBER) IS
77: SELECT distinct(consolidated_invoice_number), due_date
78: FROM okl_rcpt_consinv_balances_uv
79: WHERE customer_number = cp_cust_num
80: AND org_id= cp_org_id
81: ORDER BY due_date;
82:

Line 373: FROM okl_rcpt_consinv_balances_uv lpt

369: AR_INVOICE_LINE_ID INVOICE_LINE_ID,
370: LINE_NUMBER,
371: AMOUNT_DUE_REMAINING,
372: CURRENCY_CODE
373: FROM okl_rcpt_consinv_balances_uv lpt
374: WHERE lpt.consolidated_invoice_number = cp_cons_bill_num
375: AND lpt.customer_number = NVL (cp_customer_num, lpt.customer_number)
376: AND lpt.stream_type_id = NVL (cp_stream_type_id, lpt.stream_type_id)
377: AND lpt.amount_due_remaining > 0