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_UPGRADE dependencies on AR_CASH_RECEIPTS_ALL

Line 1783: FROM ar_cash_receipts_all cr,

1779: cr.doc_sequence_id DOC_SEQ_ID ,
1780: cr.doc_sequence_value DOC_SEQ_VAL ,
1781: rmth.name CAT_CODE ,
1782: te.entity_id ENTITY_ID
1783: FROM ar_cash_receipts_all cr,
1784: --ar_system_parameters_all sys,
1785: ar_cash_receipt_history_all crh,
1786: xla_upgrade_dates gps,
1787: ar_receipt_methods rmth,

Line 1886: FROM ar_cash_receipts_all cr,

1882: cr.doc_sequence_id DOC_SEQ_ID ,
1883: cr.doc_sequence_value DOC_SEQ_VAL ,
1884: rmth.name CAT_CODE ,
1885: te.entity_id ENTITY_ID
1886: FROM ar_cash_receipts_all cr,
1887: --ar_system_parameters_all sys,
1888: ar_misc_cash_distributions_all mcd,
1889: xla_upgrade_dates gps,
1890: ar_receipt_methods rmth,

Line 1986: FROM ar_cash_receipts_all cr,

1982: cr.doc_sequence_id DOC_SEQ_ID ,
1983: cr.doc_sequence_value DOC_SEQ_VAL ,
1984: rmth.name CAT_CODE ,
1985: te.entity_id ENTITY_ID
1986: FROM ar_cash_receipts_all cr,
1987: --ar_system_parameters_all sys,
1988: ar_receivable_applications_all app,
1989: xla_upgrade_dates gps,
1990: ar_cash_receipt_history_all crh,

Line 2299: from ar_cash_receipts_all cr,

2295: 'N' gain_or_loss_flag,
2296: hdr.accounting_date accounting_date,
2297: hdr.ledger_id ledger_id,
2298: 1 ln_order
2299: from ar_cash_receipts_all cr,
2300: ar_cash_receipt_history_all crh,
2301: xla_upgrade_dates gps,
2302: ar_cash_receipt_history_all crh1,
2303: xla_transaction_entities_upg ent,

Line 2394: from ar_cash_receipts_all cr,

2390: 'N') gain_or_loss_flag,
2391: hdr.accounting_date accounting_date,
2392: hdr.ledger_id ledger_id,
2393: 2 ln_order
2394: from ar_cash_receipts_all cr,
2395: ar_system_parameters_all sys,
2396: ar_receivable_applications_all app,
2397: xla_upgrade_dates gps,
2398: xla_transaction_entities_upg ent,

Line 2472: from ar_cash_receipts_all cr,

2468: 'N' gain_or_loss_flag,
2469: hdr.accounting_date accounting_date,
2470: hdr.ledger_id ledger_id,
2471: 1 ln_order
2472: from ar_cash_receipts_all cr,
2473: ar_misc_cash_distributions_all mcd,
2474: xla_upgrade_dates gps,
2475: ar_cash_receipt_history_all crh,
2476: xla_transaction_entities_upg ent,

Line 3221: ar_cash_receipts_all cr,

