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_RCV_LINE_TAXES

Line 464: from JAI_RCV_LINE_TAXES jrlt

460: p_po_vendor_id number
461: )
462: is
463: select count(jrlt.tax_line_no)
464: from JAI_RCV_LINE_TAXES jrlt
465: where jrlt.shipment_header_id = p_shipment_header_id
466: and EXISTS
467: (
468: select 1

Line 497: from JAI_RCV_LINE_TAXES jrlt

493: p_po_vendor_id number
494: )
495: is
496: select count(jrlt.tax_line_no)
497: from JAI_RCV_LINE_TAXES jrlt
498: where jrlt.shipment_header_id = p_shipment_header_id
499: and EXISTS
500: (
501: select 1

Line 531: from JAI_RCV_LINE_TAXES jrlt

527: p_po_vendor_id number
528: )
529: is
530: select count(jrlt.tax_line_no)
531: from JAI_RCV_LINE_TAXES jrlt
532: where jrlt.shipment_header_id = p_shipment_header_id
533: and EXISTS
534: (
535: select 1

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 1393: JAI_RCV_LINE_TAXES jrlt

1389: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --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