|
select line.business_unit,
line.invoice,
line.line_seq_num,
line.tax_cd,
taxauth.tax_pct,
taxauth.tax_authority_cd
from PS_BI_LINE line,
ps_tax_cd tax,
ps_tax_authority taxauth
where tax.setid =
(select DISTINCT setid
from ps_set_cntrl_rec
where setcntrlvalue = line.business_unit
and recname = 'TAX_CD')
and taxauth.setid = tax.setid
and tax.tax_authority_cd = taxauth.tax_authority_cd
and line.tax_cd = tax.tax_cd
and taxauth.effdt =
(select max(effdt) from ps_tax_authority
where setid = taxauth.setid
and tax_authority_cd = taxauth.tax_authority_cd
and effdt <= %currentdatein)
and taxauth.eff_status = 'A'
|
BUSINESS_UNIT