APPS.ARRX_BRS dependencies on AR_TRANSACTION_HISTORY_ALL

Line 239: FROM ar_transaction_history_all rah,

235: l_as_of_date := 'SELECT arl.meaning,
236: rah.trx_date,
237: rah.gl_date,
238: rah.status
239: FROM ar_transaction_history_all rah,
240: ar_lookups arl
241: WHERE arl.lookup_code = rah.status '||
242: l_org_where_rah ||
243: 'AND arl.lookup_type = ''TRANSACTION_HISTORY_STATUS'''||

Line 245: FROM ar_transaction_history_all rah1

241: WHERE arl.lookup_code = rah.status '||
242: l_org_where_rah ||
243: 'AND arl.lookup_type = ''TRANSACTION_HISTORY_STATUS'''||
244: 'AND rah.transaction_history_id = (SELECT MAX(rah1.transaction_history_id)
245: FROM ar_transaction_history_all rah1
246: WHERE rah1.trx_date <= to_char(:b_status_date) '||
247: l_org_where_rah1 ||
248: 'AND rah1.customer_trx_id = :b_trx_id)';
249:

Line 272: FROM ar_transaction_history_all rah

268: ,rabb.address_line3 remit_branch_address3
269: ,cba.check_digits
270: ,cba.currency_code remit_bank_acc_curr
271: ,rma.risk_elimination_days
272: FROM ar_transaction_history_all rah
273: ,ar_batches_all arb
274: ,ar_receipt_methods rm
275: ,ar_receipt_method_accounts rma
276: ,ce_bank_accounts cba

Line 289: FROM ar_transaction_history_all rah1

285: l_org_where_rah ||
286: l_org_where_arb ||
287: l_org_where_raba ||
288: 'AND rah.transaction_history_id = (SELECT max(rah1.transaction_history_id)
289: FROM ar_transaction_history_all rah1
290: WHERE rah1.trx_date <= to_char(:b_status_date) '||
291: l_org_where_rah1 ||
292: 'AND rah1.batch_id IS NOT NULL
293: AND rah1.customer_trx_id = :b_trx_id)';

Line 499: ,ar_transaction_history_all rah

495: ,ce_bank_acct_uses raba
496: ,ar_lookups arl
497: ,ar_lookups arl_class
498: ,ar_lookups arl_category
499: ,ar_transaction_history_all rah
500: ,fnd_document_sequences fds
501: ,ar_payment_schedules_all ps
502: ,ra_batches_all rab
503: ,ra_batch_sources_all rabs

Line 1178: FROM ar_transaction_history_all

1174: +------------------------------------------------------------------*/
1175:
1176: SELECT MIN(trx_date)
1177: INTO l_creation_gl_date
1178: FROM ar_transaction_history_all
1179: WHERE event = 'COMPLETED'
1180: AND customer_trx_id = v_customer_trx_id;
1181:
1182: SELECT MIN(maturity_date)

Line 1184: FROM ar_transaction_history_all

1180: AND customer_trx_id = v_customer_trx_id;
1181:
1182: SELECT MIN(maturity_date)
1183: INTO l_original_maturity_date
1184: FROM ar_transaction_history_all
1185: WHERE customer_trx_id = v_customer_trx_id
1186: AND status IN ('PENDING_REMITTANCE', 'PENDING_ACCEPTANCE')
1187: AND event = 'COMPLETED';
1188:

Line 1191: FROM ar_transaction_history_all

1187: AND event = 'COMPLETED';
1188:
1189: SELECT MAX(trx_date)
1190: INTO l_unpaid_date
1191: FROM ar_transaction_history_all
1192: WHERE status = 'UNPAID'
1193: AND customer_trx_id = v_customer_trx_id;
1194:
1195: SELECT MAX(trx_date)

Line 1197: FROM ar_transaction_history_all

1193: AND customer_trx_id = v_customer_trx_id;
1194:
1195: SELECT MAX(trx_date)
1196: INTO l_acceptance_date
1197: FROM ar_transaction_history_all
1198: WHERE event = 'ACCEPTED'
1199: AND customer_trx_id = v_customer_trx_id;
1200:
1201: SELECT MAX(trx_date)

Line 1203: FROM ar_transaction_history_all

1199: AND customer_trx_id = v_customer_trx_id;
1200:
1201: SELECT MAX(trx_date)
1202: INTO l_remit_date
1203: FROM ar_transaction_history_all
1204: WHERE batch_id IS NOT NULL
1205: AND customer_trx_id = v_customer_trx_id;
1206:
1207: