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 663: ar_receivable_applications_all app,

659: , NULL -- tax_inc_flag
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,

Line 701: ar_receivable_applications_all app,

697: SELECT DISTINCT inv.customer_trx_id,
698: inv.invoice_currency_code,
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' ,

Line 722: ar_receivable_applications_all app,

718: SELECT DISTINCT inv.customer_trx_id,
719: inv.invoice_currency_code,
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' )

Line 945: ar_receivable_applications_all app,

941: SELECT DISTINCT inv.customer_trx_id,
942: inv.invoice_currency_code,
943: inv.set_of_books_id
944: FROM xla_events_gt evt,
945: ar_receivable_applications_all app,
946: ra_customer_trx_all inv,
947: psa_trx_types_all psa
948: WHERE evt.event_type_code
949: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 962: ar_receivable_applications_all app,

958: SELECT DISTINCT inv.customer_trx_id,
959: inv.invoice_currency_code,
960: inv.set_of_books_id
961: FROM xla_events_gt evt,
962: ar_receivable_applications_all app,
963: ra_customer_trx_all inv,
964: psa_trx_types_all psa
965: WHERE evt.event_type_code
966: IN ( 'CM_CREATE' ,'CM_UPDATE' )

Line 2591: ar_receivable_applications_all app

2587: IS
2588: CURSOR c1 IS
2589: SELECT app.receivable_application_id
2590: FROM xla_events_gt evt,
2591: ar_receivable_applications_all app
2592: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
2593: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
2594: 'CM_CREATE' ,'CM_UPDATE')
2595: AND evt.event_id = app.event_id

Line 2608: ar_receivable_applications_all app

2604: MINUS -- This is to avoid corrupted data. In the case the same invoice has MF and none MF adjustment
2605: -- theorically impossible
2606: SELECT app.receivable_application_id
2607: FROM xla_events_gt evt,
2608: ar_receivable_applications_all app
2609: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
2610: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
2611: 'CM_CREATE' ,'CM_UPDATE')
2612: AND evt.event_id = app.event_id

Line 2644: ar_receivable_applications_all app,

2640: IS
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')

Line 2715: ar_receivable_applications_all app,

2711:
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' )

Line 2738: ar_receivable_applications_all app,

2734: -- which is on the to document
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'

Line 2869: ar_receivable_applications_all app

2865:
2866: CURSOR c_app IS
2867: SELECT app.*
2868: FROM xla_events_gt evt,
2869: ar_receivable_applications_all app
2870: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2871: 'RECP_RATE_ADJUST' ,'RECP_REVERSE',
2872: 'CM_CREATE' ,'CM_UPDATE' )
2873: AND evt.event_id = app.event_id

Line 2884: ar_receivable_applications_all app

2880: AND adj.postable = 'Y')
2881: MINUS
2882: SELECT app.*
2883: FROM xla_events_gt evt,
2884: ar_receivable_applications_all app
2885: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2886: 'RECP_RATE_ADJUST' ,'RECP_REVERSE',
2887: 'CM_CREATE' ,'CM_UPDATE' )
2888: AND evt.event_id = app.event_id

Line 2901: ar_receivable_applications_all app

2897:
2898: CURSOR c_cm_from_app IS
2899: SELECT app.*
2900: FROM xla_events_gt evt,
2901: ar_receivable_applications_all app
2902: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2903: AND evt.event_id = app.event_id
2904: AND app.status = 'APP'
2905: AND app.upgrade_method IS NULL

Line 2914: ar_receivable_applications_all app

2910: AND adj.postable = 'Y')
2911: MINUS
2912: SELECT app.*
2913: FROM xla_events_gt evt,
2914: ar_receivable_applications_all app
2915: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2916: AND evt.event_id = app.event_id
2917: AND app.status = 'APP'
2918: AND app.upgrade_method IS NULL

Line 3336: UPDATE ar_receivable_applications_all ra

3332: PROCEDURE stamping_11i_mfar_app_post
3333: IS
3334: BEGIN
3335: arp_standard.debug('stamping_11i_mfar_app_post +');
3336: UPDATE ar_receivable_applications_all ra
3337: SET ra.upgrade_method = 'R12_11IMFAR_POST'
3338: WHERE ra.receivable_application_id IN (
3339: SELECT app.receivable_application_id
3340: FROM xla_events_gt evt,

Line 3341: ar_receivable_applications_all app

3337: SET ra.upgrade_method = 'R12_11IMFAR_POST'
3338: WHERE ra.receivable_application_id IN (
3339: SELECT app.receivable_application_id
3340: FROM xla_events_gt evt,
3341: ar_receivable_applications_all app
3342: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
3343: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
3344: 'CM_CREATE' ,'CM_UPDATE')
3345: AND evt.event_id = app.event_id

Line 3357: ar_receivable_applications_all app

3353: AND adj.postable = 'Y')
3354: MINUS
3355: SELECT app.receivable_application_id
3356: FROM xla_events_gt evt,
3357: ar_receivable_applications_all app
3358: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
3359: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
3360: 'CM_CREATE' ,'CM_UPDATE')
3361: AND evt.event_id = app.event_id

Line 3384: UPDATE ar_receivable_applications_all ra

3380: PROCEDURE stamping_11i_cash_app_post
3381: IS
3382: BEGIN
3383: arp_standard.debug('stamping_11i_cash_app_post +');
3384: UPDATE ar_receivable_applications_all ra
3385: SET ra.upgrade_method = 'R12_11ICASH_POST'
3386: WHERE ra.receivable_application_id IN (
3387: SELECT app.receivable_application_id
3388: FROM xla_events_gt evt,

Line 3389: ar_receivable_applications_all app

3385: SET ra.upgrade_method = 'R12_11ICASH_POST'
3386: WHERE ra.receivable_application_id IN (
3387: SELECT app.receivable_application_id
3388: FROM xla_events_gt evt,
3389: ar_receivable_applications_all app
3390: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3391: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
3392: 'CM_CREATE' ,'CM_UPDATE')
3393: AND evt.event_id = app.event_id