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 805: ar_cash_receipt_history_all crh,

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' ,
808: 'RECP_RATE_ADJUST' ) --,'RECP_REVERSE') uptake XLA transaction reversal
809: AND gt.application_id = p_application_id

Line 1109: ar_cash_receipt_history_all crh,

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' ,
1112: 'RECP_RATE_ADJUST' ) --,'RECP_REVERSE') uptake XLA transaction reversal
1113: AND gt.application_id = p_application_id

Line 1303: ar_cash_receipt_history_all crh,

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')
1307: AND gt.application_id = 222

Line 4333: ar_cash_receipt_history_all crh,

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
4337: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 4336: ar_cash_receipt_history_all pcrh

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
4337: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
4338: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,
4339: --Uptake XLA Reversal 'RECP_REVERSE' ,'MISC_RECP_REVERSE' ,
4340: --5201086

Line 4532: ar_cash_receipt_history_all crh,

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
4536: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 5916: FROM ar_cash_receipt_history_all crh

5912: ,ra.event_id
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

Line 6040: ar_cash_receipt_history_all crh,

6036: 'CONFIRMATION','CONFIRMED',
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

Line 6106: ar_cash_receipt_history_all crh,

6102: ,decode(state.status, 'ORG_DIST',(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0))
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,

Line 6109: ar_cash_receipt_history_all paircrh,

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,
6112: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6113: SELECT 'REV_DIST' AS status FROM DUAL) state

Line 6171: ar_cash_receipt_history_all crh,

6167: ,decode(state.status, 'ORG_DIST',(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0))
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,

Line 6174: ar_cash_receipt_history_all paircrh,

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,
6177: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6178: SELECT 'REV_DIST' AS status FROM DUAL) state

Line 6478: ar_cash_receipt_history_all crh,

6474: ,ext.max_line_id MAX_LINE_ID
6475: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6476: FROM xla_events_gt gt,
6477: ar_receivable_applications_all ra,
6478: ar_cash_receipt_history_all crh,
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,

Line 6485: ar_cash_receipt_history_all crhlatest,

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
6488: FROM ar_xla_lines_extract
6489: WHERE source_table='RA'

Line 6515: FROM ar_cash_receipt_history_all a

6511: AND ra.receivable_application_id = ext.source_id
6512: AND crhlatest.cash_receipt_id = cr.cash_receipt_id
6513: AND crhlatest.cash_receipt_history_id =
6514: ( SELECT MAX(a.cash_receipt_history_id)
6515: FROM ar_cash_receipt_history_all a
6516: WHERE a.cash_receipt_id = cr.cash_receipt_id
6517: AND posting_control_id <> -3)
6518: UNION ALL
6519: SELECT

Line 6595: ar_cash_receipt_history_all crh,

6591: ,ext.max_line_id MAX_LINE_ID
6592: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6593: FROM xla_events_gt gt,
6594: ar_receivable_applications_all ra,
6595: ar_cash_receipt_history_all crh,
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,

Line 6708: ar_cash_receipt_history_all crh,

6704: ,ext.max_line_id MAX_LINE_ID
6705: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6706: FROM xla_events_gt gt,
6707: ar_receivable_applications_all ra,
6708: ar_cash_receipt_history_all crh,
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,

Line 6715: ar_cash_receipt_history_all crhlatest,

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
6718: FROM ar_xla_lines_extract
6719: WHERE source_table='RA'

Line 6745: FROM ar_cash_receipt_history_all a

6741: AND ra.applied_customer_trx_id = trx.customer_trx_id
6742: AND crhlatest.cash_receipt_id = cr.cash_receipt_id
6743: AND crhlatest.cash_receipt_history_id =
6744: ( SELECT MAX(a.cash_receipt_history_id)
6745: FROM ar_cash_receipt_history_all a
6746: WHERE a.cash_receipt_id = cr.cash_receipt_id
6747: AND a.posting_control_id <> -3)
6748: AND crhlatest.status = 'CLEARED'
6749: AND NVL(crhlatest.factor_discount_amount,0) <> 0

Line 6828: ar_cash_receipt_history_all crh,

6824: ,ext.max_line_id MAX_LINE_ID
6825: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6826: FROM xla_events_gt gt,
6827: ar_receivable_applications_all ra,
6828: ar_cash_receipt_history_all crh,
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,

Line 7258: ,ar_cash_receipt_history_all crh

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,
7261: source_id_int_1
7262: FROM xla_events_gt

Line 7269: AND nvl(mcd.event_id, -1) <> NVL((select event_id from ar_cash_receipt_history_all crh1 where

7265: GROUP BY entity_id,
7266: source_id_int_1) xla
7267: WHERE xla.source_id_int_1 = cr.cash_receipt_id
7268: AND cr.cash_receipt_id = mcd.cash_receipt_id
7269: AND nvl(mcd.event_id, -1) <> NVL((select event_id from ar_cash_receipt_history_all crh1 where
7270: crh1.cash_receipt_id = cr.cash_receipt_id and
7271: crh1.status='REVERSED' and crh1.current_record_flag = 'Y'),0)
7272: AND mcd.cash_receipt_history_id = crh.cash_receipt_history_id(+)
7273: AND mcd.misc_cash_distribution_id = ard.source_id

Line 7834: ar_cash_receipt_history_all crh

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' )
7837: --'MISC_RECP_REVERSE' REVERSAL only needs header level source
7838: AND gt.event_id = mcd.event_id

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

7998: -- AR_MC_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
7999: -- AR_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
8000: -- RA_CUSTOMER_TRX_ALL Do not post
8001: -- AR_RATE_ADJUSTMENTS_ALL Do not post
8002: -- AR_CASH_RECEIPT_HISTORY_ALL A Those 4 A entities will post together
8003: -- AR_MC_CASH_RECEIPT_HIST A (Misc) Cash Receipt
8004: -- AR_MISC_CASH_DISTRIBUTIONS_ALL A
8005: -- AR_MC_MISC_CASH_DISTS A
8006: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether

Line 8072: -- AR_CASH_RECEIPT_HISTORY_ALL,

8068: SELECT trunc(sysdate) INTO l_date FROM SYS.DUAL;
8069: --
8070: -- CRH
8071: -- GL Posting entiting are
8072: -- AR_CASH_RECEIPT_HISTORY_ALL,
8073: -- AR_MISC_CASH_DISTRIBUTIONS_ALL,
8074: --
8075: UPDATE ar_cash_receipt_history_all
8076: SET posting_control_id = l_pst_id,

Line 8075: UPDATE ar_cash_receipt_history_all

8071: -- GL Posting entiting are
8072: -- AR_CASH_RECEIPT_HISTORY_ALL,
8073: -- AR_MISC_CASH_DISTRIBUTIONS_ALL,
8074: --
8075: UPDATE ar_cash_receipt_history_all
8076: SET posting_control_id = l_pst_id,
8077: gl_posted_date = l_date,
8078: last_updated_by = fnd_global.user_id,
8079: last_update_date = sysdate,

Line 8355: ar_cash_receipt_history_all crh

8351: -- CRH MCD
8352: SELECT 'lock'
8353: BULK COLLECT INTO l_lock
8354: FROM xla_entity_events_v eve,
8355: ar_cash_receipt_history_all crh
8356: WHERE eve.request_id = p_report_request_id
8357: AND eve.application_id = p_application_id
8358: AND eve.entity_code = 'RECEIPTS'
8359: AND eve.event_id = crh.event_id