eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_CMN_TAXES_ALL

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

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

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

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

Line 1103: FROM JAI_RCV_TRANSACTIONS jrt, JAI_RCV_LINE_TAXES jrlt, jai_cmn_taxes_all jcta

1099: DECLARE
1100: /* cursor to fetch tax lines of shipment header id and shipment line id */
1101: CURSOR c_third_party_trans IS
1102: SELECT jrlt.transaction_id, jrlt.shipment_header_id, jrlt.shipment_line_id, jrlt.tax_type, jrlt.tax_amount, jcta.vat_flag, jcta.adhoc_flag, jcta.tax_name
1103: FROM JAI_RCV_TRANSACTIONS jrt, JAI_RCV_LINE_TAXES jrlt, jai_cmn_taxes_all jcta
1104: WHERE jrt.transaction_id = jrlt.transaction_id
1105: AND jrt.shipment_header_id = jrlt.shipment_header_id
1106: AND jrt.shipment_line_id = jrlt.shipment_line_id
1107: AND jrt.shipment_header_id = p_shipment_header_id

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

1390: , jcta.vat_flag -- for bug 13528285 by anupgupt
1391: , jcta.adhoc_flag -- for bug 13528285 by anupgupt
1392: FROM
1393: JAI_RCV_LINE_TAXES jrlt
1394: , jai_cmn_taxes_all jcta --added by eric for inclusive tax
1395: WHERE jrlt.shipment_header_id = p_shipment_header_id
1396: AND (jrlt.transaction_id, jrlt.shipment_header_id,jrlt.shipment_line_id) in /*modified for bug 8567640 */
1397: ( SELECT jrt.transaction_id,jrt.shipment_header_id,jrt.shipment_line_id
1398: FROM JAI_RCV_TRANSACTIONS jrt