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 1680: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;

1676: l_currency_code ar_cash_receipts.currency_code%TYPE:= p_rcpt_rec.currency_code;
1677: l_customer_number hz_cust_accounts.account_number%TYPE:=p_rcpt_rec.customer_number;
1678: l_org_id NUMBER:= p_rcpt_rec.org_id;
1679: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1680: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1681: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1682: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1683:
1684:

Line 1734: FROM okl_cnsld_ar_hdrs_all_b

1730: CURSOR c_cons_inv_num( cp_con_inv_id IN NUMBER
1731: ,cp_org_id IN NUMBER
1732: ) IS
1733: SELECT consolidated_invoice_number
1734: FROM okl_cnsld_ar_hdrs_all_b
1735: WHERE id = cp_con_inv_id
1736: AND org_id = cp_org_id;
1737:
1738: CURSOR c_ar_inv_num( cp_ar_inv_id IN NUMBER