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_PO_HOOK_PKG dependencies on JAI_CMN_TAXES_ALL

Line 729: SELECT * FROM JAI_CMN_TAXES_ALL WHERE tax_id = cp_tax_id;

725: p_tot_quantity IN NUMBER
726: ) IS
727:
728: CURSOR c_tax_codes(cp_tax_id IN NUMBER) IS
729: SELECT * FROM JAI_CMN_TAXES_ALL WHERE tax_id = cp_tax_id;
730:
731: CURSOR c_conv_rate_rfq(cp_header_id IN NUMBER) IS
732: SELECT rate, currency_code
733: FROM po_headers_all

Line 1065: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl

1061: ) RETURN NUMBER IS
1062: /* Get the requisition tax amount for each requisition line currency code wise*/
1063: CURSOR c_reqn_tax_amt IS
1064: SELECT rtl.requisition_line_id, rtl.currency, rtl.tax_amount, nvl(tax.rounding_factor, 0) rnd_factor
1065: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl
1066: WHERE rtl.requisition_header_id = p_header_id
1067: AND (rtl.requisition_line_id = p_line_id OR p_line_id IS NULL)
1068: AND porl.requisition_line_id = rtl.requisition_line_id
1069: AND tax.tax_id = rtl.tax_id

Line 2121: , jai_cmn_taxes_all tax

2117: , rtl.tax_amount
2118: , NVL(tax.rounding_factor, 0) rnd_factor
2119: FROM
2120: jai_po_req_line_taxes rtl
2121: , jai_cmn_taxes_all tax
2122: , po_requisition_lines_all prla
2123: WHERE rtl.requisition_header_id = pn_header_id
2124: AND (rtl.requisition_line_id = pn_line_id OR pn_line_id IS NULL)
2125: AND prla.requisition_line_id = rtl.requisition_line_id

Line 2148: , jai_cmn_taxes_all jcta

2144: , jrlt.currency
2145: , SUM(jrlt.tax_amount) tax_amount
2146: FROM
2147: jai_rcv_line_taxes jrlt
2148: , jai_cmn_taxes_all jcta
2149: WHERE jrlt.shipment_header_id = pn_header_id
2150: AND (jrlt.shipment_line_id = pn_line_id OR pn_line_id IS NULL)
2151: AND jcta.tax_id = jrlt.tax_id
2152: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2174: , jai_cmn_taxes_all jcta

2170: , jpt.currency
2171: , SUM(jpt.tax_amount) tax_amount
2172: FROM
2173: jai_po_taxes jpt
2174: , jai_cmn_taxes_all jcta
2175: WHERE jpt.po_header_id = pn_header_id
2176: AND (jpt.line_location_id = pn_line_id OR pn_line_id IS NULL)
2177: AND jcta.tax_id = jpt.tax_id
2178: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2198: , jai_cmn_taxes_all jcta

2194: jamit.currency_code
2195: , SUM(jamit.tax_amount) tax_amount
2196: FROM
2197: jai_ap_match_inv_taxes jamit
2198: , jai_cmn_taxes_all jcta
2199: WHERE jamit.invoice_id = pn_header_id
2200: AND (jamit.parent_invoice_distribution_id = pn_line_id OR pn_line_id IS NULL)
2201: AND jcta.tax_id = jamit.tax_id
2202: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2225: , jai_cmn_taxes_all jcta

2221: jpt.currency
2222: , SUM(jpt.tax_amount) tax_amount
2223: FROM
2224: jai_po_taxes jpt
2225: , jai_cmn_taxes_all jcta
2226: WHERE jpt.line_location_id = pn_line_id
2227: AND jcta.tax_id = jpt.tax_id
2228: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag
2229: GROUP BY jpt.currency;

Line 2239: , jai_cmn_taxes_all jcta

2235: , SUM(jpt.tax_amount) tax_amount
2236: FROM
2237: jai_po_taxes jpt
2238: , po_line_locations_all plla
2239: , jai_cmn_taxes_all jcta
2240: WHERE plla.po_header_id = pn_header_id
2241: AND plla.po_release_id = pn_line_id
2242: AND jpt.po_header_id = plla.po_header_id
2243: AND jpt.po_line_id = plla.po_line_id

