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.PO_CORE_S dependencies on FND_CURRENCIES

Line 1383: FROM FND_CURRENCIES C,

1379: SELECT c.minimum_accountable_unit,
1380: c.precision
1381: INTO x_min_unit,
1382: x_precision
1383: FROM FND_CURRENCIES C,
1384: PO_HEADERS_ALL PH
1385: WHERE PH.po_header_id = x_object_id
1386: AND C.currency_code = PH.CURRENCY_CODE;
1387:

Line 1590: FROM FND_CURRENCIES C,

1586: SELECT c.minimum_accountable_unit,
1587: c.precision
1588: INTO x_min_unit,
1589: x_precision
1590: FROM FND_CURRENCIES C,
1591: PO_HEADERS_ALL PH
1592: WHERE PH.po_header_id = x_object_id
1593: AND C.currency_code = PH.CURRENCY_CODE;
1594:

Line 1845: FROM FND_CURRENCIES C,

1841: SELECT c.minimum_accountable_unit,
1842: c.precision
1843: INTO x_min_unit,
1844: x_precision
1845: FROM FND_CURRENCIES C,
1846: PO_HEADERS_ALL PH
1847: WHERE PH.po_header_id = x_object_id
1848: AND C.currency_code = PH.CURRENCY_CODE;
1849:

Line 1872: Also removed the join to FND_CURRENCIES

