DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_TAX_V

Line 711: JAI_RCV_TAX_V jrtv

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

Line 922: JAI_RCV_TAX_V jrtv

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