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.ARRX_BRS dependencies on GL_SETS_OF_BOOKS

Line 66: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

62: l_org_where_rab VARCHAR2(2000);
63: l_org_where_arb VARCHAR2(2000);
64: l_org_where_app VARCHAR2(2000);
65: l_org_where_cr VARCHAR2(2000);
66: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
67: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
68: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
69: l_populate VARCHAR2(1);
70: l_populate_amt VARCHAR2(1) := 'Y';

Line 67: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;

63: l_org_where_arb VARCHAR2(2000);
64: l_org_where_app VARCHAR2(2000);
65: l_org_where_cr VARCHAR2(2000);
66: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
67: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
68: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
69: l_populate VARCHAR2(1);
70: l_populate_amt VARCHAR2(1) := 'Y';
71: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 68: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;

64: l_org_where_app VARCHAR2(2000);
65: l_org_where_cr VARCHAR2(2000);
66: l_books_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
67: l_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
68: l_sob_name GL_SETS_OF_BOOKS.name%TYPE;
69: l_populate VARCHAR2(1);
70: l_populate_amt VARCHAR2(1) := 'Y';
71: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
72: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;

Line 231: FROM gl_sets_of_books

227: SELECT currency_code,
228: name
229: INTO l_currency_code,
230: l_sob_name
231: FROM gl_sets_of_books
232: WHERE set_of_books_id = l_books_id;
233:
234: -- As of Date cursor
235: l_as_of_date := 'SELECT arl.meaning,