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.FV_APPLY_CASH_RECEIPT dependencies on RA_CUSTOMER_TRX

Line 37: invoice_number ra_customer_trx.trx_number%TYPE,

33: */
34:
35: TYPE CashReceiptApplicationsRec IS RECORD
36: (
37: invoice_number ra_customer_trx.trx_number%TYPE,
38: line_number ra_customer_trx_lines.line_number%TYPE,
39: invoice_type VARCHAR2(100),
40: applied_amount NUMBER,
41: applied_currency fnd_currencies_vl.name%TYPE,

Line 38: line_number ra_customer_trx_lines.line_number%TYPE,

34:
35: TYPE CashReceiptApplicationsRec IS RECORD
36: (
37: invoice_number ra_customer_trx.trx_number%TYPE,
38: line_number ra_customer_trx_lines.line_number%TYPE,
39: invoice_type VARCHAR2(100),
40: applied_amount NUMBER,
41: applied_currency fnd_currencies_vl.name%TYPE,
42: amt_applied_in_inv_curr NUMBER,

Line 128: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

124: TYPE ApplyCashRecType IS RECORD
125: (
126: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
127: receipt_number ar_cash_receipts.receipt_number%TYPE,
128: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
129: trx_number ra_customer_trx.trx_number%TYPE,
130: installment ar_payment_schedules.terms_sequence_number%TYPE,
131: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
132: amount_applied ar_receivable_applications.amount_applied%TYPE,

Line 129: trx_number ra_customer_trx.trx_number%TYPE,

125: (
126: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
127: receipt_number ar_cash_receipts.receipt_number%TYPE,
128: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
129: trx_number ra_customer_trx.trx_number%TYPE,
130: installment ar_payment_schedules.terms_sequence_number%TYPE,
131: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
132: amount_applied ar_receivable_applications.amount_applied%TYPE,
133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,

Line 141: line_number ra_customer_trx_lines.line_number%TYPE,

137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
139: org_id ar_receivable_applications.org_id%TYPE,
140: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE,
141: line_number ra_customer_trx_lines.line_number%TYPE,
142: show_closed_invoices VARCHAR2(100),
143: called_from VARCHAR2(100),
144: move_deferred_tax VARCHAR2(100),
145: link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE,

Line 2043: p_InvoiceNumber IN ra_customer_trx_all.trx_number%TYPE,

2039: PROCEDURE pay_the_invoice
2040: (
2041: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,
2042: p_CashReceiptId IN ar_cash_receipts.cash_receipt_id%TYPE,
2043: p_InvoiceNumber IN ra_customer_trx_all.trx_number%TYPE,
2044: p_LineNumber IN ra_customer_trx_lines_all.line_number%TYPE,
2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,

Line 2044: p_LineNumber IN ra_customer_trx_lines_all.line_number%TYPE,

2040: (
2041: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,
2042: p_CashReceiptId IN ar_cash_receipts.cash_receipt_id%TYPE,
2043: p_InvoiceNumber IN ra_customer_trx_all.trx_number%TYPE,
2044: p_LineNumber IN ra_customer_trx_lines_all.line_number%TYPE,
2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,

Line 2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,

2041: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,
2042: p_CashReceiptId IN ar_cash_receipts.cash_receipt_id%TYPE,
2043: p_InvoiceNumber IN ra_customer_trx_all.trx_number%TYPE,
2044: p_LineNumber IN ra_customer_trx_lines_all.line_number%TYPE,
2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,
2049: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,

Line 2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

2042: p_CashReceiptId IN ar_cash_receipts.cash_receipt_id%TYPE,
2043: p_InvoiceNumber IN ra_customer_trx_all.trx_number%TYPE,
2044: p_LineNumber IN ra_customer_trx_lines_all.line_number%TYPE,
2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,
2049: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2050: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,

Line 2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,

2044: p_LineNumber IN ra_customer_trx_lines_all.line_number%TYPE,
2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2048: p_InvoiceCurrencyCode IN ra_customer_trx_all.invoice_currency_code%TYPE,
2049: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2050: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2051: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2052: p_PaymentScheduleId IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 2112: FROM ra_customer_trx_lines ctl ,

2108: IF (p_InvoiceLineId IS NOT NULL ) THEN
2109: BEGIN
2110: SELECT ctl.extended_amount * nvl(tl.relative_amount,1)/ nvl(t.base_amount,1) original_line_amount
2111: INTO l_LineAmount
2112: FROM ra_customer_trx_lines ctl ,
2113: ra_terms t,
2114: ra_terms_lines tl,
2115: ar_payment_schedules ps
2116: WHERE ps.payment_schedule_id = p_PaymentScheduleId

Line 2130: p_ErrorLoc := 'SELECT ra_customer_trx_lines, ra_terms...';

2126: debug_msg (l_module_name, 'No Data Found for payment_schedule_id <'||p_PaymentScheduleId||'>');
2127: WHEN OTHERS THEN
2128: p_ErrorCode := g_FAILURE;
2129: p_ErrorDesc := SQLERRM;
2130: p_ErrorLoc := 'SELECT ra_customer_trx_lines, ra_terms...';
2131: error
2132: (
2133: p_error_type => p_ErrorCode,
2134: p_pgm => l_module_name,

Line 2417: --* Tables Used : ra_customer_trx SELECT *--

2413: --* : debug_init *--
2414: --* : debug_exit *--
2415: --* : error *--
2416: --* : log_msg *--
2417: --* Tables Used : ra_customer_trx SELECT *--
2418: --* : ar_payment_schedules SELECT *--
2419: --* : fv_finance_charge_controls SELECT *--
2420: --* Logic : 1. Loop and Process the following steps for every Debit Memos that *--
2421: --* : exist for the invoice (That are due) *--

Line 2436: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,

2432: PROCEDURE pay_debit_memos
2433: (
2434: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,
2435: p_CashReceiptId IN ar_cash_receipts_all.cash_receipt_id%TYPE,
2436: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2437: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2438: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2439: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2440: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,

Line 2470: FROM ra_customer_trx rct,

2466: aps.due_date,
2467: rct.trx_date invoice_date,
2468: rct.trx_number invoice_number,
2469: rct.invoice_currency_code
2470: FROM ra_customer_trx rct,
2471: ar_payment_schedules aps,
2472: fv_finance_charge_controls fcc
2473: WHERE rct.related_customer_trx_id = c_invoice_id
2474: AND aps.customer_trx_id = rct.customer_trx_id

Line 2684: --* : ra_customer_trx SELECT *--

2680: --* : debug_exit *--
2681: --* : error *--
2682: --* : log_msg *--
2683: --* Tables Used : fv_interim_cash_receipts SELECT *--
2684: --* : ra_customer_trx SELECT *--
2685: --* : ra_customer_trx_lines SELECT *--
2686: --* : ra_customers SELECT *--
2687: --* : ar_payment_schedules SELECT *--
2688: --* : ra_cust_trx_types SELECT *--

Line 2685: --* : ra_customer_trx_lines SELECT *--

2681: --* : error *--
2682: --* : log_msg *--
2683: --* Tables Used : fv_interim_cash_receipts SELECT *--
2684: --* : ra_customer_trx SELECT *--
2685: --* : ra_customer_trx_lines SELECT *--
2686: --* : ra_customers SELECT *--
2687: --* : ar_payment_schedules SELECT *--
2688: --* : ra_cust_trx_types SELECT *--
2689: --* Logic : 1. Write the Batch Information into the output report. *--

Line 2716: l_SiteUseId ra_customer_trx.bill_to_site_use_id%TYPE;

2712: p_ErrorLoc OUT NOCOPY VARCHAR2
2713: ) IS
2714: l_module_name VARCHAR2(30) := 'process_receipts';
2715:
2716: l_SiteUseId ra_customer_trx.bill_to_site_use_id%TYPE;
2717: l_CustomerNumber hz_parties.party_id%TYPE;
2718: l_RemainingReceiptAmount fv_interim_cash_receipts.amount%TYPE;
2719: l_CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE;
2720:

Line 2782: ra_customer_trx rct,

2778: rctl.line_number line_number,
2779: hzp.party_name,
2780: rctl.extended_amount line_amount
2781: FROM fv_interim_cash_receipts ficr,
2782: ra_customer_trx rct,
2783: ra_customer_trx_lines rctl,
2784: hz_parties hzp, hz_cust_accounts hzca
2785: WHERE ficr.batch_id = c_batch_id
2786: AND hzp.party_id = hzca.party_id

Line 2783: ra_customer_trx_lines rctl,

2779: hzp.party_name,
2780: rctl.extended_amount line_amount
2781: FROM fv_interim_cash_receipts ficr,
2782: ra_customer_trx rct,
2783: ra_customer_trx_lines rctl,
2784: hz_parties hzp, hz_cust_accounts hzca
2785: WHERE ficr.batch_id = c_batch_id
2786: AND hzp.party_id = hzca.party_id
2787: AND ficr.receipt_number = c_receipt_number

Line 2839: ra_customer_trx rac

2835: aps.trx_number invoice_number,
2836: rac.invoice_currency_code
2837: FROM ar_payment_schedules aps,
2838: ra_cust_trx_types rct,
2839: ra_customer_trx rac
2840: WHERE aps.amount_due_remaining > 0
2841: AND aps.status = 'OP'
2842: AND aps.customer_id = NVL(c_cust_no,aps.customer_id)
2843: AND aps.customer_trx_id = NVL(c_invoice_id,aps.customer_trx_id)