[Home] [Help]
43: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
44: v_transaction_type_id RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE;
45: v_status AR_LOOKUPS.meaning%TYPE;
46: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
47: v_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
48: v_balance_due NUMBER;
49: v_functional_balance_due NUMBER;
50: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
51: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;
46: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
47: v_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
48: v_balance_due NUMBER;
49: v_functional_balance_due NUMBER;
50: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
51: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;
52:
53: BEGIN
54:
107: ,ctt.cust_trx_type_id
108: ,rah.status
109: ,arl.meaning
110: FROM ra_cust_trx_types_all ctt
111: ,ra_customer_trx_all trx
112: ,ar_transaction_history_all rah
113: ,ar_lookups arl
114: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
115: AND rah.customer_trx_id = trx.customer_trx_id
134: ,nvl(ps.acctd_amount_due_remaining,0)
135: ,trx.customer_trx_id
136: ,ps.exchange_rate
137: FROM ra_cust_trx_types_all ctt
138: ,ra_customer_trx_all trx
139: ,ar_transaction_history_all rah
140: ,ar_payment_schedules_all ps
141: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
142: AND rah.customer_trx_id = trx.customer_trx_id
154: 'AND rah.status = :b_status_code '||
155: 'AND trx.cust_trx_type_id = :b_transaction_type_id ';
156:
157: l_applied := 'SELECT nvl(app.amount_applied,0)
158: FROM ra_customer_trx_all trx,
159: ar_payment_schedules_all ps,
160: ar_receivable_applications_all app
161: WHERE trx.customer_trx_id = ps.customer_trx_id
162: AND trx.customer_trx_id = app.applied_customer_trx_id