707: IS
708: select
709: sum(nvl(jrtv.tax_amount,0)) totl_incl_tax_amount
710: from
711: JAI_RCV_TAX_V jrtv
712: , jai_cmn_taxes_all jcta --added by eric for inclusive tax
713: where
714: ( jrtv.transaction_id, jrtv.shipment_line_id ) IN
715: ( select transaction_id, shipment_line_id
918: , sum(nvl(jrtv.tax_amount,0)) tax_amount
919: --, nvl(jcta.inclusive_tax_flag,'N') inc_tax_flag --added by eric for inclusive tax
920: , MAX(NVL(jcta.inclusive_tax_flag,'N')) inc_tax_flag --modified by eric for bug#6997730 on Apr-24,2008
921: from
922: JAI_RCV_TAX_V jrtv
923: , jai_cmn_taxes_all jcta --added by eric for inclusive tax
924: where
925: ( jrtv.transaction_id, jrtv.shipment_line_id ) IN
926: ( select transaction_id, shipment_line_id