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_CASH_RECEIPT_HISTORY_ALL

Line 544: ar_cash_receipt_history_all crh,

540: gl_sets_of_books sob,
541: oe_system_parameters_all osp,
542: ar_cash_receipts_all cr,
543: --BUG#5201086
544: ar_cash_receipt_history_all crh,
545: ra_customer_trx_all trx
546: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
547: 'RECP_RATE_ADJUST' ) --,'RECP_REVERSE') uptake XLA transaction reversal
548: AND gt.application_id = p_application_id

Line 737: ar_cash_receipt_history_all crh,

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,
737: ar_cash_receipt_history_all crh,
738: ra_customer_trx_all trx
739: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
740: 'RECP_RATE_ADJUST') -- Uptake XLA trx reversal ,'RECP_REVERSE')
741: AND gt.application_id = 222

Line 3639: ar_cash_receipt_history_all crh,

3635: ,'N' --MFAR_ADDITIONAL_ENTRY
3636: --}
3637: FROM xla_events_gt gt,
3638: ar_cash_receipts_all cr,
3639: ar_cash_receipt_history_all crh,
3640: ar_distributions_all dist,
3641: gl_sets_of_books sob,
3642: ar_cash_receipt_history_all pcrh
3643: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 3642: ar_cash_receipt_history_all pcrh

3638: ar_cash_receipts_all cr,
3639: ar_cash_receipt_history_all crh,
3640: ar_distributions_all dist,
3641: gl_sets_of_books sob,
3642: ar_cash_receipt_history_all pcrh
3643: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3644: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,
3645: --Uptake XLA Reversal 'RECP_REVERSE' ,'MISC_RECP_REVERSE' ,
3646: --5201086

Line 3838: ar_cash_receipt_history_all crh,

3834: ,DECODE(NVL(app.receivables_trx_id,0), -16,
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' ,

Line 4038: FROM ar_cash_receipt_history_all crh

4034: ,ct.sold_to_customer_id
4035: ,ct.sold_to_site_use_id
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

Line 4133: ar_cash_receipt_history_all crh,

4129: ,DECODE(ard.source_type,'CASH' ,'CLEARED',
4130: 'REMITTANCE' ,'REMITTED',
4131: 'CONFIRMATION','CONFIRMED','CASH')
4132: FROM xla_events_gt gt,
4133: ar_cash_receipt_history_all crh,
4134: ar_cash_receipts_all cr,
4135: ar_distributions_all ard,
4136: gl_ledgers lg
4137: WHERE gt.application_id = 222

Line 4468: ar_cash_receipt_history_all crh,

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,
4472: ra_customer_trx_lines_all ctl,

Line 4475: ar_cash_receipt_history_all crhlatest

4471: ra_cust_trx_line_gl_dist_all ctlgd,
4472: ra_customer_trx_lines_all ctl,
4473: ar_cash_receipts_all cr,
4474: gl_ledgers lg,
4475: ar_cash_receipt_history_all crhlatest
4476: WHERE gt.application_id = 222
4477: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE')
4478: AND gt.event_id = ra.event_id
4479: AND ra.status = 'APP'

Line 4494: FROM ar_cash_receipt_history_all a

4490: AND ra.applied_customer_trx_id = trx.customer_trx_id
4491: AND crhlatest.cash_receipt_id = cr.cash_receipt_id
4492: AND crhlatest.cash_receipt_history_id =
4493: ( SELECT MAX(a.cash_receipt_history_id)
4494: FROM ar_cash_receipt_history_all a
4495: WHERE a.cash_receipt_id = cr.cash_receipt_id
4496: AND a.posting_control_id <> -3);
4497: local_log(procedure_name => 'mfar_get_ra',
4498: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_get_ra ()-');

Line 4606: ,ar_cash_receipt_history_all crh

4602: ,NULL
4603: ,NULL
4604: FROM ar_cash_receipts_all cr
4605: ,ar_misc_cash_distributions_all mcd
4606: ,ar_cash_receipt_history_all crh
4607: ,ar_distributions_all ard
4608: ,(SELECT entity_id,
4609: source_id_int_1
4610: FROM xla_events_gt

Line 4617: AND mcd.event_id <> NVL((select event_id from ar_cash_receipt_history_all crh1 where

4613: GROUP BY entity_id,
4614: source_id_int_1) xla
4615: WHERE xla.source_id_int_1 = cr.cash_receipt_id
4616: AND cr.cash_receipt_id = mcd.cash_receipt_id
4617: AND mcd.event_id <> NVL((select event_id from ar_cash_receipt_history_all crh1 where
4618: crh1.cash_receipt_id = cr.cash_receipt_id and
4619: crh1.status='REVERSED' and crh1.current_record_flag = 'Y'),0)
4620: AND mcd.cash_receipt_history_id = crh.cash_receipt_history_id(+)
4621: AND mcd.misc_cash_distribution_id = ard.source_id

Line 5182: ar_cash_receipt_history_all crh

5178: ar_distributions_all dist,
5179: gl_sets_of_books sob,
5180: ar_cash_receipts_all cr,
5181: --5201086
5182: ar_cash_receipt_history_all crh
5183: WHERE gt.event_type_code IN ( 'MISC_RECP_CREATE','MISC_RECP_RATE_ADJUST',
5184: 'MISC_RECP_UPDATE') --Uptake XLA Reversal 'MISC_RECP_REVERSE' )
5185: --'MISC_RECP_REVERSE' REVERSAL only needs header level source
5186: AND gt.event_id = mcd.event_id

Line 5345: -- AR_CASH_RECEIPT_HISTORY_ALL A Those 4 A entities will post together

5341: -- AR_MC_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
5342: -- AR_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
5343: -- RA_CUSTOMER_TRX_ALL Do not post
5344: -- AR_RATE_ADJUSTMENTS_ALL Do not post
5345: -- AR_CASH_RECEIPT_HISTORY_ALL A Those 4 A entities will post together
5346: -- AR_MC_CASH_RECEIPT_HIST A (Misc) Cash Receipt
5347: -- AR_MISC_CASH_DISTRIBUTIONS_ALL A
5348: -- AR_MC_MISC_CASH_DISTS A
5349: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether

Line 5415: -- AR_CASH_RECEIPT_HISTORY_ALL,

5411: SELECT trunc(sysdate) INTO l_date FROM SYS.DUAL;
5412: --
5413: -- CRH
5414: -- GL Posting entiting are
5415: -- AR_CASH_RECEIPT_HISTORY_ALL,
5416: -- AR_MISC_CASH_DISTRIBUTIONS_ALL,
5417: --
5418: UPDATE ar_cash_receipt_history_all
5419: SET posting_control_id = l_pst_id,

Line 5418: UPDATE ar_cash_receipt_history_all

5414: -- GL Posting entiting are
5415: -- AR_CASH_RECEIPT_HISTORY_ALL,
5416: -- AR_MISC_CASH_DISTRIBUTIONS_ALL,
5417: --
5418: UPDATE ar_cash_receipt_history_all
5419: SET posting_control_id = l_pst_id,
5420: gl_posted_date = l_date
5421: WHERE posting_control_id = -3
5422: AND (cash_receipt_id, event_id) IN

Line 5679: ar_cash_receipt_history_all crh

5675: -- CRH MCD
5676: SELECT 'lock'
5677: BULK COLLECT INTO l_lock
5678: FROM xla_entity_events_v eve,
5679: ar_cash_receipt_history_all crh
5680: WHERE eve.request_id = p_report_request_id
5681: AND eve.application_id = p_application_id
5682: AND eve.entity_code = 'RECEIPTS'
5683: AND eve.event_id = crh.event_id