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 821: SELECT * FROM JAI_CMN_TAXES_ALL WHERE tax_id = cp_tax_id;

817: p_tot_quantity IN NUMBER
818: ) IS
819:
820: CURSOR c_tax_codes(cp_tax_id IN NUMBER) IS
821: SELECT * FROM JAI_CMN_TAXES_ALL WHERE tax_id = cp_tax_id;
822:
823: CURSOR c_conv_rate_rfq(cp_header_id IN NUMBER) IS
824: SELECT rate, currency_code
825: FROM po_headers_all

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

1176: ) RETURN NUMBER IS
1177: /* Get the requisition tax amount for each requisition line currency code wise*/
1178: CURSOR c_reqn_tax_amt IS
1179: SELECT rtl.requisition_line_id, rtl.currency, rtl.tax_amount, nvl(tax.rounding_factor, 0) rnd_factor
1180: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl
1181: WHERE rtl.requisition_header_id = p_header_id
1182: AND (rtl.requisition_line_id = p_line_id OR p_line_id IS NULL)
1183: AND porl.requisition_line_id = rtl.requisition_line_id
1184: /*Bug 14031501 - Added check on modified_by_agent_flag to exclude tax of the parent line in case Requisition has been split*/

Line 2309: , jai_cmn_taxes_all tax

2305: , rtl.tax_amount
2306: , NVL(tax.rounding_factor, 0) rnd_factor
2307: FROM
2308: jai_po_req_line_taxes rtl
2309: , jai_cmn_taxes_all tax
2310: , po_requisition_lines_all prla
2311: WHERE rtl.requisition_header_id = pn_header_id
2312: AND (rtl.requisition_line_id = pn_line_id OR pn_line_id IS NULL)
2313: AND prla.requisition_line_id = rtl.requisition_line_id

Line 2350: , jai_cmn_taxes_all jcta

2346: , jrlt.currency
2347: , SUM(jrlt.tax_amount) tax_amount
2348: FROM
2349: jai_rcv_line_taxes jrlt
2350: , jai_cmn_taxes_all jcta
2351: WHERE jrlt.shipment_header_id = pn_header_id
2352: AND (jrlt.shipment_line_id = pn_line_id OR pn_line_id IS NULL)
2353: AND jcta.tax_id = jrlt.tax_id
2354: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2376: , jai_cmn_taxes_all jcta

2372: , jpt.currency
2373: , SUM(jpt.tax_amount) tax_amount
2374: FROM
2375: jai_po_taxes jpt
2376: , jai_cmn_taxes_all jcta
2377: WHERE jpt.po_header_id = pn_header_id
2378: AND (jpt.line_location_id = pn_line_id OR pn_line_id IS NULL)
2379: AND jcta.tax_id = jpt.tax_id
2380: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2400: , jai_cmn_taxes_all jcta

2396: jamit.currency_code
2397: , SUM(jamit.tax_amount) tax_amount
2398: FROM
2399: jai_ap_match_inv_taxes jamit
2400: , jai_cmn_taxes_all jcta
2401: WHERE jamit.invoice_id = pn_header_id
2402: AND (jamit.parent_invoice_distribution_id = pn_line_id OR pn_line_id IS NULL)
2403: AND jcta.tax_id = jamit.tax_id
2404: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2427: , jai_cmn_taxes_all jcta

2423: jpt.currency
2424: , SUM(jpt.tax_amount) tax_amount
2425: FROM
2426: jai_po_taxes jpt
2427: , jai_cmn_taxes_all jcta
2428: WHERE jpt.line_location_id = pn_line_id
2429: AND jcta.tax_id = jpt.tax_id
2430: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag
2431: GROUP BY jpt.currency;

Line 2441: , jai_cmn_taxes_all jcta

2437: , SUM(jpt.tax_amount) tax_amount
2438: FROM
2439: jai_po_taxes jpt
2440: , po_line_locations_all plla
2441: , jai_cmn_taxes_all jcta
2442: WHERE plla.po_header_id = pn_header_id
2443: AND plla.po_release_id = pn_line_id
2444: AND jpt.po_header_id = plla.po_header_id
2445: AND jpt.po_line_id = plla.po_line_id

Line 2458: , jai_cmn_taxes_all jcta

