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.AR_UNPOSTED_ITEM_UPG dependencies on AR_SYSTEM_PARAMETERS

Line 9: x_accounting_method IN OUT NOCOPY ar_system_parameters.accounting_method%TYPE)

5:
6: PROCEDURE Init_Curr_Details
7: (p_sob_id IN NUMBER,
8: p_org_id IN NUMBER,
9: x_accounting_method IN OUT NOCOPY ar_system_parameters.accounting_method%TYPE)
10: IS
11: BEGIN
12: SELECT sob.set_of_books_id,
13: sob.chart_of_accounts_id,

Line 30: FROM ar_system_parameters_all sysp,

26: g_ae_sys_rec.gain_cc_id,
27: g_ae_sys_rec.loss_cc_id,
28: g_ae_sys_rec.round_cc_id,
29: x_accounting_method
30: FROM ar_system_parameters_all sysp,
31: gl_sets_of_books sob,
32: fnd_currencies c
33: WHERE sysp.org_id = p_org_id
34: AND sob.set_of_books_id = sysp.set_of_books_id --would be the row returned from multi org view

Line 70: ar_system_parameters_all ars

66: p_end_rowid IN ROWID)
67: IS
68: SELECT app.*
69: FROM ar_receivable_applications_all app,
70: ar_system_parameters_all ars
71: WHERE app.status = 'APP'
72: AND app.upgrade_method IS NULL
73: AND app.org_id = ars.org_id
74: AND app.posting_control_id = -3

Line 335: ar_system_parameters_all ars,

331: AND rowid >= l_start_rowid
332: AND rowid <= l_end_rowid
333: GROUP BY applied_customer_trx_id,
334: org_id ) app,
335: ar_system_parameters_all ars,
336: ra_customer_trx_all trx,
337: ra_customer_trx_lines_all ctl,
338: ra_cust_trx_line_gl_dist_all ctlgd
339: WHERE ars.accounting_method = 'CASH'

Line 613: ar_system_parameters_all ars,

609: , NULL -- tax_inc_flag
610: , ard.line_id -- ref_line_id
611: FROM ar_adjustments_all adj,
612: ar_distributions_all ard,
613: ar_system_parameters_all ars,
614: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
615: MAX(to_currency) invoice_currency_code
616: FROM ra_ar_gt
617: GROUP BY ref_customer_trx_id, to_currency) trx

Line 847: ar_system_parameters_all ars

843: p_end_rowid IN ROWID)
844: IS
845: SELECT app.*
846: FROM ar_receivable_applications_all app,
847: ar_system_parameters_all ars
848: WHERE app.status = 'APP'
849: AND app.upgrade_method = 'R12_11ICASH_POST'
850: AND app.org_id = ars.org_id
851: AND app.posting_control_id = -3

Line 1116: ar_system_parameters_all ars,

1112: AND rowid >= l_start_rowid
1113: AND rowid <= l_end_rowid
1114: GROUP BY customer_trx_id,
1115: org_id ) app,
1116: ar_system_parameters_all ars,
1117: ra_customer_trx_all trx,
1118: ra_customer_trx_lines_all ctl,
1119: ra_cust_trx_line_gl_dist_all ctlgd
1120: WHERE ars.accounting_method = 'CASH'