1868: amount for foreign currency contract when the PO currency is same
1869: as the contract currency and the rates were different.Added the decode
1870: to perform the currency conversion only when the currency code of
1871: PO and contract are different.
1872: Also removed the join to FND_CURRENCIES
1873: */
1874:
1875: /*Bug 12723347
1876: 1)For execution documents with same currency as the Contract, get

Line 2000: --,FND_CURRENCIES C

1996: PO_LINE_LOCATIONS_ALL PLL,
1997: PO_LINES_ALL PL,
1998: PO_HEADERS_ALL PH,
1999: PO_HEADERS_ALL PH1
2000: --,FND_CURRENCIES C
2001: WHERE PH.po_header_id = x_object_id
2002: AND PH.po_header_id = PL.contract_id --
2003: --AND PH.currency_code = C.currency_code
2004: AND PL.po_line_id = PLL.po_line_id

Line 2194: FROM FND_CURRENCIES C,

2190: SELECT c.minimum_accountable_unit,
2191: c.precision
2192: INTO x_min_unit,
2193: x_precision
2194: FROM FND_CURRENCIES C,
2195: PO_RELEASES_ALL POR,
2196: PO_HEADERS_ALL PH
2197: WHERE POR.po_release_id = x_object_id
2198: AND PH.po_header_id = POR.PO_HEADER_ID

Line 2265: FROM FND_CURRENCIES C,

2261: SELECT sum(c.minimum_accountable_unit),
2262: sum(c.precision)
2263: INTO x_min_unit,
2264: x_precision
2265: FROM FND_CURRENCIES C,
2266: PO_HEADERS_ALL PH,
2267: PO_LINES_ALL POL
2268: WHERE POL.po_line_id = x_object_id
2269: AND PH.po_header_id = POL.po_header_id

Line 2332: FROM FND_CURRENCIES C,

2328: SELECT c.minimum_accountable_unit,
2329: c.precision
2330: INTO x_min_unit,
2331: x_precision
2332: FROM FND_CURRENCIES C,
2333: PO_HEADERS_ALL PH,
2334: PO_LINE_LOCATIONS_ALL PLL
2335: WHERE PLL.line_location_id = x_object_id
2336: AND PH.po_header_id = PLL.po_header_id

Line 2437: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2433: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2434:
2435: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2436: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2437: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2438: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2439: l_precision FND_CURRENCIES.PRECISION%TYPE;
2440: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2441: l_archive_total_amt NUMBER;

Line 2438: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2434:
2435: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2436: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2437: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2438: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2439: l_precision FND_CURRENCIES.PRECISION%TYPE;
2440: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2441: l_archive_total_amt NUMBER;
2442: l_progress VARCHAR2(3):='000';

Line 2439: l_precision FND_CURRENCIES.PRECISION%TYPE;

2435: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2436: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2437: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2438: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2439: l_precision FND_CURRENCIES.PRECISION%TYPE;
2440: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2441: l_archive_total_amt NUMBER;
2442: l_progress VARCHAR2(3):='000';
2443: BEGIN

Line 2440: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

2436: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2437: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2438: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2439: l_precision FND_CURRENCIES.PRECISION%TYPE;
2440: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2441: l_archive_total_amt NUMBER;
2442: l_progress VARCHAR2(3):='000';
2443: BEGIN
2444: l_progress := '010';

Line 2544: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2540: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2541:
2542: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2543: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2544: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2545: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2546: l_precision FND_CURRENCIES.PRECISION%TYPE;
2547: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2548: l_archive_total_amt NUMBER;

Line 2545: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2541:
2542: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2543: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2544: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2545: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2546: l_precision FND_CURRENCIES.PRECISION%TYPE;
2547: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2548: l_archive_total_amt NUMBER;
2549: l_progress VARCHAR2(3):='000';

Line 2546: l_precision FND_CURRENCIES.PRECISION%TYPE;

2542: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2543: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2544: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2545: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2546: l_precision FND_CURRENCIES.PRECISION%TYPE;
2547: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2548: l_archive_total_amt NUMBER;
2549: l_progress VARCHAR2(3):='000';
2550:

Line 2547: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

2543: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2544: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2545: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2546: l_precision FND_CURRENCIES.PRECISION%TYPE;
2547: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2548: l_archive_total_amt NUMBER;
2549: l_progress VARCHAR2(3):='000';
2550:
2551: BEGIN

Line 2633: FROM FND_CURRENCIES C,

2629: SELECT c.minimum_accountable_unit,
2630: c.precision
2631: INTO l_min_unit,
2632: l_precision
2633: FROM FND_CURRENCIES C,
2634: PO_HEADERS_ALL PH,
2635: PO_LINE_LOCATIONS_ALL PLL
2636: WHERE PLL.line_location_id = p_object_id
2637: AND PH.po_header_id = PLL.po_header_id

Line 2695: FROM FND_CURRENCIES C,

2691: SELECT sum(c.minimum_accountable_unit),
2692: sum(c.precision)
2693: INTO l_min_unit,
2694: l_precision
2695: FROM FND_CURRENCIES C,
2696: PO_HEADERS_ALL PH,
2697: PO_LINES_ALL POL
2698: WHERE POL.po_line_id = p_object_id
2699: AND PH.po_header_id = POL.po_header_id

Line 2912: FROM FND_CURRENCIES C,

2908: SELECT c.minimum_accountable_unit,
2909: c.precision
2910: INTO l_min_unit,
2911: l_precision
2912: FROM FND_CURRENCIES C,
2913: PO_RELEASES_ALL POR,
2914: PO_HEADERS_ALL PH
2915: WHERE POR.po_release_id = p_object_id
2916: AND PH.po_header_id = POR.PO_HEADER_ID

Line 3031: FROM FND_CURRENCIES C,

3027: SELECT sum(c.minimum_accountable_unit),
3028: sum(c.precision)
3029: INTO x_min_unit,
3030: x_precision
3031: FROM FND_CURRENCIES C,
3032: PO_HEADERS_ALL PH,
3033: PO_LINES_ALL POL
3034: WHERE POL.po_line_id = p_line_id
3035: AND PH.po_header_id = POL.po_header_id

Line 3098: l_base_currency FND_CURRENCIES.currency_code%TYPE;

3094: p_convert_to_base BOOLEAN := FALSE
3095: )
3096: RETURN NUMBER
3097: IS
3098: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3099: l_base_precision FND_CURRENCIES.precision%TYPE;
3100: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3102:

Line 3099: l_base_precision FND_CURRENCIES.precision%TYPE;

3095: )
3096: RETURN NUMBER
3097: IS
3098: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3099: l_base_precision FND_CURRENCIES.precision%TYPE;
3100: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3102:
3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;

Line 3100: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;

3096: RETURN NUMBER
3097: IS
3098: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3099: l_base_precision FND_CURRENCIES.precision%TYPE;
3100: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3102:
3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3104: l_po_precision FND_CURRENCIES.precision%TYPE;

Line 3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3097: IS
3098: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3099: l_base_precision FND_CURRENCIES.precision%TYPE;
3100: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3102:
3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3104: l_po_precision FND_CURRENCIES.precision%TYPE;
3105: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

Line 3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;

3099: l_base_precision FND_CURRENCIES.precision%TYPE;
3100: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3102:
3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3104: l_po_precision FND_CURRENCIES.precision%TYPE;
3105: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3106: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3107:

Line 3104: l_po_precision FND_CURRENCIES.precision%TYPE;

3100: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3102:
3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3104: l_po_precision FND_CURRENCIES.precision%TYPE;
3105: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3106: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3107:
3108: l_rate PO_HEADERS_ALL.rate%TYPE;

Line 3105: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

3101: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3102:
3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3104: l_po_precision FND_CURRENCIES.precision%TYPE;
3105: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3106: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3107:
3108: l_rate PO_HEADERS_ALL.rate%TYPE;
3109:

Line 3106: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3102:
3103: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3104: l_po_precision FND_CURRENCIES.precision%TYPE;
3105: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3106: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3107:
3108: l_rate PO_HEADERS_ALL.rate%TYPE;
3109:
3110: x_total NUMBER;

Line 3332: l_base_currency FND_CURRENCIES.currency_code%TYPE;

3328: x_quantity_released OUT NOCOPY NUMBER,
3329: x_amount_released OUT NOCOPY NUMBER
3330: )
3331: IS
3332: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3333:
3334: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3335: l_po_precision FND_CURRENCIES.precision%TYPE;
3336: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

Line 3334: l_po_currency FND_CURRENCIES.currency_code%TYPE;

3330: )
3331: IS
3332: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3333:
3334: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3335: l_po_precision FND_CURRENCIES.precision%TYPE;
3336: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3337: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3338:

Line 3335: l_po_precision FND_CURRENCIES.precision%TYPE;

3331: IS
3332: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3333:
3334: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3335: l_po_precision FND_CURRENCIES.precision%TYPE;
3336: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3337: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3338:
3339: l_rate PO_HEADERS_ALL.rate%TYPE;

Line 3336: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

3332: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3333:
3334: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3335: l_po_precision FND_CURRENCIES.precision%TYPE;
3336: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3337: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3338:
3339: l_rate PO_HEADERS_ALL.rate%TYPE;
3340:

Line 3337: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3333:
3334: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3335: l_po_precision FND_CURRENCIES.precision%TYPE;
3336: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3337: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3338:
3339: l_rate PO_HEADERS_ALL.rate%TYPE;
3340:
3341: BEGIN

Line 3431: l_base_currency FND_CURRENCIES.currency_code%TYPE;

3427: p_convert_to_base IN BOOLEAN := FALSE
3428: ) RETURN NUMBER
3429: IS
3430:
3431: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3432: l_base_precision FND_CURRENCIES.precision%TYPE;
3433: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3434:
3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;

Line 3432: l_base_precision FND_CURRENCIES.precision%TYPE;

3428: ) RETURN NUMBER
3429: IS
3430:
3431: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3432: l_base_precision FND_CURRENCIES.precision%TYPE;
3433: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3434:
3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3436: l_po_precision FND_CURRENCIES.precision%TYPE;

Line 3433: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3429: IS
3430:
3431: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3432: l_base_precision FND_CURRENCIES.precision%TYPE;
3433: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3434:
3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3436: l_po_precision FND_CURRENCIES.precision%TYPE;
3437: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

Line 3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;

3431: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3432: l_base_precision FND_CURRENCIES.precision%TYPE;
3433: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3434:
3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3436: l_po_precision FND_CURRENCIES.precision%TYPE;
3437: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3438:
3439: l_rate PO_HEADERS_ALL.rate%TYPE;

Line 3436: l_po_precision FND_CURRENCIES.precision%TYPE;

3432: l_base_precision FND_CURRENCIES.precision%TYPE;
3433: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3434:
3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3436: l_po_precision FND_CURRENCIES.precision%TYPE;
3437: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3438:
3439: l_rate PO_HEADERS_ALL.rate%TYPE;
3440: l_total NUMBER;

Line 3437: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3433: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3434:
3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3436: l_po_precision FND_CURRENCIES.precision%TYPE;
3437: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3438:
3439: l_rate PO_HEADERS_ALL.rate%TYPE;
3440: l_total NUMBER;
3441: