DBA Data[Home] [Help]

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