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 501: ,ar_transaction_history_all rah

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

Line 1183: FROM ar_transaction_history_all

1179: +------------------------------------------------------------------*/
1180:
1181: SELECT MIN(trx_date)
1182: INTO l_creation_gl_date
1183: FROM ar_transaction_history_all
1184: WHERE event = 'COMPLETED'
1185: AND customer_trx_id = v_customer_trx_id;
1186:
1187: SELECT MIN(maturity_date)

Line 1189: FROM ar_transaction_history_all

1185: AND customer_trx_id = v_customer_trx_id;
1186:
1187: SELECT MIN(maturity_date)
1188: INTO l_original_maturity_date
1189: FROM ar_transaction_history_all
1190: WHERE customer_trx_id = v_customer_trx_id
1191: AND status IN ('PENDING_REMITTANCE', 'PENDING_ACCEPTANCE')
1192: AND event = 'COMPLETED';
1193:

Line 1196: FROM ar_transaction_history_all

1192: AND event = 'COMPLETED';
1193:
1194: SELECT MAX(trx_date)
1195: INTO l_unpaid_date
1196: FROM ar_transaction_history_all
1197: WHERE status = 'UNPAID'
1198: AND customer_trx_id = v_customer_trx_id;
1199:
1200: SELECT MAX(trx_date)

Line 1202: FROM ar_transaction_history_all

1198: AND customer_trx_id = v_customer_trx_id;
1199:
1200: SELECT MAX(trx_date)
1201: INTO l_acceptance_date
1202: FROM ar_transaction_history_all
1203: WHERE event = 'ACCEPTED'
1204: AND customer_trx_id = v_customer_trx_id;
1205:
1206: SELECT MAX(trx_date)

Line 1208: FROM ar_transaction_history_all

1204: AND customer_trx_id = v_customer_trx_id;
1205:
1206: SELECT MAX(trx_date)
1207: INTO l_remit_date
1208: FROM ar_transaction_history_all
1209: WHERE batch_id IS NOT NULL
1210: AND customer_trx_id = v_customer_trx_id;
1211:
1212: