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_RECEIPTS_PVT dependencies on OKL_CNSLD_AR_HDRS_ALL_B

Line 1623: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;

1619: l_currency_code ar_cash_receipts.currency_code%TYPE:= p_rcpt_rec.currency_code;
1620: l_customer_number hz_cust_accounts.account_number%TYPE:=p_rcpt_rec.customer_number;
1621: l_org_id NUMBER:= p_rcpt_rec.org_id;
1622: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1623: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1624: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1625: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1626:
1627:

Line 1677: FROM okl_cnsld_ar_hdrs_all_b

1673: CURSOR c_cons_inv_num( cp_con_inv_id IN NUMBER
1674: ,cp_org_id IN NUMBER
1675: ) IS
1676: SELECT consolidated_invoice_number
1677: FROM okl_cnsld_ar_hdrs_all_b
1678: WHERE id = cp_con_inv_id
1679: AND org_id = cp_org_id;
1680:
1681: CURSOR c_ar_inv_num( cp_ar_inv_id IN NUMBER