DBA Data[Home] [Help]

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 1360: , psa_mf_trx_dist_all pd

1356: , xla_events ev
1357: , xla_ae_headers hdr
1358: , xla_ae_lines ln
1359: , xla_distribution_links lnk
1360: , psa_mf_trx_dist_all pd
1361: WHERE pd.ROWID >= l_start_rowid
1362: AND pd.ROWID <= l_end_rowid
1363: AND ct.customer_trx_id = ctlgd.customer_trx_id
1364: AND ctlgd.cust_trx_line_gl_dist_id = pd.cust_trx_line_gl_dist_id

Line 1474: psa_mf_trx_dist_all pdist

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
1478: GROUP BY dist.customer_trx_id