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_CUST_TRX_LINE_GL_DIST_ALL

Line 284: ra_cust_trx_line_gl_dist_all ctlgd

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
288: AND doub.adj_id = psaadj.adjustment_id

Line 945: ra_cust_trx_line_gl_dist_all ctlgd,

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,
949: (SELECT 'D' side FROM DUAL UNION

Line 1353: , ra_cust_trx_line_gl_dist_all ctlgd

1349: , pd.cust_trx_line_gl_dist_id
1350: , ln.accounting_date
1351: , ln.ledger_id
1352: FROM ra_customer_trx_all ct
1353: , ra_cust_trx_line_gl_dist_all ctlgd
1354: , xla_upgrade_dates gud
1355: , xla_transaction_entities_upg ent
1356: , xla_events ev
1357: , xla_ae_headers hdr

Line 1387: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1383: AND hdr.ae_header_id = lnk.ae_header_id
1384: AND ln.ae_line_num = lnk.ae_line_num
1385: AND lnk.event_id = ev.event_id
1386: AND lnk.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
1387: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1388: AND nvl(ent.source_id_int_1,-99) = ct.customer_trx_id
1389: AND ev.reference_num_1 = ctlgd.posting_control_id
1390: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date
1391: UNION

Line 1465: , ra_cust_trx_line_gl_dist_all ctlgd

1461: , ctlgd.cust_trx_line_gl_dist_id
1462: , ln.accounting_date
1463: , ln.ledger_id
1464: FROM ra_customer_trx_all ct
1465: , ra_cust_trx_line_gl_dist_all ctlgd
1466: , xla_upgrade_dates gud
1467: , xla_transaction_entities_upg ent
1468: , xla_events ev
1469: , xla_ae_headers hdr

Line 1473: FROM ra_cust_trx_line_gl_dist_all dist,

1469: , xla_ae_headers hdr
1470: , xla_ae_lines ln
1471: , xla_distribution_links lnk
1472: ,(SELECT /*+ rowid(pdist) use_nl(dist) no_merge */ dist.customer_trx_id
1473: FROM ra_cust_trx_line_gl_dist_all dist,
1474: psa_mf_trx_dist_all pdist
1475: WHERE pdist.cust_trx_line_gl_dist_id = dist.cust_trx_line_gl_dist_id
1476: AND pdist.ROWID >= l_start_rowid
1477: AND pdist.ROWID <= l_end_rowid

Line 1505: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1501: AND hdr.ae_header_id = lnk.ae_header_id
1502: AND ln.ae_line_num = lnk.ae_line_num
1503: AND lnk.event_id = ev.event_id
1504: AND lnk.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
1505: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1506: AND nvl(ent.source_id_int_1,-99) = ct.customer_trx_id
1507: AND ev.reference_num_1 = ctlgd.posting_control_id
1508: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date;
1509: