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 XLA_TRANSACTION_ENTITIES_UPG

Line 273: xla_transaction_entities_upg te

269: xla_upgrade_dates gps,
270: ar_system_parameters_all sys,
271: ra_cust_trx_types_all tty,
272: ra_cust_trx_line_gl_dist_all ctlgd1,
273: xla_transaction_entities_upg te
274: WHERE ct.rowid >= l_start_rowid
275: AND ct.rowid <= l_end_rowid
276: AND NVL(ct.ax_accounted_flag,'N') = 'N'
277: AND ctlgd.customer_trx_id = ct.customer_trx_id

Line 378: xla_transaction_entities_upg te

374: xla_upgrade_dates gps,
375: ar_system_parameters_all sys,
376: ra_cust_trx_types_all tty,
377: ra_cust_trx_line_gl_dist_all ctlgd,
378: xla_transaction_entities_upg te
379: WHERE ct.rowid >= l_start_rowid
380: AND ct.rowid <= l_end_rowid
381: AND NVL(ct.ax_accounted_flag,'N') = 'N'
382: AND app.application_type = 'CM'

Line 727: xla_transaction_entities_upg ent,

723: from
724: ra_customer_trx_all ct,
725: ra_cust_trx_line_gl_dist_all ctlgd,
726: xla_upgrade_dates gps,
727: xla_transaction_entities_upg ent,
728: xla_events ev,
729: xla_ae_headers hdr,
730: ra_customer_trx_lines_all ctl
731: where ct.rowid >= l_start_rowid

Line 783: xla_transaction_entities_upg ent,

779: 2 ln_order
780: from ra_customer_trx_all ct,
781: ar_receivable_applications_all app,
782: xla_upgrade_dates gps,
783: xla_transaction_entities_upg ent,
784: xla_events ev,
785: xla_ae_headers hdr,
786: ar_distributions_all ard
787: where ct.rowid >= l_start_rowid

Line 1121: xla_transaction_entities_upg te

1117: xla_upgrade_dates gps,
1118: ar_transaction_history_all trh1,
1119: ar_system_parameters_all sys,
1120: ra_cust_trx_types_all tty,
1121: xla_transaction_entities_upg te
1122: WHERE ct.rowid >= l_start_rowid
1123: AND ct.rowid <= l_end_rowid
1124: AND NVL(ct.ax_accounted_flag,'N') = 'N'
1125: AND ct.customer_trx_id = trh.customer_trx_id

Line 1436: xla_transaction_entities_upg ent,

1432: 1 ln_order
1433: from ra_customer_trx_all ct,
1434: ar_transaction_history_all trh,
1435: xla_upgrade_dates gps,
1436: xla_transaction_entities_upg ent,
1437: xla_events ev,
1438: xla_ae_headers hdr,
1439: ar_distributions_all ard
1440: where ct.rowid >= l_start_rowid

Line 1789: xla_transaction_entities_upg te

1785: ar_cash_receipt_history_all crh,
1786: xla_upgrade_dates gps,
1787: ar_receipt_methods rmth,
1788: ar_cash_receipt_history_all crh1,
1789: xla_transaction_entities_upg te
1790: WHERE cr.rowid >= l_start_rowid
1791: AND cr.rowid <= l_end_rowid
1792: AND NVL(cr.ax_accounted_flag,'N') = 'N'
1793: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 1892: xla_transaction_entities_upg te

1888: ar_misc_cash_distributions_all mcd,
1889: xla_upgrade_dates gps,
1890: ar_receipt_methods rmth,
1891: ar_cash_receipt_history_all crh,
1892: xla_transaction_entities_upg te
1893: WHERE cr.rowid >= l_start_rowid
1894: AND cr.rowid <= l_end_rowid
1895: AND NVL(cr.ax_accounted_flag,'N') = 'N'
1896: AND cr.type='MISC'

Line 1993: xla_transaction_entities_upg te

1989: xla_upgrade_dates gps,
1990: ar_cash_receipt_history_all crh,
1991: ar_cash_receipt_history_all crh1,
1992: ar_receipt_methods rmth,
1993: xla_transaction_entities_upg te
1994: WHERE cr.rowid >= l_start_rowid
1995: AND cr.rowid <= l_end_rowid
1996: AND NVL(cr.ax_accounted_flag,'N') = 'N'
1997: AND app.cash_receipt_id = cr.cash_receipt_id

Line 2303: xla_transaction_entities_upg ent,

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,
2304: xla_events ev,
2305: xla_ae_headers hdr,
2306: ar_distributions_all ard
2307: where cr.rowid >= l_start_rowid

Line 2398: xla_transaction_entities_upg ent,

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,
2399: ar_cash_receipt_history_all crh,
2400: ar_cash_receipt_history_all crh1,
2401: xla_events ev,
2402: xla_ae_headers hdr,

Line 2476: xla_transaction_entities_upg ent,

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,
2477: xla_events ev,
2478: xla_ae_headers hdr,
2479: ar_distributions_all ard
2480: where cr.rowid >= l_start_rowid

Line 2794: xla_transaction_entities_upg te

2790: xla_upgrade_dates gps,
2791: ar_system_parameters_all sys,
2792: ra_customer_trx_all ct,
2793: ra_cust_trx_types_all tty,
2794: xla_transaction_entities_upg te
2795: WHERE adj.rowid >= l_start_rowid
2796: AND adj.rowid <= l_end_rowid
2797: AND NVL(adj.ax_accounted_flag,'N') = 'N'
2798: AND adj.customer_trx_id = ct.customer_trx_id

Line 3055: xla_transaction_entities_upg ent,

3051: hdr.ledger_id ledger_id,
3052: 1 ln_order
3053: from ar_adjustments_all adj,
3054: xla_upgrade_dates gps,
3055: xla_transaction_entities_upg ent,
3056: xla_events ev,
3057: xla_ae_headers hdr,
3058: ar_distributions_all ard
3059: where adj.rowid >= l_start_rowid

Line 3220: xla_transaction_entities_upg xte,

3216: update /*+ rowid(gir) */ gl_import_references gir
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,

Line 3271: xla_transaction_entities_upg xte,

3267: update /*+ rowid(gir) */ gl_import_references gir
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,

Line 3735: xla_transaction_entities_upg ent,

3731: nvl((select max(ae_line_num) from xla_ae_lines ael
3732: where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
3733: from ar_receivable_applications_all app,
3734: xla_upgrade_dates gps,
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,

Line 4066: xla_transaction_entities_upg te

4062: ar_cash_receipt_history_all crh,
4063: --xla_upgrade_dates gps,
4064: ar_receipt_methods rmth,
4065: ar_cash_receipt_history_all crh1,
4066: xla_transaction_entities_upg te
4067: WHERE NVL(cr.ax_accounted_flag,'N') = 'N'
4068: AND crh.cash_receipt_id = cr.cash_receipt_id
4069: and cr.cash_receipt_id = p_cash_receipt_id
4070: and not exists (select 1

Line 4187: xla_transaction_entities_upg te

4183: ar_misc_cash_distributions_all mcd,
4184: --xla_upgrade_dates gps,
4185: ar_receipt_methods rmth,
4186: ar_cash_receipt_history_all crh,
4187: xla_transaction_entities_upg te
4188: WHERE NVL(cr.ax_accounted_flag,'N') = 'N'
4189: AND cr.type='MISC'
4190: AND mcd.cash_receipt_id = cr.cash_receipt_id
4191: and cr.cash_receipt_id = p_cash_receipt_id

Line 4306: xla_transaction_entities_upg te

4302: -- xla_upgrade_dates gps,
4303: ar_cash_receipt_history_all crh,
4304: ar_cash_receipt_history_all crh1,
4305: ar_receipt_methods rmth,
4306: xla_transaction_entities_upg te
4307: WHERE NVL(cr.ax_accounted_flag,'N') = 'N'
4308: AND app.cash_receipt_id = cr.cash_receipt_id
4309: and cr.cash_receipt_id = p_cash_receipt_id
4310: and not exists (select 1

Line 4621: xla_transaction_entities_upg ent,

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,
4622: xla_events ev,
4623: xla_ae_headers hdr,
4624: ar_distributions_all ard
4625: where nvl(cr.ax_accounted_flag,'N') = 'N'

Line 4725: xla_transaction_entities_upg ent,

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,
4726: ar_cash_receipt_history_all crh,
4727: ar_cash_receipt_history_all crh1,
4728: xla_events ev,
4729: xla_ae_headers hdr,

Line 4812: xla_transaction_entities_upg ent,

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,
4813: xla_events ev,
4814: xla_ae_headers hdr,
4815: ar_distributions_all ard
4816: where nvl(cr.ax_accounted_flag,'N') = 'N'

Line 5082: xla_transaction_entities_upg ent,

5078: 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
5079: from ar_receivable_applications_all app,
5080: ar_system_parameters_all sys,
5081: xla_upgrade_dates gps,
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,