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 662: FROM xla_events_gt evt,

658: , NULL -- tax_link_id
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,

Line 700: FROM xla_events_gt evt,

696: FROM ( -- Applied to transactions
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

Line 721: FROM xla_events_gt evt,

717: -- From CM in the case of CM 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

Line 944: FROM xla_events_gt evt,

940: FROM ( -- Applied to transactions
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

Line 961: FROM xla_events_gt evt,

957: -- From CM in the case of CM 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

Line 2590: FROM xla_events_gt evt,

2586: RETURN VARCHAR2
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')

Line 2607: FROM xla_events_gt evt,

2603: AND adj.postable = 'Y')
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')

Line 2643: FROM xla_events_gt evt,

2639: RETURN VARCHAR2
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' ,

Line 2714: FROM xla_events_gt evt,

2710: l_gt_id NUMBER := 0;
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',

Line 2737: FROM xla_events_gt evt,

2733: -- and in cash basis we only need to post applications
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

Line 2868: FROM xla_events_gt evt,

2864: l_gt_id NUMBER := 0;
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' )

Line 2883: FROM xla_events_gt evt,

2879: AND adj.status = 'A'
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' )

Line 2900: FROM xla_events_gt evt,

2896:
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'

Line 2913: FROM xla_events_gt evt,

2909: AND adj.status = 'A'
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'

Line 3340: FROM xla_events_gt evt,

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,
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')

Line 3356: FROM xla_events_gt evt,

3352: AND adj.status = 'A'
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')

Line 3388: FROM xla_events_gt evt,

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,
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')