DBA Data[Home] [Help]

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 1352: FROM ra_customer_trx_all ct

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

Line 1464: FROM ra_customer_trx_all ct

1460: , 999999999 cnt_by_hdr
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