[Home] [Help]
29: l_some_result BOOLEAN;
30:
31: l_some_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
32: l_some_trx_amount ra_cust_trx_line_gl_dist.amount%type;
33: l_some_ictli ra_customer_trx_lines.initial_customer_trx_line_id%type;
34: l_some_in_use_before varchar2(1);
35: l_some_in_use_after varchar2(1);
36:
37: l_old_tax_amount number;
51: l_some_trx_id := p_customer_trx_id;
52:
53: select sum(extended_amount), count(l.customer_trx_line_id), max(l.customer_trx_line_id)
54: into l_old_tax_amount, l_old_tax_lines, l_max_cust_trx_line_id
55: from ra_customer_trx_lines l
56: where l.customer_trx_id = l_some_trx_id
57: and line_type = 'TAX'
58: and l.autotax = 'Y'
59: and l.customer_trx_id = p_customer_trx_id
98: +------------------------------------------------*/
99:
100: select sum(extended_amount), count(l.customer_trx_line_id), min(l.customer_trx_line_id)
101: into l_new_tax_amount, l_new_tax_lines, l_min_cust_trx_line_id
102: from ra_customer_trx_lines l
103: where l.customer_trx_id = l_some_trx_id
104: and l.line_type = 'TAX'
105: and l.autotax = 'Y'
106: and l.customer_trx_id = p_customer_trx_id
167: count( tax.customer_trx_line_id) count_tax
168: from ra_customer_trx t,
169: ra_cust_trx_types y,
170: ra_customer_trx p,
171: ra_customer_trx_lines l,
172: ra_customer_trx_lines tax,
173: ar_vat_tax vat,
174: hz_cust_acct_sites sa,
175: hz_cust_site_uses sus
168: from ra_customer_trx t,
169: ra_cust_trx_types y,
170: ra_customer_trx p,
171: ra_customer_trx_lines l,
172: ra_customer_trx_lines tax,
173: ar_vat_tax vat,
174: hz_cust_acct_sites sa,
175: hz_cust_site_uses sus
176: where t.customer_trx_id = l.customer_trx_id
179: and t.previous_customer_trx_id = p.customer_trx_id(+)
180: and t.cust_trx_type_id = y.cust_trx_type_id
181: and nvl( t.ship_to_site_use_id, t.bill_to_site_use_id) = sus.site_use_id
182: and sa.cust_acct_site_id = sus.cust_acct_site_id
183: and t.customer_trx_id not in ( select customer_trx_id from ra_customer_trx_lines where line_type = 'TAX'
184: and nvl(autotax,'N') = 'N' and customer_trx_id = t.customer_trx_id )
185: group by t.customer_trx_id, t.trx_number, t.trx_date
186: order by t.trx_number;
187:
254: sum(decode( t.invoice_currency_code, 'USD', 1, t.exchange_rate )*l.extended_amount )
255: trx_acctd_amount,
256: sum(d.percent) percent,
257: t.invoice_currency_code invoice_currency_code
258: FROM ra_customer_trx_lines l,
259: ra_cust_trx_line_gl_dist d,
260: ra_customer_trx t
261: WHERE l.customer_trx_line_id = d.customer_trx_line_id
262: AND l.customer_trx_id = p_customer_trx_id
284: to_char(NULL) invoice_currency_code
285: FROM ra_cust_trx_line_gl_dist d
286: WHERE d.customer_trx_id = p_customer_trx_id
287: AND d.account_set_flag = 'N'
288: AND not exists ( select 'x' from ra_customer_trx_lines l
289: where l.customer_trx_id = d.customer_trx_id )
290: GROUP BY d.customer_trx_line_id, d.customer_trx_id;
291:
292: