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.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 167: l_app_rec ar_receivable_applications%ROWTYPE;

163: l_customer_trx_id NUMBER;
164: l_receivable_application_id NUMBER;
165: l_to_currency VARCHAR2(30);
166: l_ae_sys_rec arp_acct_main.ae_sys_rec_type;
167: l_app_rec ar_receivable_applications%ROWTYPE;
168:
169: BEGIN
170: local_log(procedure_name => 'upgrade_11i_r12_post',
171: p_msg_text => 'Calling upgrade_11i_r12_post +');

Line 210: ar_receivable_applications_all app,

206: 'REC' ,'APP_LINE' , NULL),
207: NVL(dist.AMOUNT_CR,0)-NVL(dist.AMOUNT_DR,0),
208: NVL(dist.ACCTD_AMOUNT_CR,0)-NVL(dist.ACCTD_AMOUNT_DR,0)
209: FROM xla_events_gt eve,
210: ar_receivable_applications_all app,
211: ar_distributions_all dist,
212: gl_ledgers sob
213: WHERE eve.application_id = 222
214: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')

Line 278: UPDATE ar_receivable_applications_all

274: --Update receivable applications
275: local_log(procedure_name => 'upgrade_11i_r12_post',
276: p_msg_text => ' Set application upgrade_method 11I_R12_POST');
277:
278: UPDATE ar_receivable_applications_all
279: SET upgrade_method = '11I_R12_POST'
280: WHERE receivable_application_id IN
281: (SELECT gt_id
282: FROM ar_line_app_detail_gt

Line 538: ar_receivable_applications_all app,

534: ,gt.event_class_code
535: ,gt.entity_code
536: ,'N' --MFAR_ADDITIONAL_ENTRY
537: FROM xla_events_gt gt,
538: ar_receivable_applications_all app,
539: ar_distributions_all dist,
540: gl_sets_of_books sob,
541: oe_system_parameters_all osp,
542: ar_cash_receipts_all cr,

Line 732: ar_receivable_applications_all app,

728: ,gt.entity_code
729: ,app.upgrade_method
730: ,'N' --MFAR_ADDITIONAL_ENTRY
731: FROM xla_events_gt gt,
732: ar_receivable_applications_all app,
733: ar_cash_basis_dists_all dist,
734: gl_sets_of_books sob,
735: oe_system_parameters_all osp,
736: ar_cash_receipts_all cr,

Line 954: ar_receivable_applications_all app,

950: tlf.tax_line_id, --tax_line_id
951: app.upgrade_method
952: ,'N' --MFAR_ADDITIONAL_ENTRY
953: FROM xla_events_gt gt,
954: ar_receivable_applications_all app,
955: ar_distributions_all dist,
956: gl_sets_of_books sob,
957: oe_system_parameters_all osp,
958: ra_customer_trx_all trxf,

Line 1163: ar_receivable_applications_all app,

1159: ,tlf.tax_line_id --tax_line_id
1160: ,app.upgrade_method
1161: ,'N' --MFAR_ADDITIONAL_ENTRY
1162: FROM xla_events_gt gt,
1163: ar_receivable_applications_all app,
1164: ar_cash_basis_dists_all dist,
1165: gl_sets_of_books sob,
1166: oe_system_parameters_all osp,
1167: ra_customer_trx_all trxf,

Line 2681: ar_receivable_applications_all app,

2677: --BUG5366837
2678: ,app.upgrade_method
2679: ,'N' --MFAR_ADDITIONAL_ENTRY
2680: FROM xla_events_gt gt,
2681: ar_receivable_applications_all app,
2682: ar_distributions_all dist,
2683: gl_sets_of_books sob,
2684: oe_system_parameters_all osp,
2685: ra_customer_trx_all trxt,

Line 2811: ar_receivable_applications_all app,

2807: --BUG#5366837
2808: ,app.upgrade_method
2809: ,'N' --MFAR_ADDITIONAL_ENTRY
2810: FROM xla_events_gt gt,
2811: ar_receivable_applications_all app,
2812: ar_distributions_all dist,
2813: gl_sets_of_books sob,
2814: oe_system_parameters_all osp,
2815: ra_customer_trx_all trxt,

Line 2937: ar_receivable_applications_all app,

2933: --BUG#5366837
2934: ,app.upgrade_method
2935: ,'N' --MFAR_ADDITIONAL_ENTRY
2936: FROM xla_events_gt gt,
2937: ar_receivable_applications_all app,
2938: ar_distributions_all dist,
2939: gl_sets_of_books sob,
2940: ra_customer_trx_all trx
2941: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )

Line 3110: ar_receivable_applications_all app,

