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 AR_ADJUSTMENTS_ALL

Line 143: FROM ar_adjustments_all adj,

139: , ard.FROM_ACCTD_AMOUNT_DR
140: , ard.FROM_ACCTD_AMOUNT_CR
141: , ard.REF_MF_DIST_FLAG
142: , ard.REF_DIST_CCID
143: FROM ar_adjustments_all adj,
144: ar_distributions_all ard
145: WHERE adj.rowid >= l_start_rowid
146: AND adj.rowid <= l_end_rowid
147: AND ard.source_table = 'ADJ'

Line 271: ar_adjustments_all adj,

267: , NULL -- FROM_ACCTD_AMOUNT_CR
268: , NULL -- REF_MF_DIST_FLAG
269: , NULL -- REF_DIST_CCID
270: FROM
271: ar_adjustments_all adj,
272: psa_mf_adj_dist_all psaadj,
273: (SELECT a.flag side,
274: b.adjustment_id adj_id,
275: b.customer_trx_id customer_trx_id,

Line 281: ar_adjustments_all b) doub,

277: FROM
278: (SELECT 'D' AS flag FROM DUAL
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