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_RECEIPTS_ALL

Line 803: ar_cash_receipts_all cr,

799: ar_receivable_applications_all app,
800: ar_distributions_all dist,
801: gl_sets_of_books sob,
802: oe_system_parameters_all osp,
803: ar_cash_receipts_all cr,
804: --BUG#5201086
805: ar_cash_receipt_history_all crh,
806: ra_customer_trx_all trx
807: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 1107: ar_cash_receipts_all cr,

1103: ar_receivable_applications_all app,
1104: ar_distributions_all dist,
1105: gl_sets_of_books sob,
1106: oe_system_parameters_all osp,
1107: ar_cash_receipts_all cr,
1108: --BUG#5201086
1109: ar_cash_receipt_history_all crh,
1110: ra_customer_trx_all trx
1111: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 1302: ar_cash_receipts_all cr,

1298: ar_receivable_applications_all app,
1299: ar_cash_basis_dists_all dist,
1300: gl_sets_of_books sob,
1301: oe_system_parameters_all osp,
1302: ar_cash_receipts_all cr,
1303: ar_cash_receipt_history_all crh,
1304: ra_customer_trx_all trx
1305: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
1306: 'RECP_RATE_ADJUST') -- Uptake XLA trx reversal ,'RECP_REVERSE')

Line 2449: ar_cash_receipts_all cr

2445: 'MISC_RECP_REVERSE','Y','N') --reversal_code
2446: ,'N' --MFAR_ADDITIONAL_ENTRY
2447: FROM xla_events_gt gt,
2448: gl_sets_of_books sob,
2449: ar_cash_receipts_all cr
2450: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2451: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,--Header level view reversal stay
2452: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,
2453: 'MISC_RECP_RATE_ADJUST','MISC_RECP_REVERSE' )--BUG#3419926

Line 3368: ar_cash_receipts_all cr

3364: ra_customer_trx_all trxt,
3365: ra_customer_trx_lines_all tlt,
3366: ra_cust_trx_line_gl_dist_all gldt,
3367: ar_payment_schedules_all psch,
3368: ar_cash_receipts_all cr
3369: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3370: 'RECP_RATE_ADJUST' ) -- Uptake XLA reversal, 'RECP_REVERSE')
3371: -- Exclude 'RECP_REVERSE' for no extract at line level is reuired for Reversal
3372: AND gt.application_id = p_application_id

Line 4332: ar_cash_receipts_all cr,

4328: ,gt.entity_code
4329: ,'N' --MFAR_ADDITIONAL_ENTRY
4330: --}
4331: FROM xla_events_gt gt,
4332: ar_cash_receipts_all cr,
4333: ar_cash_receipt_history_all crh,
4334: ar_distributions_all dist,
4335: gl_sets_of_books sob,
4336: ar_cash_receipt_history_all pcrh

Line 4531: ar_cash_receipts_all cr,

4527: --Bug7255483 Added value for new column in the view
4528: ,DECODE(NVL(app.receivables_trx_id,0), -16,
4529: NVL(dist.from_acctd_amount_cr,0) - NVL(dist.from_acctd_amount_dr,0),to_number(NULL))
4530: FROM xla_events_gt gt,
4531: ar_cash_receipts_all cr,
4532: ar_cash_receipt_history_all crh,
4533: ar_receivable_applications_all app,
4534: ar_distributions_all dist,
4535: gl_sets_of_books sob

Line 5917: ,ar_cash_receipts_all cr

5913: ,ra.amount_applied
5914: ,ra.acctd_amount_applied_from
5915: ,decode(ct.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
5916: FROM ar_cash_receipt_history_all crh
5917: ,ar_cash_receipts_all cr
5918: ,ar_receivable_applications_all ra
5919: ,ar_distributions_all ard
5920: ,ra_customer_trx_all ct
5921: ,ra_cust_trx_line_gl_dist_all ctlgd

Line 6041: ar_cash_receipts_all cr,

6037: 'BANK_CHARGES','CLEARED'
6038: ,'CASH'), 'ACTUAL','REVERSAL') DIST_LINE_STATUS
6039: FROM xla_events_gt gt,
6040: ar_cash_receipt_history_all crh,
6041: ar_cash_receipts_all cr,
6042: ar_distributions_all ard,
6043: gl_ledgers lg
6044: WHERE gt.application_id = 222
6045: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')

Line 6107: ar_cash_receipts_all cr,

