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

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 2752: l_app_rec ar_receivable_applications%ROWTYPE;

2748: ra_customer_trx_all inv
2749: WHERE inv.customer_trx_id = app.customer_trx_id
2750: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2751: */
2752: l_app_rec ar_receivable_applications%ROWTYPE;
2753: l_line_acctd_amt NUMBER;
2754: l_tax_acctd_amt NUMBER;
2755: l_frt_acctd_amt NUMBER;
2756: l_chrg_acctd_amt NUMBER;

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 2926: l_app_rec ar_receivable_applications%ROWTYPE;

2922: AND adj.status = 'A'
2923: AND adj.postable = 'Y');
2924:
2925:
2926: l_app_rec ar_receivable_applications%ROWTYPE;
2927: l_line_acctd_amt NUMBER;
2928: l_tax_acctd_amt NUMBER;
2929: l_frt_acctd_amt NUMBER;
2930: l_chrg_acctd_amt NUMBER;

Line 3045: -- p_app_rec IN ar_receivable_applications%ROWTYPE -- the application record initial

3041: ---------------------------------------
3042: -- PROCEDURE COMPARE_RA_REM_AMT
3043: ---------------------------------------
3044: -- Arguments Input
3045: -- p_app_rec IN ar_receivable_applications%ROWTYPE -- the application record initial
3046: -- p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION' -- level of application
3047: -- p_group_id IN VARCHAR2 DEFAULT NULL -- if level = GROUP then which group
3048: -- p_ctl_id IN NUMBER DEFAULT NULL -- if level = LINE then which line
3049: -- p_currency IN VARCHAR2 -- transactional currency

Line 3052: -- x_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE -- after leasing the result app_rec

3048: -- p_ctl_id IN NUMBER DEFAULT NULL -- if level = LINE then which line
3049: -- p_currency IN VARCHAR2 -- transactional currency
3050: --------------
3051: -- Outputs
3052: -- x_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE -- after leasing the result app_rec
3053: -- x_return_status IN OUT NOCOPY VARCHAR2
3054: -- x_msg_data IN OUT NOCOPY VARCHAR2
3055: -- x_msg_count IN OUT NOCOPY NUMBER
3056: --------------

Line 3072: ( p_app_rec IN ar_receivable_applications%ROWTYPE,

3068: -- * but the disconcordance between the rem and the application amount per bucket will be
3069: -- handled by the amount applied bucket
3070: ----------------------------------------
3071: PROCEDURE COMPARE_RA_REM_AMT
3072: ( p_app_rec IN ar_receivable_applications%ROWTYPE,
3073: x_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE,
3074: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION',
3075: p_source_data_key1 IN VARCHAR2 DEFAULT NULL,
3076: p_source_data_key2 IN VARCHAR2 DEFAULT NULL,

Line 3073: x_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE,

3069: -- handled by the amount applied bucket
3070: ----------------------------------------
3071: PROCEDURE COMPARE_RA_REM_AMT
3072: ( p_app_rec IN ar_receivable_applications%ROWTYPE,
3073: x_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE,
3074: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION',
3075: p_source_data_key1 IN VARCHAR2 DEFAULT NULL,
3076: p_source_data_key2 IN VARCHAR2 DEFAULT NULL,
3077: p_source_data_key3 IN VARCHAR2 DEFAULT 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