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_RECEIVABLE_APPLICATIONS_ALL

Line 121: UPDATE ar_receivable_applications_all ra

117: PROCEDURE stamping_11i_app_post
118: IS
119: BEGIN
120: log(' stamping_11i_app_post +');
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,

Line 126: ar_receivable_applications_all app

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')
130: AND evt.event_id = app.event_id

Line 643: ar_receivable_applications_all app,

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,
647: ra_cust_trx_line_gl_dist_all ctlgd

Line 675: ar_receivable_applications_all app,

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
679: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 696: ar_receivable_applications_all 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
700: IN ( 'CM_CREATE' ,'CM_UPDATE' )

Line 919: ar_receivable_applications_all app,

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
923: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 936: ar_receivable_applications_all 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
940: IN ( 'CM_CREATE' ,'CM_UPDATE' )

Line 2372: ar_receivable_applications_all app

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')
2376: AND evt.event_id = app.event_id

Line 2389: ar_receivable_applications_all app

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')
2393: AND evt.event_id = app.event_id

Line 2425: ar_receivable_applications_all app,

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' ,
2429: 'CM_CREATE' ,'CM_UPDATE')

Line 2496: ar_receivable_applications_all app,

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',
2500: 'CM_CREATE' ,'CM_UPDATE' )

Line 2519: ar_receivable_applications_all app,

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
2523: AND app.status = 'APP'

Line 2650: ar_receivable_applications_all app

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' )
2654: AND evt.event_id = app.event_id

Line 2665: ar_receivable_applications_all app

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' )
2669: AND evt.event_id = app.event_id

Line 2682: ar_receivable_applications_all app

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'
2686: AND app.upgrade_method IS NULL

Line 2695: ar_receivable_applications_all app

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'
2699: AND app.upgrade_method IS NULL

Line 3117: UPDATE ar_receivable_applications_all ra

3113: PROCEDURE stamping_11i_mfar_app_post
3114: IS
3115: BEGIN
3116: arp_standard.debug('stamping_11i_mfar_app_post +');
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,

Line 3122: ar_receivable_applications_all app

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')
3126: AND evt.event_id = app.event_id

Line 3138: ar_receivable_applications_all app

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')
3142: AND evt.event_id = app.event_id

Line 3165: UPDATE ar_receivable_applications_all ra

3161: PROCEDURE stamping_11i_cash_app_post
3162: IS
3163: BEGIN
3164: arp_standard.debug('stamping_11i_cash_app_post +');
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,

Line 3170: ar_receivable_applications_all app

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')
3174: AND evt.event_id = app.event_id