DBA Data[Home] [Help]

APPS.FV_APPLY_CASH_RECEIPT dependencies on RA_CUST_TRX_TYPES

Line 2688: --* : ra_cust_trx_types 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 *--
2692: --* : 3. For each of the receipt in the batch fv_ar_batches do the *--

Line 2838: ra_cust_trx_types rct,

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'
2842: AND aps.customer_id = NVL(c_cust_no,aps.customer_id)