[Home] [Help]
597: h_gl_date_high := gl_date_high;
598: if gl_date_low is null then
599: select min(gl_date)
600: into gl_date_low_1
601: from ra_cust_trx_line_gl_dist;
602:
603: if trx_date_low_2 is null then
604: select nvl(min(gl_date), gl_date_low_1)
605: into gl_date_low_2
615:
616: if gl_date_high is null then
617: select max(gl_date)
618: into gl_date_high_1
619: from ra_cust_trx_line_gl_dist;
620:
621: if trx_date_high_2 is null then
622: select nvl(max(gl_date), gl_date_high_1)
623: into gl_date_high_2
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 :=
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, '||
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 :=
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, '||
1827: BEGIN
1828: if c_detail_level = 'RX_LINE' then
1829: select min(decode(taxdist.code_combination_id,null,'N','Y'))
1830: into warn_gltax_range
1831: from ra_cust_trx_line_gl_dist taxdist, gl_code_combinations cc
1832: where customer_trx_line_id = c_trx_id
1833: AND taxdist.code_combination_id = cc.code_combination_id;
1834: if warn_gltax_range is null then
1835: warn_gltax_range := 'N';
1836: end if;
1837: else
1838: select min(decode(taxdist.code_combination_id,null,'N','Y'))
1839: into warn_gltax_range
1840: from ra_cust_trx_line_gl_dist taxdist, gl_code_combinations cc,
1841: ra_customer_trx trx, ra_customer_trx_lines tax
1842: where taxdist.customer_trx_line_id = tax.customer_trx_line_id
1843: AND tax.line_type = 'TAX'
1844: AND trx.customer_trx_id = tax.customer_trx_id