APPS.FV_APPLY_CASH_RECEIPT dependencies on RA_CUSTOMER_TRX_LINES

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 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 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 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 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 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 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