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_ADJ dependencies on AR_SYSTEM_PARAMETERS

Line 172: from ar_system_parameters_all

168: elsif p_reporting_level = 3000 then
169:
170: select set_of_books_id
171: into var.books_id
172: from ar_system_parameters_all
173: where org_id = p_reporting_entity;
174:
175: mo_global.init('AR');
176: mo_global.set_policy_context('S',p_reporting_entity);

Line 291: --FROM ar_system_parameters;

287: --bug fix 5595083
288: --Changing the logic of getting the accounting_method. The accounting_method should belong to the ledger for which the report is being generated.
289: --SELECT distinct ACCOUNTING_METHOD
290: --INTO ACCOUNTING_METHOD
291: --FROM ar_system_parameters;
292:
293: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
294:
295: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);

Line 302: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;

298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
299:
300: --Bug fix 5595083 starts
301: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
302: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;
303: IF var.p_reporting_level = 3000 then
304: Select decode(nvl(sla_ledger_cash_basis_flag, 'N'),'N', 'ACCRUAL', 'CASH')
305: into ACCOUNTING_METHOD
306: from gl_ledgers