6103: , 'REV_DIST',(paircrh.acctd_amount+ nvl(paircrh.acctd_factor_discount_amount,0))) recp_acctd_amount
6104: , decode(state.status, 'ORG_DIST','ACTUAL','REVERSAL') DIST_LINE_STATUS
6105: FROM xla_events_gt gt,
6106: ar_cash_receipt_history_all crh,
6107: ar_cash_receipts_all cr,
6108: ar_distributions_all ard,
6109: ar_cash_receipt_history_all paircrh,
6110: ar_distributions_all pairard,
6111: gl_ledgers lg,

Line 6172: ar_cash_receipts_all cr,

6168: , 'REV_DIST',(paircrh.acctd_amount+ nvl(paircrh.acctd_factor_discount_amount,0))) recp_acctd_amount
6169: , decode(state.status, 'ORG_DIST','ACTUAL','REVERSAL') DIST_LINE_STATUS
6170: FROM xla_events_gt gt,
6171: ar_cash_receipt_history_all crh,
6172: ar_cash_receipts_all cr,
6173: ar_distributions_all ard,
6174: ar_cash_receipt_history_all paircrh,
6175: ar_distributions_all pairard,
6176: gl_ledgers lg,

Line 6483: ar_cash_receipts_all cr,

6479: ar_distributions_all ard,
6480: ra_customer_trx_all trx,
6481: ra_cust_trx_line_gl_dist_all ctlgd,
6482: ra_customer_trx_lines_all ctl,
6483: ar_cash_receipts_all cr,
6484: gl_ledgers lg,
6485: ar_cash_receipt_history_all crhlatest,
6486: (SELECT source_id,
6487: MAX(line_id) max_line_id

Line 6600: ar_cash_receipts_all cr,

6596: ar_distributions_all ard,
6597: ra_customer_trx_all trx,
6598: ra_cust_trx_line_gl_dist_all ctlgd,
6599: ra_customer_trx_lines_all ctl,
6600: ar_cash_receipts_all cr,
6601: gl_ledgers lg,
6602: (SELECT source_id,
6603: MAX(line_id) max_line_id
6604: FROM ar_xla_lines_extract

Line 6713: ar_cash_receipts_all cr,

6709: ar_distributions_all ard,
6710: ra_customer_trx_all trx,
6711: ra_cust_trx_line_gl_dist_all ctlgd,
6712: ra_customer_trx_lines_all ctl,
6713: ar_cash_receipts_all cr,
6714: gl_ledgers lg,
6715: ar_cash_receipt_history_all crhlatest,
6716: (SELECT source_id,
6717: MAX(line_id) max_line_id

Line 6833: ar_cash_receipts_all cr,

6829: ar_distributions_all ard,
6830: ra_customer_trx_all trx,
6831: ra_cust_trx_line_gl_dist_all ctlgd,
6832: ra_customer_trx_lines_all ctl,
6833: ar_cash_receipts_all cr,
6834: gl_ledgers lg,
6835: ar_crh_gt crhgt,
6836: (SELECT source_id,
6837: MAX(line_id) max_line_id

Line 7119: ar_cash_receipts_all cr,

7115: ra_customer_trx_all trxt,
7116: ra_customer_trx_lines_all tlt,
7117: ra_cust_trx_line_gl_dist_all gldt,
7118: ar_payment_schedules_all psch,
7119: ar_cash_receipts_all cr,
7120: ar_distributions_all currard
7121: WHERE gt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE', 'RECP_RATE_ADJUST' )
7122: AND gt.application_id = 222
7123: AND gt.event_id = app.event_id

Line 7256: FROM ar_cash_receipts_all cr

7252: ,NULL
7253: ,NULL
7254: ,NULL
7255: ,cr.amount
7256: FROM ar_cash_receipts_all cr
7257: ,ar_misc_cash_distributions_all mcd
7258: ,ar_cash_receipt_history_all crh
7259: ,ar_distributions_all ard
7260: ,(SELECT entity_id,

Line 7832: ar_cash_receipts_all cr,

7828: FROM xla_events_gt gt,
7829: ar_misc_cash_distributions_all mcd,
7830: ar_distributions_all dist,
7831: gl_sets_of_books sob,
7832: ar_cash_receipts_all cr,
7833: --5201086
7834: ar_cash_receipt_history_all crh
7835: WHERE gt.event_type_code IN ( 'MISC_RECP_CREATE','MISC_RECP_RATE_ADJUST',
7836: 'MISC_RECP_UPDATE') --Uptake XLA Reversal 'MISC_RECP_REVERSE' )