3217: set gir.gl_sl_link_id = (select min(xal.gl_sl_link_id)
3218: from xla_ae_lines xal,
3219: xla_ae_headers xah,
3220: xla_transaction_entities_upg xte,
3221: ar_cash_receipts_all cr,
3222: ar_system_parameters_all asp,
3223: xla_distribution_links xdl,
3224: ar_cash_receipt_history_all crh,
3225: xla_upgrade_dates gps,

Line 3272: ar_cash_receipts_all cr,

3268: set gir.gl_sl_link_id = (select min(xal.gl_sl_link_id)
3269: from xla_ae_lines xal,
3270: xla_ae_headers xah,
3271: xla_transaction_entities_upg xte,
3272: ar_cash_receipts_all cr,
3273: ar_system_parameters_all asp,
3274: xla_distribution_links xdl,
3275: ar_receivable_applications_all unapp,
3276: xla_upgrade_dates gps,

Line 3739: ar_cash_receipts_all cr,

3735: xla_transaction_entities_upg ent,
3736: ra_customer_trx_all ctcm,
3737: ar_cash_receipt_history_all crh1,
3738: ar_cash_receipt_history_all crh,
3739: ar_cash_receipts_all cr,
3740: xla_events ev,
3741: xla_ae_headers hdr,
3742: ar_cash_basis_dists_all cbs,
3743: ra_cust_trx_line_gl_dist_all ctlgd

Line 4060: FROM ar_cash_receipts_all cr,

4056: cr.doc_sequence_id DOC_SEQ_ID ,
4057: cr.doc_sequence_value DOC_SEQ_VAL ,
4058: rmth.name CAT_CODE ,
4059: te.entity_id ENTITY_ID
4060: FROM ar_cash_receipts_all cr,
4061: --ar_system_parameters_all sys,
4062: ar_cash_receipt_history_all crh,
4063: --xla_upgrade_dates gps,
4064: ar_receipt_methods rmth,

Line 4081: ar_cash_receipts_all cri

4077: and trunc(xei.event_date) = trunc(xahi.accounting_date)
4078: and xei.entity_id in
4079: (select xte.entity_id
4080: from xla_transaction_entities xte,
4081: ar_cash_receipts_all cri
4082: where nvl(xte.SOURCE_ID_INT_1,-99) = cri.cash_receipt_id
4083: and xte.entity_code in ('RECEIPTS')
4084: and xte.application_id = 222
4085: and xte.ledger_id = cri.set_of_books_id

Line 4181: FROM ar_cash_receipts_all cr,

4177: cr.doc_sequence_id DOC_SEQ_ID ,
4178: cr.doc_sequence_value DOC_SEQ_VAL ,
4179: rmth.name CAT_CODE ,
4180: te.entity_id ENTITY_ID
4181: FROM ar_cash_receipts_all cr,
4182: --ar_system_parameters_all sys,
4183: ar_misc_cash_distributions_all mcd,
4184: --xla_upgrade_dates gps,
4185: ar_receipt_methods rmth,

Line 4203: ar_cash_receipts_all cri

4199: and trunc(xei.event_date) = trunc(xahi.accounting_date)
4200: and xei.entity_id in
4201: (select xte.entity_id
4202: from xla_transaction_entities xte,
4203: ar_cash_receipts_all cri
4204: where nvl(xte.SOURCE_ID_INT_1,-99) = cri.cash_receipt_id
4205: and xte.entity_code in ('RECEIPTS')
4206: and xte.application_id = 222
4207: and xte.ledger_id = cri.set_of_books_id

Line 4299: FROM ar_cash_receipts_all cr,

4295: cr.doc_sequence_id DOC_SEQ_ID ,
4296: cr.doc_sequence_value DOC_SEQ_VAL ,
4297: rmth.name CAT_CODE ,
4298: te.entity_id ENTITY_ID
4299: FROM ar_cash_receipts_all cr,
4300: -- ar_system_parameters_all sys,
4301: ar_receivable_applications_all app,
4302: -- xla_upgrade_dates gps,
4303: ar_cash_receipt_history_all crh,

Line 4321: ar_cash_receipts_all cri

4317: and trunc(xei.event_date) = trunc(xahi.accounting_date)
4318: and xei.entity_id in
4319: (select xte.entity_id
4320: from xla_transaction_entities xte,
4321: ar_cash_receipts_all cri
4322: where nvl(xte.SOURCE_ID_INT_1,-99) = cri.cash_receipt_id
4323: and xte.entity_code in ('RECEIPTS')
4324: and xte.application_id = 222
4325: and xte.ledger_id = cri.set_of_books_id

Line 4617: from ar_cash_receipts_all cr,

4613: hdr.accounting_date accounting_date,
4614: hdr.ledger_id ledger_id,
4615: 1 ln_order,
4616: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
4617: from ar_cash_receipts_all cr,
4618: ar_cash_receipt_history_all crh,
4619: -- xla_upgrade_dates gps,
4620: ar_cash_receipt_history_all crh1,
4621: xla_transaction_entities_upg ent,

Line 4721: from ar_cash_receipts_all cr,

4717: hdr.accounting_date accounting_date,
4718: hdr.ledger_id ledger_id,
4719: 2 ln_order,
4720: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
4721: from ar_cash_receipts_all cr,
4722: ar_system_parameters_all sys,
4723: ar_receivable_applications_all app,
4724: -- xla_upgrade_dates gps,
4725: xla_transaction_entities_upg ent,

Line 4808: from ar_cash_receipts_all cr,

4804: hdr.accounting_date accounting_date,
4805: hdr.ledger_id ledger_id,
4806: 1 ln_order,
4807: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
4808: from ar_cash_receipts_all cr,
4809: ar_misc_cash_distributions_all mcd,
4810: -- xla_upgrade_dates gps,
4811: ar_cash_receipt_history_all crh,
4812: xla_transaction_entities_upg ent,

Line 5086: ar_cash_receipts_all cr,

5082: xla_transaction_entities_upg ent,
5083: ra_customer_trx_all ctcm,
5084: ar_cash_receipt_history_all crh1,
5085: ar_cash_receipt_history_all crh,
5086: ar_cash_receipts_all cr,
5087: xla_events ev,
5088: xla_ae_headers hdr,
5089: ar_cash_basis_dists_all cbs,
5090: ra_cust_trx_line_gl_dist_all ctlgd