DBA Data[Home] [Help]

APPS.AR_UPG_PSA_DIST_PKG dependencies on XLA_UPGRADE_DATES

Line 1401: , xla_upgrade_dates gud

1397: , ln.accounting_date
1398: , ln.ledger_id
1399: FROM ra_customer_trx_all ct
1400: , ra_cust_trx_line_gl_dist_all ctlgd
1401: , xla_upgrade_dates gud
1402: , xla_transaction_entities_upg ent
1403: , xla_events ev
1404: , xla_ae_headers hdr
1405: , xla_ae_lines ln

Line 1525: , xla_upgrade_dates gud

1521: , ln.accounting_date
1522: , ln.ledger_id
1523: FROM ra_customer_trx_all ct
1524: , ra_cust_trx_line_gl_dist_all ctlgd
1525: , xla_upgrade_dates gud
1526: , xla_transaction_entities_upg ent
1527: , xla_events ev
1528: , xla_ae_headers hdr
1529: , xla_ae_lines ln

Line 1534: xla_upgrade_dates xud

1530: , xla_distribution_links lnk
1531: ,(SELECT /*+ rowid(pdist) use_nl(dist) no_merge */ dist.customer_trx_id
1532: FROM ra_cust_trx_line_gl_dist_all dist,
1533: psa_mf_trx_dist_all pdist,
1534: xla_upgrade_dates xud
1535: WHERE pdist.cust_trx_line_gl_dist_id = dist.cust_trx_line_gl_dist_id
1536: AND trunc(dist.gl_date) between xud.start_date and xud.end_date
1537: AND pdist.ROWID >= l_start_rowid
1538: AND pdist.ROWID <= l_end_rowid