[Home] [Help]
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,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%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,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%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,
2053: p_InvoiceAmount IN NUMBER,
2054: p_InvoiceLineAmount IN NUMBER,
2055: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,
2056: p_GLDate IN DATE,
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
2117: AND ctl.customer_trx_id = p_InvoiceId
2118: AND ctl.line_type = 'LINE'
2119: AND tl.term_id(+) = ps.term_id
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) *--
2422: --* : 2. If the debit memo was procesed earlier using the same cash *--
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
2475: AND rct.interface_header_attribute3 = fcc.charge_type
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. *--
2690: --* : 2. Insert the fv_ar_batch details into the table ar_batches by *--
2691: --* : calling the procedure insert_ar_batch *--
2833: aps.cust_trx_type_id,
2834: aps.due_date,
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'