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 PSA_MF_TRX_DIST_ALL

Line 282: psa_mf_trx_dist_all psatd,

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
286: AND adj.rowid <= l_end_rowid

Line 944: psa_mf_trx_dist_all psatd,

940: , NULL -- REF_DIST_CCID
941: FROM
942: ar_receivable_applications_all app,
943: psa_mf_rct_dist_all a,
944: psa_mf_trx_dist_all psatd,
945: ra_cust_trx_line_gl_dist_all ctlgd,
946: (SELECT 'REC' source_type FROM DUAL UNION
947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,

Line 1407: , psa_mf_trx_dist_all pd

1403: , xla_events ev
1404: , xla_ae_headers hdr
1405: , xla_ae_lines ln
1406: , xla_distribution_links lnk
1407: , psa_mf_trx_dist_all pd
1408: WHERE pd.ROWID >= l_start_rowid
1409: AND pd.ROWID <= l_end_rowid
1410: AND ct.customer_trx_id = ctlgd.customer_trx_id
1411: AND ctlgd.cust_trx_line_gl_dist_id = pd.cust_trx_line_gl_dist_id

Line 1533: psa_mf_trx_dist_all pdist,

1529: , xla_ae_lines ln
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