[Home] [Help]
704: - to_date(to_char(h_gl_date_low, 'DD-MM-YYYY'), 'DD-MM-YYYY') ) THEN
705:
706: select_trx_from :=
707: 'FROM fnd_currencies cy, ra_cust_trx_types types, ar_lookups lk, hz_cust_accounts c, hz_parties party '||
708: 'ar_vat_tax vat, ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, '||
709: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, hz_cust_acct_sites acct_site, '||
710: 'hz_party_sites party_site, hz_loc_assignments loc_assign, hz_locations loc, ' ||
711: 'hz_cust_site_uses su, ra_customer_trx othertrx, ra_cust_trx_line_gl_dist taxdist, '||
712: 'gl_code_combinations gltax, ra_cust_trx_line_gl_dist dist, '||
713: 'ra_customer_trx trx ';
714:
715: select_adj_from :=
716: 'FROM gl_code_combinations cc, ar_adjustments adj, hz_cust_accounts c, hz_parties party, ar_vat_tax vat, '||
717: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||
718: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ra_customer_trx trx, '||
719: 'hz_cust_site_uses su, hz_cust_acct_sites acct_site, ' ||
720: 'hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site ';
721: ELSE
720: 'hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site ';
721: ELSE
722: select_trx_from :=
723: 'FROM fnd_currencies cy, ra_cust_trx_types types, ar_lookups lk, hz_cust_accounts c, hz_parties party, '||
724: 'ar_vat_tax vat, ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, '||
725: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ' ||
726: ' hz_cust_acct_sites acct_site, hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site, '||
727: 'hz_cust_site_uses su, ra_customer_trx othertrx, ra_cust_trx_line_gl_dist taxdist, '||
728: 'gl_code_combinations gltax, '||
729: 'ra_customer_trx trx,ra_cust_trx_line_gl_dist dist ';
730:
731: select_adj_from :=
732: 'FROM hz_cust_accounts c, hz_parties party, ar_vat_tax vat, '||
733: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||
734: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ra_customer_trx trx, '||
735: 'hz_cust_site_uses su, hz_cust_acct_sites acct_site, hz_party_sites party_site, ' ||
736: 'hz_locations loc, hz_loc_assignments loc_assign, gl_code_combinations cc, ar_adjustments adj ';
737: END IF;
1611: where trx.customer_trx_id = fc_cust_trx_id
1612: and trx.line_type = 'LINE'
1613: and trx.customer_trx_line_id in
1614: ( select tax.link_to_cust_trx_line_id
1615: from ra_customer_trx_lines tax, ra_tax_exemptions ex
1616: where tax.customer_trx_id = fc_cust_trx_id
1617: and tax.line_type = 'TAX'
1618: and tax.tax_exemption_id = ex.tax_exemption_id
1619: and ex.status = fc_exemption_status );
1622: select sum(decode(tax.global_attribute_category, 'VERTEX', nvl(tax.global_attribute2, 0)
1623: + nvl(tax.global_attribute4, 0) + nvl(tax.global_attribute6, 0), 'AVP',
1624: nvl(tax.global_attribute2, 0) + nvl(tax.global_attribute4, 0) + nvl(tax.global_attribute6, 0),
1625: tax.extended_amount))
1626: from ra_customer_trx_lines tax, ra_tax_exemptions ex
1627: where tax.customer_trx_id = fc_cust_trx_id
1628: and tax.line_type = 'TAX'
1629: and tax.tax_exemption_id = ex.tax_exemption_id
1630: and ex.status = fc_exemption_status ;
2155: WHERE link_to_cust_trx_line_id = cus_trx_line_id
2156: AND line_type = 'TAX';
2157:
2158: cursor get_tax_exemption_rate is
2159: SELECT percent_exempt from ra_tax_exemptions
2160: WHERE tax_exemption_id = l_tax_exemption_id;
2161:
2162: BEGIN
2163: in_mesg := 'GET_EXEMPTION_AMT';