APPS.AR_UPG_PSA_DIST_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 517: ar_cash_receipt_history_all crh

513: FROM ar_receivable_applications_all app,
514: ar_distributions_all ard,
515: (SELECT 'CASH' side FROM DUAL UNION
516: SELECT 'APP' side FROM DUAL ) double,
517: ar_cash_receipt_history_all crh
518: WHERE app.rowid >= l_start_rowid
519: AND app.rowid <= l_end_rowid
520: AND app.receivable_application_id = ard.source_id
521: AND ard.source_table = 'RA'

Line 952: ar_cash_receipt_history_all crh

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
956: AND a.cust_trx_line_gl_dist_id = psatd.cust_trx_line_gl_dist_id

Line 1187: ar_cash_receipt_history_all crh,

1183: , NULL -- REF_DIST_CCID
1184: FROM ar_misc_cash_distributions_all mcd,
1185: psa_mf_misc_dist_all psamcd,
1186: ar_cash_receipts_all cr,
1187: ar_cash_receipt_history_all crh,
1188: ar_distributions_all crhard,
1189: (SELECT 'D' side FROM DUAL UNION ALL
1190: SELECT 'C' side FROM DUAL) doub
1191: WHERE mcd.rowid >= l_start_rowid