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.AR_UPG_PSA_DIST_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 283: ra_customer_trx_all trx,

279: UNION ALL
280: SELECT 'C' AS flag FROM DUAL) a,
281: ar_adjustments_all b) doub,
282: psa_mf_trx_dist_all psatd,
283: ra_customer_trx_all trx,
284: ra_cust_trx_line_gl_dist_all ctlgd
285: WHERE adj.rowid >= l_start_rowid
286: AND adj.rowid <= l_end_rowid
287: AND adj.adjustment_id = psaadj.adjustment_id

Line 951: ra_customer_trx_all trx,

947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
950: SELECT 'C' side FROM DUAL ) doub,
951: ra_customer_trx_all trx,
952: ar_cash_receipt_history_all crh
953: WHERE app.rowid >= l_start_rowid
954: AND app.rowid <= l_end_rowid
955: AND app.receivable_application_id = a.receivable_application_id

Line 1399: FROM ra_customer_trx_all ct

1395: , MAX(ln.ae_line_num) OVER (PARTITION BY ln.ae_header_id) cnt_by_hdr
1396: , pd.cust_trx_line_gl_dist_id
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

Line 1523: FROM ra_customer_trx_all ct

1519: , 999999999 cnt_by_hdr
1520: , ctlgd.cust_trx_line_gl_dist_id
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