3106: ,tlt.tax_line_id --tax_line_id
3107: ,app.upgrade_method
3108: ,'N' --MFAR_ADDITIONAL_ENTRY
3109: FROM xla_events_gt gt,
3110: ar_receivable_applications_all app,
3111: AR_CASH_BASIS_DISTS_ALL acb,
3112: gl_sets_of_books sob,
3113: oe_system_parameters_all osp,
3114: ra_customer_trx_all trxt,

Line 3214: ar_receivable_applications_all app,

3210: ,tlt.tax_line_id -- tax_line_id
3211: ,app.upgrade_method
3212: ,'N' --MFAR_ADDITIONAL_ENTRY
3213: FROM xla_events_gt gt,
3214: ar_receivable_applications_all app,
3215: AR_CASH_BASIS_DISTS_ALL acb,
3216: gl_sets_of_books sob,
3217: oe_system_parameters_all osp,
3218: ra_customer_trx_all trxt,

Line 3433: ar_receivable_applications_all app,

3429: ,gt.entity_code
3430: --}
3431: ,'N' --MFAR_ADDITIONAL_ENTRY
3432: FROM xla_events_gt gt,
3433: ar_receivable_applications_all app,
3434: ar_distributions_all dist, --ar_distributions_all dist,
3435: gl_sets_of_books sob
3436: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3437: 'RECP_RATE_ADJUST' ) --Uptake XLA reversal,'RECP_REVERSE')

Line 3839: ar_receivable_applications_all app,

3835: NVL(dist.from_acctd_amount_cr,0) - NVL(dist.from_acctd_amount_dr,0),to_number(NULL))
3836: FROM xla_events_gt gt,
3837: ar_cash_receipts_all cr,
3838: ar_cash_receipt_history_all crh,
3839: ar_receivable_applications_all app,
3840: ar_distributions_all dist,
3841: gl_sets_of_books sob
3842: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3843: 'RECP_RATE_ADJUST' ) --Uptake XLA Reversal,'RECP_REVERSE' )

Line 4040: ,ar_receivable_applications_all ra

4036: ,ct.ship_to_customer_id
4037: ,ct.ship_to_site_use_id
4038: FROM ar_cash_receipt_history_all crh
4039: ,ar_cash_receipts_all cr
4040: ,ar_receivable_applications_all ra
4041: ,ar_distributions_all ard
4042: ,ra_customer_trx_all ct
4043: ,ra_cust_trx_line_gl_dist_all ctlgd
4044: ,ra_customer_trx_lines_all ctl

Line 4467: ar_receivable_applications_all ra,

4463: ,ard.third_party_sub_id --third_party_site_id
4464: ,DECODE(ard.third_party_id,NULL,NULL,'C') --third_party_type
4465: ,ard.source_type --source_type
4466: FROM xla_events_gt gt,
4467: ar_receivable_applications_all ra,
4468: ar_cash_receipt_history_all crh,
4469: ar_distributions_all ard,
4470: ra_customer_trx_all trx,
4471: ra_cust_trx_line_gl_dist_all ctlgd,

Line 5353: -- AR_RECEIVABLE_APPLICATIONS_ALL D Those 2 D entities will post together

5349: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether
5350: -- RA_MC_TRX_LINE_GL_DIST B (Transactions)
5351: -- AR_ADJUSTMENTS_ALL C Those 2 C entities will post together
5352: -- AR_MC_ADJUSTMENTS C (Adjustments)
5353: -- AR_RECEIVABLE_APPLICATIONS_ALL D Those 2 D entities will post together
5354: -- AR_MC_RECEIVABLE_APPS D (Applications)
5355: -- AR_TRANSACTION_HISTORY_ALL E Those 2 E entities will post together
5356: -- AR_MC_TRANSACTION_HISTORY E (Bill Receivables)
5357: -- Question are there any side effect

Line 5494: -- AR_RECEIVABLE_APPLICATIONS_ALL,

5490:
5491: --
5492: -- APP
5493: -- GL Posting entiting are
5494: -- AR_RECEIVABLE_APPLICATIONS_ALL,
5495: --
5496: UPDATE ar_receivable_applications_all
5497: SET posting_control_id = l_pst_id,
5498: gl_posted_date = l_date

Line 5496: UPDATE ar_receivable_applications_all

5492: -- APP
5493: -- GL Posting entiting are
5494: -- AR_RECEIVABLE_APPLICATIONS_ALL,
5495: --
5496: UPDATE ar_receivable_applications_all
5497: SET posting_control_id = l_pst_id,
5498: gl_posted_date = l_date
5499: WHERE posting_control_id = -3
5500: AND event_id IN

Line 5665: ar_receivable_applications_all app

5661: -- APP
5662: SELECT 'lock'
5663: BULK COLLECT INTO l_lock
5664: FROM xla_entity_events_v eve,
5665: ar_receivable_applications_all app
5666: WHERE eve.request_id = p_report_request_id
5667: AND eve.application_id = p_application_id
5668: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')
5669: AND eve.event_id = app.event_id