DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_TAX_V

Line 669: JAI_RCV_TAX_V jrtv

665: IS
666: select
667: sum(nvl(jrtv.tax_amount,0)) totl_incl_tax_amount
668: from
669: JAI_RCV_TAX_V jrtv
670: , jai_cmn_taxes_all jcta --added by eric for inclusive tax
671: where
672: ( jrtv.transaction_id, jrtv.shipment_line_id ) IN
673: ( select transaction_id, shipment_line_id

Line 880: JAI_RCV_TAX_V jrtv

876: , sum(nvl(jrtv.tax_amount,0)) tax_amount
877: --, nvl(jcta.inclusive_tax_flag,'N') inc_tax_flag --added by eric for inclusive tax
878: , MAX(NVL(jcta.inclusive_tax_flag,'N')) inc_tax_flag --modified by eric for bug#6997730 on Apr-24,2008
879: from
880: JAI_RCV_TAX_V jrtv
881: , jai_cmn_taxes_all jcta --added by eric for inclusive tax
882: where
883: ( jrtv.transaction_id, jrtv.shipment_line_id ) IN
884: ( select transaction_id, shipment_line_id