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_PO_TAXES

Line 848: FROM JAI_PO_TAXES

844: ln_conv_rate := 1;
845: END IF;
846:
847: FOR j_po_ll_rec IN (SELECT *
848: FROM JAI_PO_TAXES
849: WHERE line_location_id = p_line_location_id)
850: LOOP
851: OPEN c_tax_codes(j_po_ll_rec.TAX_ID);
852: FETCH c_tax_codes

Line 919: 'JAI_PO_TAXES',

915: j_po_ll_rec.TAX_CATEGORY_ID,
916: 'ASBN',
917: p_hdr_intf_id,
918: p_cmn_line_id,
919: 'JAI_PO_TAXES',
920: r_taxes.adhoc_flag,
921: j_po_ll_rec.PRECEDENCE_1,
922: j_po_ll_rec.PRECEDENCE_2,
923: j_po_ll_rec.PRECEDENCE_3,

Line 1221: FROM JAI_PO_TAXES

1217: AND transaction_type = 'RECEIVE';
1218: /* Get the RFQ / PO / BPA tax amount for each line location currency code wise*/
1219: CURSOR c_po_rfq IS
1220: SELECT line_location_id, currency, SUM(tax_amount) tax_amount
1221: FROM JAI_PO_TAXES
1222: WHERE po_header_id = p_header_id
1223: AND (line_location_id = p_line_id OR p_line_id IS NULL)
1224: GROUP BY line_location_id, currency;
1225:

Line 1406: || we will get the details from the JAI_PO_TAXES table.

1402: IF p_document_Type = 'SHIPMENT' THEN
1403:
1404: /*
1405: || We would have got the po_header_id and line_location_id
1406: || we will get the details from the JAI_PO_TAXES table.
1407: */
1408:
1409: ln_tax_amt := 0;
1410:

Line 1412: FROM JAI_PO_TAXES

1408:
1409: ln_tax_amt := 0;
1410:
1411: FOR r_shipment_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1412: FROM JAI_PO_TAXES
1413: WHERE line_location_id = p_line_id
1414: GROUP BY currency)
1415: LOOP
1416:

Line 1443: FROM JAI_PO_TAXES a,

1439: || from the po_release_id we should get the line_location_id
1440: || for a release the po_line_locations_table will have all the details
1441: */
1442: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1443: FROM JAI_PO_TAXES a,
1444: po_line_locations_all b
1445: WHERE b.po_header_id = p_header_id
1446: AND b.po_release_id = p_line_id
1447: AND a.po_header_id = b.po_header_id

Line 1473: || we would get the tax amounts from the JAI_PO_TAXES table.

1469: ELSIF p_document_Type = 'PO_LINE' THEN
1470:
1471: /*
1472: || we would get the po_header_id and po_line_id
1473: || we would get the tax amounts from the JAI_PO_TAXES table.
1474: */
1475:
1476: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1477: FROM JAI_PO_TAXES a

Line 1477: FROM JAI_PO_TAXES a

1473: || we would get the tax amounts from the JAI_PO_TAXES table.
1474: */
1475:
1476: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1477: FROM JAI_PO_TAXES a
1478: WHERE po_header_id = p_header_id
1479: AND po_line_id = p_line_id
1480: GROUP BY currency)
1481: LOOP

Line 1782: FROM JAI_PO_TAXES

1778:
1779: /* Get the RFQ / PO / BPA tax amount for each line location currency code wise*/
1780: CURSOR c_po_rfq IS
1781: SELECT line_location_id, currency, SUM(tax_amount) tax_amount
1782: FROM JAI_PO_TAXES
1783: WHERE po_header_id = p_header_id
1784: AND (line_location_id = p_line_id OR p_line_id IS NULL)
1785: GROUP BY line_location_id, currency;
1786:

Line 1790: FROM JAI_PO_TAXES a,