2454: jpt.currency
2455: , SUM(jpt.tax_amount) tax_amount
2456: FROM
2457: jai_po_taxes jpt
2458: , jai_cmn_taxes_all jcta
2459: WHERE po_header_id = pn_header_id
2460: AND po_line_id = pn_line_id
2461: AND jcta.tax_id = jpt.tax_id
2462: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2477: , jai_cmn_taxes_all jcta

2473: , jcdt.currency_code
2474: , SUM(jcdt.tax_amt) tax_amount
2475: FROM
2476: jai_cmn_document_taxes jcdt
2477: , jai_cmn_taxes_all jcta
2478: WHERE jcdt.source_doc_line_id = cp_cmn_line_id
2479: AND jcdt.source_doc_type = cp_doc_type
2480: AND jcta.tax_id = jcdt.tax_id
2481: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2814: , jai_cmn_taxes_all jcta

2810: , jpt.currency
2811: , SUM(jpt.tax_amount) tax_amount
2812: FROM
2813: JAI_PO_TAXES jpt
2814: , jai_cmn_taxes_all jcta
2815: WHERE jpt.po_header_id = pn_header_id
2816: AND (jpt.line_location_id = pn_line_id OR pn_line_id IS NULL)
2817: AND jcta.tax_id = jpt.tax_id
2818: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2830: , jai_cmn_taxes_all jcta

2826: , SUM(jpt.tax_amount) tax_amount
2827: FROM
2828: JAI_PO_TAXES jpt
2829: , po_line_locations_all plla
2830: , jai_cmn_taxes_all jcta
2831: WHERE jpt.po_header_id = pn_header_id
2832: AND jpt.po_header_id = plla.po_header_id
2833: AND jpt.po_line_id = plla.po_line_id
2834: AND jpt.line_location_id = plla.line_location_id

Line 2850: , jai_cmn_taxes_all jcta

2846: , SUM(jpt.tax_amount) tax_amount
2847: FROM
2848: jai_po_taxes jpt
2849: , po_line_locations_all plla
2850: , jai_cmn_taxes_all jcta
2851: WHERE jpt.po_header_id = pn_header_id
2852: AND jpt.po_header_id = plla.po_header_id
2853: AND jpt.po_line_id = plla.po_line_id
2854: AND jpt.line_location_id = plla.line_location_id

Line 2878: , jai_cmn_taxes_all jcta

2874: jpt.currency
2875: , SUM(jpt.tax_amount) tax_amount
2876: FROM
2877: jai_po_taxes jpt
2878: , jai_cmn_taxes_all jcta
2879: WHERE jpt.line_location_id = pn_line_id
2880: AND jcta.tax_id = jpt.tax_id
2881: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag
2882: GROUP BY jpt.currency;

Line 2892: , jai_cmn_taxes_all jcta

2888: , SUM(jpt.tax_amount) tax_amount
2889: FROM
2890: jai_po_taxes jpt
2891: , po_line_locations_all plla
2892: , jai_cmn_taxes_all jcta
2893: WHERE plla.po_header_id = pn_header_id
2894: AND plla.po_release_id = pn_release_id
2895: AND (pn_line_id IS NULL OR plla.po_line_id = pn_line_id)
2896: AND jpt.po_header_id = plla.po_header_id

Line 2910: , jai_cmn_taxes_all jcta

2906: jpt.currency
2907: , SUM(jpt.tax_amount) tax_amount
2908: FROM
2909: jai_po_taxes jpt
2910: , jai_cmn_taxes_all jcta
2911: WHERE jpt.po_header_id = pn_header_id
2912: AND jpt.po_line_id = pn_line_id
2913: AND jcta.tax_id = jpt.tax_id
2914: AND NVL(jcta.inclusive_tax_flag, 'N') = pv_inclusive_tax_flag

Line 2926: , jai_cmn_taxes_all jcta

2922: FROM
2923: JAI_PO_TAXES jpt
2924: , po_line_locations_all plla
2925: , po_releases_all pra
2926: , jai_cmn_taxes_all jcta
2927: WHERE plla.po_header_id = pn_header_id
2928: AND plla.po_release_id IS NOT NULL
2929: AND jpt.po_header_id = plla.po_header_id
2930: AND jpt.po_line_id = plla.po_line_id