DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_CMN_TAXES_ALL

Line 670: , jai_cmn_taxes_all jcta --added by eric for inclusive tax

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
674: from JAI_RCV_TRANSACTIONS jrt

Line 881: , jai_cmn_taxes_all jcta --added by eric for inclusive tax

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
885: from JAI_RCV_TRANSACTIONS jrt

Line 1278: , jai_cmn_taxes_all jcta --added by eric for inclusive tax

1274: jrlt.*
1275: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --added by eric for inclusive tax
1276: FROM
1277: JAI_RCV_LINE_TAXES jrlt
1278: , jai_cmn_taxes_all jcta --added by eric for inclusive tax
1279: WHERE jrlt.shipment_header_id = p_shipment_header_id
1280: AND (jrlt.transaction_id, jrlt.shipment_line_id) in
1281: ( SELECT jrt.transaction_id,jrt.shipment_line_id
1282: FROM JAI_RCV_TRANSACTIONS jrt