eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARRX_BRS dependencies on AR_TRANSACTION_HISTORY

Line 91: v_status_date AR_TRANSACTION_HISTORY.trx_date%TYPE;

87: v_Dummy_asg INTEGER;
88:
89: -- Declare the variables which will hold the results of the SELECT statements
90: v_status AR_LOOKUPS.meaning%TYPE;
91: v_status_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
92: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
93: v_transaction_number RA_CUSTOMER_TRX.trx_number%TYPE;
94: v_document_number RA_CUSTOMER_TRX.doc_sequence_value%TYPE;
95: v_document_sequence_name FND_DOCUMENT_SEQUENCES.name%TYPE;

Line 115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%TYPE;

111: v_drawee_class AR_LOOKUPS.meaning%TYPE;
112: v_drawee_category AR_LOOKUPS.meaning%TYPE;
113: v_drawee_location HZ_CUST_SITE_USES.location%TYPE;
114: v_issue_date RA_CUSTOMER_TRX.trx_date%TYPE;
115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%TYPE;
116: v_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
117: v_issued_by_drawee RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE;
118: v_signed_by_drawee RA_CUST_TRX_TYPES.signed_flag%TYPE;
119: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;

Line 161: v_remittance_date AR_TRANSACTION_HISTORY.trx_date%TYPE;

157: v_with_recourse AR_BATCHES.with_recourse_flag%TYPE;
158: v_last_printed_date RA_CUSTOMER_TRX.printing_last_printed%TYPE;
159: v_unpaid_receipt_rev_reason AR_LOOKUPS.meaning%TYPE;
160: v_risk_elimination_days AR_RECEIPT_METHOD_ACCOUNTS.risk_elimination_days%TYPE;
161: v_remittance_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
162: v_remittance_payment_method AR_RECEIPT_METHODS.name%TYPE;
163: v_creation_batch_name RA_BATCHES.name%TYPE;
164: v_drawee_address1 HZ_LOCATIONS.address1%TYPE;
165: v_drawee_address2 HZ_LOCATIONS.address2%TYPE;

Line 169: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;

165: v_drawee_address2 HZ_LOCATIONS.address2%TYPE;
166: v_drawee_address3 HZ_LOCATIONS.address3%TYPE;
167: v_drawee_contact VARCHAR2(100);
168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%TYPE;
169: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
170: v_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
171: v_functional_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
172: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;
173:

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: