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 FV_INTERIM_CASH_RECEIPTS

Line 53: receipt_number fv_interim_cash_receipts.receipt_number%TYPE,

49: TYPE CashReceiptApplicationsTbl IS TABLE OF CashReceiptApplicationsRec INDEX BY BINARY_INTEGER;
50:
51: TYPE CashReceiptRec IS RECORD
52: (
53: receipt_number fv_interim_cash_receipts.receipt_number%TYPE,
54: customer_name hz_parties.party_name%TYPE,
55: receipt_amount fv_interim_cash_receipts.amount%TYPE,
56: applied_currency fnd_currencies_vl.name%TYPE,
57: actual_amount NUMBER,

Line 55: receipt_amount fv_interim_cash_receipts.amount%TYPE,

51: TYPE CashReceiptRec IS RECORD
52: (
53: receipt_number fv_interim_cash_receipts.receipt_number%TYPE,
54: customer_name hz_parties.party_name%TYPE,
55: receipt_amount fv_interim_cash_receipts.amount%TYPE,
56: applied_currency fnd_currencies_vl.name%TYPE,
57: actual_amount NUMBER,
58: actual_currency fnd_currencies_vl.name%TYPE,
59: total_applications NUMBER,

Line 2041: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,

2037: --* Logic : . *--
2038: --****************************************************************************************--
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,

Line 2047: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%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,
2051: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,

Line 2434: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,

2430: --* : 7. Populate the Report Varaibles for output *--
2431: --****************************************************************************************--
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,

Line 2437: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,

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,
2441: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,

Line 2683: --* Tables Used : fv_interim_cash_receipts SELECT *--

2679: --* : debug_init *--
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 *--

Line 2718: l_RemainingReceiptAmount fv_interim_cash_receipts.amount%TYPE;

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:
2721: l_CreateCashRec CreateCashRecType;
2722: l_NullCreateCashRec CreateCashRecType;

Line 2737: FROM fv_interim_cash_receipts ficr,

2733: hzp.party_name customer_name,
2734: trunc(ficr.receipt_date) receipt_date,
2735: ficr.site_use_id,
2736: sum(ficr.amount) amount
2737: FROM fv_interim_cash_receipts ficr,
2738: hz_parties hzp, hz_cust_accounts hzca
2739: WHERE ficr.batch_id = c_batch_id
2740: AND hzp.party_id = hzca.party_id
2741: AND ficr.customer_id = hzca.cust_account_id

Line 2781: FROM fv_interim_cash_receipts ficr,

2777: rct.exchange_rate_type invoice_exchange_rate_type,
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