1786:
1787: -- commented out by pramasub
1788: CURSOR c_po_ppo IS
1789: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1790: FROM JAI_PO_TAXES a,
1791: po_line_locations_all b
1792: WHERE a.po_header_id = p_header_id
1793: AND a.po_header_id = b.po_header_id
1794: AND a.po_line_id = b.po_line_id

Line 1802: FROM JAI_PO_TAXES a,

1798: GROUP BY a.line_location_id, a.currency;
1799:
1800: CURSOR c_po_bpa IS
1801: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1802: FROM JAI_PO_TAXES a,
1803: po_line_locations_all b
1804: WHERE a.po_header_id = p_header_id
1805: AND a.po_header_id = b.po_header_id
1806: AND a.po_line_id = b.po_line_id

Line 2080: || we will get the details from the JAI_PO_TAXES table.

2076: IF p_document_Type = 'SHIPMENT' THEN
2077:
2078: /*
2079: || We would have got the po_header_id and line_location_id
2080: || we will get the details from the JAI_PO_TAXES table.
2081: */
2082:
2083: ln_tax_amt := 0;
2084:

Line 2086: FROM JAI_PO_TAXES

2082:
2083: ln_tax_amt := 0;
2084:
2085: FOR r_shipment_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2086: FROM JAI_PO_TAXES
2087: WHERE line_location_id = p_line_id
2088: GROUP BY currency)
2089: LOOP
2090:

Line 2123: FROM JAI_PO_TAXES a,

2119: || from the po_release_id we should get the line_location_id
2120: || for a release the po_line_locations_table will have all the details
2121: */
2122: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2123: FROM JAI_PO_TAXES a,
2124: po_line_locations_all b
2125: WHERE b.po_header_id = p_header_id
2126: AND b.po_release_id = p_release_id
2127: AND (p_line_id IS NULL OR b.po_line_id = p_line_id)

Line 2165: FROM JAI_PO_TAXES a,

2161: || from the po_release_id we should get the line_location_id
2162: || for a release the po_line_locations_table will have all the details
2163: */
2164: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2165: FROM JAI_PO_TAXES a,
2166: po_line_locations_all b,
2167: po_releases_all c -- added by pramasub #6441185
2168: WHERE b.po_header_id = p_header_id
2169: AND b.po_release_id is not null

Line 2204: || we would get the tax amounts from the JAI_PO_TAXES table.

2200: ELSIF p_document_Type = 'PO_LINE' THEN
2201:
2202: /*
2203: || we would get the po_header_id and po_line_id
2204: || we would get the tax amounts from the JAI_PO_TAXES table.
2205: */
2206:
2207: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2208: FROM JAI_PO_TAXES a

Line 2208: FROM JAI_PO_TAXES a

2204: || we would get the tax amounts from the JAI_PO_TAXES table.
2205: */
2206:
2207: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2208: FROM JAI_PO_TAXES a
2209: WHERE po_header_id = p_header_id
2210: AND po_line_id = p_line_id
2211: GROUP BY currency)
2212: LOOP

Line 2375: jai_po_taxes jpt

2371: jpt.line_location_id
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

Line 2426: jai_po_taxes jpt

2422: SELECT
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

Line 2439: jai_po_taxes jpt

2435: SELECT
2436: jpt.currency
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

Line 2457: jai_po_taxes jpt

2453: SELECT
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

Line 2813: JAI_PO_TAXES jpt

2809: jpt.line_location_id
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

Line 2828: JAI_PO_TAXES jpt

2824: jpt.line_location_id
2825: , jpt.currency
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

Line 2848: jai_po_taxes jpt

2844: jpt.line_location_id
2845: , jpt.currency
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

Line 2877: jai_po_taxes jpt

2873: SELECT
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

Line 2890: jai_po_taxes jpt

2886: SELECT
2887: jpt.currency
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

Line 2909: jai_po_taxes jpt

2905: SELECT
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

Line 2923: JAI_PO_TAXES jpt

2919: SELECT
2920: jpt.currency
2921: , SUM(jpt.tax_amount) tax_amount
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