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 756: FROM JAI_PO_TAXES

752: ln_conv_rate := 1;
753: END IF;
754:
755: FOR j_po_ll_rec IN (SELECT *
756: FROM JAI_PO_TAXES
757: WHERE line_location_id = p_line_location_id)
758: LOOP
759: OPEN c_tax_codes(j_po_ll_rec.TAX_ID);
760: FETCH c_tax_codes

Line 827: 'JAI_PO_TAXES',

823: j_po_ll_rec.TAX_CATEGORY_ID,
824: 'ASBN',
825: p_hdr_intf_id,
826: p_cmn_line_id,
827: 'JAI_PO_TAXES',
828: r_taxes.adhoc_flag,
829: j_po_ll_rec.PRECEDENCE_1,
830: j_po_ll_rec.PRECEDENCE_2,
831: j_po_ll_rec.PRECEDENCE_3,

Line 1092: FROM JAI_PO_TAXES

1088: AND transaction_type = 'RECEIVE';
1089: /* Get the RFQ / PO / BPA tax amount for each line location currency code wise*/
1090: CURSOR c_po_rfq IS
1091: SELECT line_location_id, currency, SUM(tax_amount) tax_amount
1092: FROM JAI_PO_TAXES
1093: WHERE po_header_id = p_header_id
1094: AND (line_location_id = p_line_id OR p_line_id IS NULL)
1095: GROUP BY line_location_id, currency;
1096:

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

1273: IF p_document_Type = 'SHIPMENT' THEN
1274:
1275: /*
1276: || We would have got the po_header_id and line_location_id
1277: || we will get the details from the JAI_PO_TAXES table.
1278: */
1279:
1280: ln_tax_amt := 0;
1281:

Line 1283: FROM JAI_PO_TAXES

1279:
1280: ln_tax_amt := 0;
1281:
1282: FOR r_shipment_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1283: FROM JAI_PO_TAXES
1284: WHERE line_location_id = p_line_id
1285: GROUP BY currency)
1286: LOOP
1287:

Line 1314: FROM JAI_PO_TAXES a,

1310: || from the po_release_id we should get the line_location_id
1311: || for a release the po_line_locations_table will have all the details
1312: */
1313: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1314: FROM JAI_PO_TAXES a,
1315: po_line_locations_all b
1316: WHERE b.po_header_id = p_header_id
1317: AND b.po_release_id = p_line_id
1318: AND a.po_header_id = b.po_header_id

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

1340: ELSIF p_document_Type = 'PO_LINE' THEN
1341:
1342: /*
1343: || we would get the po_header_id and po_line_id
1344: || we would get the tax amounts from the JAI_PO_TAXES table.
1345: */
1346:
1347: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1348: FROM JAI_PO_TAXES a

Line 1348: FROM JAI_PO_TAXES a

1344: || we would get the tax amounts from the JAI_PO_TAXES table.
1345: */
1346:
1347: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1348: FROM JAI_PO_TAXES a
1349: WHERE po_header_id = p_header_id
1350: AND po_line_id = p_line_id
1351: GROUP BY currency)
1352: LOOP

Line 1645: FROM JAI_PO_TAXES

1641:
1642: /* Get the RFQ / PO / BPA tax amount for each line location currency code wise*/
1643: CURSOR c_po_rfq IS
1644: SELECT line_location_id, currency, SUM(tax_amount) tax_amount
1645: FROM JAI_PO_TAXES
1646: WHERE po_header_id = p_header_id
1647: AND (line_location_id = p_line_id OR p_line_id IS NULL)
1648: GROUP BY line_location_id, currency;
1649:

Line 1653: FROM JAI_PO_TAXES a,

1649:
1650: -- commented out by pramasub
1651: CURSOR c_po_ppo IS
1652: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1653: FROM JAI_PO_TAXES a,
1654: po_line_locations_all b
1655: WHERE a.po_header_id = p_header_id
1656: AND a.po_header_id = b.po_header_id
1657: AND a.po_line_id = b.po_line_id

Line 1665: FROM JAI_PO_TAXES a,

1661: GROUP BY a.line_location_id, a.currency;
1662:
1663: CURSOR c_po_bpa IS
1664: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1665: FROM JAI_PO_TAXES a,
1666: po_line_locations_all b
1667: WHERE a.po_header_id = p_header_id
1668: AND a.po_header_id = b.po_header_id
1669: AND a.po_line_id = b.po_line_id

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

1888: IF p_document_Type = 'SHIPMENT' THEN
1889:
1890: /*
1891: || We would have got the po_header_id and line_location_id
1892: || we will get the details from the JAI_PO_TAXES table.
1893: */
1894:
1895: ln_tax_amt := 0;
1896:

Line 1898: FROM JAI_PO_TAXES

1894:
1895: ln_tax_amt := 0;
1896:
1897: FOR r_shipment_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1898: FROM JAI_PO_TAXES
1899: WHERE line_location_id = p_line_id
1900: GROUP BY currency)
1901: LOOP
1902:

Line 1935: FROM JAI_PO_TAXES a,

1931: || from the po_release_id we should get the line_location_id
1932: || for a release the po_line_locations_table will have all the details
1933: */
1934: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1935: FROM JAI_PO_TAXES a,
1936: po_line_locations_all b
1937: WHERE b.po_header_id = p_header_id
1938: AND b.po_release_id = p_release_id
1939: AND (p_line_id IS NULL OR b.po_line_id = p_line_id)

Line 1977: FROM JAI_PO_TAXES a,

1973: || from the po_release_id we should get the line_location_id
1974: || for a release the po_line_locations_table will have all the details
1975: */
1976: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1977: FROM JAI_PO_TAXES a,
1978: po_line_locations_all b,
1979: po_releases_all c -- added by pramasub #6441185
1980: WHERE b.po_header_id = p_header_id
1981: AND b.po_release_id is not null

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

2012: ELSIF p_document_Type = 'PO_LINE' THEN
2013:
2014: /*
2015: || we would get the po_header_id and po_line_id
2016: || we would get the tax amounts from the JAI_PO_TAXES table.
2017: */
2018:
2019: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2020: FROM JAI_PO_TAXES a

Line 2020: FROM JAI_PO_TAXES a

2016: || we would get the tax amounts from the JAI_PO_TAXES table.
2017: */
2018:
2019: FOR r_po_line_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2020: FROM JAI_PO_TAXES a
2021: WHERE po_header_id = p_header_id
2022: AND po_line_id = p_line_id
2023: GROUP BY currency)
2024: LOOP

Line 2173: jai_po_taxes jpt

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

Line 2224: jai_po_taxes jpt

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

Line 2237: jai_po_taxes jpt

2233: SELECT
2234: jpt.currency
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

Line 2255: jai_po_taxes jpt

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

Line 2611: JAI_PO_TAXES jpt

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

Line 2626: JAI_PO_TAXES jpt

2622: jpt.line_location_id
2623: , jpt.currency
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

Line 2646: jai_po_taxes jpt

2642: jpt.line_location_id
2643: , jpt.currency
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

Line 2675: jai_po_taxes jpt

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

Line 2688: jai_po_taxes jpt

2684: SELECT
2685: jpt.currency
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

Line 2707: jai_po_taxes jpt

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

Line 2721: JAI_PO_TAXES jpt

2717: SELECT
2718: jpt.currency
2719: , SUM(jpt.tax_amount) tax_amount
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