Line 2256: , jai_cmn_taxes_all jcta

2252: jpt.currency
2253: , SUM(jpt.tax_amount) tax_amount
2254: FROM
2255: jai_po_taxes jpt
2256: , jai_cmn_taxes_all jcta
2257: WHERE po_header_id = pn_header_id
2258: AND po_line_id = pn_line_id
2259: AND jcta.tax_id = jpt.tax_id
2260: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2275: , jai_cmn_taxes_all jcta

2271: , jcdt.currency_code
2272: , SUM(jcdt.tax_amt) tax_amount
2273: FROM
2274: jai_cmn_document_taxes jcdt
2275: , jai_cmn_taxes_all jcta
2276: WHERE jcdt.source_doc_line_id = cp_cmn_line_id
2277: AND jcdt.source_doc_type = cp_doc_type
2278: AND jcta.tax_id = jcdt.tax_id
2279: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2612: , jai_cmn_taxes_all jcta

2608: , jpt.currency
2609: , SUM(jpt.tax_amount) tax_amount
2610: FROM
2611: JAI_PO_TAXES jpt
2612: , jai_cmn_taxes_all jcta
2613: WHERE jpt.po_header_id = pn_header_id
2614: AND (jpt.line_location_id = pn_line_id OR pn_line_id IS NULL)
2615: AND jcta.tax_id = jpt.tax_id
2616: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2628: , jai_cmn_taxes_all jcta

2624: , SUM(jpt.tax_amount) tax_amount
2625: FROM
2626: JAI_PO_TAXES jpt
2627: , po_line_locations_all plla
2628: , jai_cmn_taxes_all jcta
2629: WHERE jpt.po_header_id = pn_header_id
2630: AND jpt.po_header_id = plla.po_header_id
2631: AND jpt.po_line_id = plla.po_line_id
2632: AND jpt.line_location_id = plla.line_location_id

Line 2648: , jai_cmn_taxes_all jcta

2644: , SUM(jpt.tax_amount) tax_amount
2645: FROM
2646: jai_po_taxes jpt
2647: , po_line_locations_all plla
2648: , jai_cmn_taxes_all jcta
2649: WHERE jpt.po_header_id = pn_header_id
2650: AND jpt.po_header_id = plla.po_header_id
2651: AND jpt.po_line_id = plla.po_line_id
2652: AND jpt.line_location_id = plla.line_location_id

Line 2676: , jai_cmn_taxes_all jcta

2672: jpt.currency
2673: , SUM(jpt.tax_amount) tax_amount
2674: FROM
2675: jai_po_taxes jpt
2676: , jai_cmn_taxes_all jcta
2677: WHERE jpt.line_location_id = pn_line_id
2678: AND jcta.tax_id = jpt.tax_id
2679: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag
2680: GROUP BY jpt.currency;

Line 2690: , jai_cmn_taxes_all jcta

2686: , SUM(jpt.tax_amount) tax_amount
2687: FROM
2688: jai_po_taxes jpt
2689: , po_line_locations_all plla
2690: , jai_cmn_taxes_all jcta
2691: WHERE plla.po_header_id = pn_header_id
2692: AND plla.po_release_id = pn_release_id
2693: AND (pn_line_id IS NULL OR plla.po_line_id = pn_line_id)
2694: AND jpt.po_header_id = plla.po_header_id

Line 2708: , jai_cmn_taxes_all jcta

2704: jpt.currency
2705: , SUM(jpt.tax_amount) tax_amount
2706: FROM
2707: jai_po_taxes jpt
2708: , jai_cmn_taxes_all jcta
2709: WHERE jpt.po_header_id = pn_header_id
2710: AND jpt.po_line_id = pn_line_id
2711: AND jcta.tax_id = jpt.tax_id
2712: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2724: , jai_cmn_taxes_all jcta

2720: FROM
2721: JAI_PO_TAXES jpt
2722: , po_line_locations_all plla
2723: , po_releases_all pra
2724: , jai_cmn_taxes_all jcta
2725: WHERE plla.po_header_id = pn_header_id
2726: AND plla.po_release_id IS NOT NULL
2727: AND jpt.po_header_id = plla.po_header_id
2728: AND jpt.po_line_id = plla.po_line_id