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

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

74:
75: PROCEDURE Init_Curr_Details
76: (p_sob_id IN NUMBER,
77: p_org_id IN NUMBER,
78: x_accounting_method IN OUT NOCOPY ar_system_parameters.accounting_method%TYPE)
79: IS
80: BEGIN
81: log('Init_Curr_Details +');
82: SELECT sob.set_of_books_id,

Line 100: FROM ar_system_parameters_all sysp,

96: g_ae_sys_rec.gain_cc_id,
97: g_ae_sys_rec.loss_cc_id,
98: g_ae_sys_rec.round_cc_id,
99: x_accounting_method
100: FROM ar_system_parameters_all sysp,
101: gl_sets_of_books sob,
102: fnd_currencies c
103: WHERE sysp.org_id = p_org_id
104: AND sob.set_of_books_id = sysp.set_of_books_id --would be the row returned from multi org view

Line 664: ar_system_parameters_all ars,

660: , DECODE(ctl.line_type,'LINE',taxx.vat_tax_id,ctl.vat_tax_id) vat_tax_id
661: , DECODE(ctl.line_type,'LINE',taxx.location_segment_id,ctl.location_segment_id)
662: FROM xla_events_gt evt,
663: ar_receivable_applications_all app,
664: ar_system_parameters_all ars,
665: ra_customer_trx_all trx,
666: ra_customer_trx_lines_all ctl,
667: ra_cust_trx_line_gl_dist_all ctlgd,
668: ( select ctl_tax.*

Line 703: ar_system_parameters_all ars

699: inv.set_of_books_id
700: FROM xla_events_gt evt,
701: ar_receivable_applications_all app,
702: ra_customer_trx_all inv,
703: ar_system_parameters_all ars
704: WHERE evt.event_type_code
705: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
706: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
707: 'CM_CREATE' ,'CM_UPDATE' )

Line 724: ar_system_parameters_all ars

720: inv.set_of_books_id
721: FROM xla_events_gt evt,
722: ar_receivable_applications_all app,
723: ra_customer_trx_all inv,
724: ar_system_parameters_all ars
725: WHERE evt.event_type_code
726: IN ( 'CM_CREATE' ,'CM_UPDATE' )
727: AND evt.event_id = app.event_id
728: AND app.customer_trx_id = inv.customer_trx_id

Line 1712: ar_system_parameters_all ars,

1708: , ard.tax_code_id
1709: , ard.location_segment_id
1710: FROM ar_adjustments_all adj,
1711: ar_distributions_all ard,
1712: ar_system_parameters_all ars,
1713: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1714: MAX(to_currency) invoice_currency_code
1715: FROM ra_ar_gt
1716: GROUP BY ref_customer_trx_id, to_currency) trx

Line 2177: ar_system_parameters_all ars,

2173: , NULL -- tax_link_id
2174: , NULL -- tax_inc_flag
2175: , NULL -- ref_line_id
2176: FROM ar_adjustments_all adj,
2177: ar_system_parameters_all ars,
2178: -- For performance this sql is not nec as for legacy data
2179: -- we are proposing no tied by to original line
2180: -- in new transaction the ref_line_id will be present
2181: -- (SELECT MAX(line_id) line_id,

Line 2401: ar_system_parameters_all ars,

2397: , NULL -- tax_link_id
2398: , NULL -- tax_inc_flag
2399: , NULL -- ref_line_id
2400: FROM ar_adjustments adj,
2401: ar_system_parameters_all ars,
2402: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
2403: MAX(to_currency) invoice_currency_code
2404: FROM ra_ar_gt
2405: WHERE gt_id = p_gt_id

Line 2645: ar_system_parameters_all ars

2641: CURSOR c1 IS
2642: SELECT app.receivable_application_id
2643: FROM xla_events_gt evt,
2644: ar_receivable_applications_all app,
2645: ar_system_parameters_all ars
2646: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
2647: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
2648: 'CM_CREATE' ,'CM_UPDATE')
2649: AND evt.event_id = app.event_id

Line 2708: l_accounting_method ar_system_parameters.accounting_method%TYPE;

2704:
2705: PROCEDURE create_cash_distributions
2706: IS
2707: l_sob_id NUMBER;
2708: l_accounting_method ar_system_parameters.accounting_method%TYPE;
2709: l_create_acct VARCHAR2(1) := 'Y';
2710: l_gt_id NUMBER := 0;
2711:
2712: CURSOR c_app IS

Line 2716: ar_system_parameters_all ars

2712: CURSOR c_app IS
2713: SELECT app.*
2714: FROM xla_events_gt evt,
2715: ar_receivable_applications_all app,
2716: ar_system_parameters_all ars
2717: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2718: 'RECP_RATE_ADJUST' ,'RECP_REVERSE',
2719: 'CM_CREATE' ,'CM_UPDATE' )
2720: AND evt.event_id = app.event_id

Line 2739: ar_system_parameters_all ars

2735: CURSOR c_cm_from_app IS
2736: SELECT app.*
2737: FROM xla_events_gt evt,
2738: ar_receivable_applications_all app,
2739: ar_system_parameters_all ars
2740: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2741: AND evt.event_id = app.event_id
2742: AND app.status = 'APP'
2743: AND app.upgrade_method IS NULL

Line 2862: l_accounting_method ar_system_parameters.accounting_method%TYPE;

2858: /*
2859: PROCEDURE create_mfar_distributions
2860: IS
2861: l_sob_id NUMBER;
2862: l_accounting_method ar_system_parameters.accounting_method%TYPE;
2863: l_create_acct VARCHAR2(1) := 'Y';
2864: l_gt_id NUMBER := 0;
2865:
2866: CURSOR c_app IS