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 XLA_EVENTS_GT

Line 125: FROM xla_events_gt evt,

121: UPDATE ar_receivable_applications_all ra
122: SET ra.upgrade_method = 'R12_11ICASH_POST'
123: WHERE ra.receivable_application_id IN (
124: SELECT app.receivable_application_id
125: FROM xla_events_gt evt,
126: ar_receivable_applications_all app
127: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
128: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
129: 'CM_CREATE' ,'CM_UPDATE')

Line 642: FROM xla_events_gt evt,

638: , 'P' -- sob_type
639: , USERENV('SESSIONID') -- se_gt_id
640: , NULL -- tax_link_id
641: , NULL -- tax_inc_flag
642: FROM xla_events_gt evt,
643: ar_receivable_applications_all app,
644: ar_system_parameters_all ars,
645: ra_customer_trx_all trx,
646: ra_customer_trx_lines_all ctl,

Line 674: FROM xla_events_gt evt,

670: FROM ( -- Applied to transactions
671: SELECT DISTINCT inv.customer_trx_id,
672: inv.invoice_currency_code,
673: inv.set_of_books_id
674: FROM xla_events_gt evt,
675: ar_receivable_applications_all app,
676: ra_customer_trx_all inv,
677: ar_system_parameters_all ars
678: WHERE evt.event_type_code

Line 695: FROM xla_events_gt evt,

691: -- From CM in the case of CM APP
692: SELECT DISTINCT inv.customer_trx_id,
693: inv.invoice_currency_code,
694: inv.set_of_books_id
695: FROM xla_events_gt evt,
696: ar_receivable_applications_all app,
697: ra_customer_trx_all inv,
698: ar_system_parameters_all ars
699: WHERE evt.event_type_code

Line 918: FROM xla_events_gt evt,

914: FROM ( -- Applied to transactions
915: SELECT DISTINCT inv.customer_trx_id,
916: inv.invoice_currency_code,
917: inv.set_of_books_id
918: FROM xla_events_gt evt,
919: ar_receivable_applications_all app,
920: ra_customer_trx_all inv,
921: psa_trx_types_all psa
922: WHERE evt.event_type_code

Line 935: FROM xla_events_gt evt,

931: -- From CM in the case of CM APP
932: SELECT DISTINCT inv.customer_trx_id,
933: inv.invoice_currency_code,
934: inv.set_of_books_id
935: FROM xla_events_gt evt,
936: ar_receivable_applications_all app,
937: ra_customer_trx_all inv,
938: psa_trx_types_all psa
939: WHERE evt.event_type_code

Line 2371: FROM xla_events_gt evt,

2367: RETURN VARCHAR2
2368: IS
2369: CURSOR c1 IS
2370: SELECT app.receivable_application_id
2371: FROM xla_events_gt evt,
2372: ar_receivable_applications_all app
2373: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
2374: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
2375: 'CM_CREATE' ,'CM_UPDATE')

Line 2388: FROM xla_events_gt evt,

2384: AND adj.postable = 'Y')
2385: MINUS -- This is to avoid corrupted data. In the case the same invoice has MF and none MF adjustment
2386: -- theorically impossible
2387: SELECT app.receivable_application_id
2388: FROM xla_events_gt evt,
2389: ar_receivable_applications_all app
2390: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
2391: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
2392: 'CM_CREATE' ,'CM_UPDATE')

Line 2424: FROM xla_events_gt evt,

2420: RETURN VARCHAR2
2421: IS
2422: CURSOR c1 IS
2423: SELECT app.receivable_application_id
2424: FROM xla_events_gt evt,
2425: ar_receivable_applications_all app,
2426: ar_system_parameters_all ars
2427: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
2428: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,

Line 2495: FROM xla_events_gt evt,

2491: l_gt_id NUMBER := 0;
2492:
2493: CURSOR c_app IS
2494: SELECT app.*
2495: FROM xla_events_gt evt,
2496: ar_receivable_applications_all app,
2497: ar_system_parameters_all ars
2498: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2499: 'RECP_RATE_ADJUST' ,'RECP_REVERSE',

Line 2518: FROM xla_events_gt evt,

2514: -- and in cash basis we only need to post applications
2515: -- which is on the to document
2516: CURSOR c_cm_from_app IS
2517: SELECT app.*
2518: FROM xla_events_gt evt,
2519: ar_receivable_applications_all app,
2520: ar_system_parameters_all ars
2521: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2522: AND evt.event_id = app.event_id

Line 2649: FROM xla_events_gt evt,

2645: l_gt_id NUMBER := 0;
2646:
2647: CURSOR c_app IS
2648: SELECT app.*
2649: FROM xla_events_gt evt,
2650: ar_receivable_applications_all app
2651: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2652: 'RECP_RATE_ADJUST' ,'RECP_REVERSE',
2653: 'CM_CREATE' ,'CM_UPDATE' )

Line 2664: FROM xla_events_gt evt,

2660: AND adj.status = 'A'
2661: AND adj.postable = 'Y')
2662: MINUS
2663: SELECT app.*
2664: FROM xla_events_gt evt,
2665: ar_receivable_applications_all app
2666: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2667: 'RECP_RATE_ADJUST' ,'RECP_REVERSE',
2668: 'CM_CREATE' ,'CM_UPDATE' )

Line 2681: FROM xla_events_gt evt,

2677:
2678:
2679: CURSOR c_cm_from_app IS
2680: SELECT app.*
2681: FROM xla_events_gt evt,
2682: ar_receivable_applications_all app
2683: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2684: AND evt.event_id = app.event_id
2685: AND app.status = 'APP'

Line 2694: FROM xla_events_gt evt,

2690: AND adj.status = 'A'
2691: AND adj.postable = 'Y')
2692: MINUS
2693: SELECT app.*
2694: FROM xla_events_gt evt,
2695: ar_receivable_applications_all app
2696: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2697: AND evt.event_id = app.event_id
2698: AND app.status = 'APP'

Line 3121: FROM xla_events_gt evt,

3117: UPDATE ar_receivable_applications_all ra
3118: SET ra.upgrade_method = 'R12_11IMFAR_POST'
3119: WHERE ra.receivable_application_id IN (
3120: SELECT app.receivable_application_id
3121: FROM xla_events_gt evt,
3122: ar_receivable_applications_all app
3123: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
3124: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
3125: 'CM_CREATE' ,'CM_UPDATE')

Line 3137: FROM xla_events_gt evt,

3133: AND adj.status = 'A'
3134: AND adj.postable = 'Y')
3135: MINUS
3136: SELECT app.receivable_application_id
3137: FROM xla_events_gt evt,
3138: ar_receivable_applications_all app
3139: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
3140: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
3141: 'CM_CREATE' ,'CM_UPDATE')

Line 3169: FROM xla_events_gt evt,

3165: UPDATE ar_receivable_applications_all ra
3166: SET ra.upgrade_method = 'R12_11ICASH_POST'
3167: WHERE ra.receivable_application_id IN (
3168: SELECT app.receivable_application_id
3169: FROM xla_events_gt evt,
3170: ar_receivable_applications_all app
3171: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3172: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
3173: 'CM_CREATE' ,'CM_UPDATE')