DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_LINE_TAXES

Line 443: from JAI_RCV_LINE_TAXES jrlt

439: p_po_vendor_id number
440: )
441: is
442: select count(jrlt.tax_line_no)
443: from JAI_RCV_LINE_TAXES jrlt
444: where jrlt.shipment_header_id = p_shipment_header_id
445: and EXISTS
446: (
447: select 1

Line 476: from JAI_RCV_LINE_TAXES jrlt

472: p_po_vendor_id number
473: )
474: is
475: select count(jrlt.tax_line_no)
476: from JAI_RCV_LINE_TAXES jrlt
477: where jrlt.shipment_header_id = p_shipment_header_id
478: and EXISTS
479: (
480: select 1

Line 510: from JAI_RCV_LINE_TAXES jrlt

506: p_po_vendor_id number
507: )
508: is
509: select count(jrlt.tax_line_no)
510: from JAI_RCV_LINE_TAXES jrlt
511: where jrlt.shipment_header_id = p_shipment_header_id
512: and EXISTS
513: (
514: select 1

Line 1277: JAI_RCV_LINE_TAXES jrlt

1273: ( SELECT
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