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 1368: FROM FND_CURRENCIES C,

1364: SELECT c.minimum_accountable_unit,
1365: c.precision
1366: INTO x_min_unit,
1367: x_precision
1368: FROM FND_CURRENCIES C,
1369: PO_HEADERS_ALL PH
1370: WHERE PH.po_header_id = x_object_id
1371: AND C.currency_code = PH.CURRENCY_CODE;
1372:

Line 1575: FROM FND_CURRENCIES C,

1571: SELECT c.minimum_accountable_unit,
1572: c.precision
1573: INTO x_min_unit,
1574: x_precision
1575: FROM FND_CURRENCIES C,
1576: PO_HEADERS_ALL PH
1577: WHERE PH.po_header_id = x_object_id
1578: AND C.currency_code = PH.CURRENCY_CODE;
1579:

Line 1827: FROM FND_CURRENCIES C,

1823: SELECT c.minimum_accountable_unit,
1824: c.precision
1825: INTO x_min_unit,
1826: x_precision
1827: FROM FND_CURRENCIES C,
1828: PO_HEADERS_ALL PH
1829: WHERE PH.po_header_id = x_object_id
1830: AND C.currency_code = PH.CURRENCY_CODE;
1831:

Line 1854: Also removed the join to FND_CURRENCIES

1850: amount for foreign currency contract when the PO currency is same
1851: as the contract currency and the rates were different.Added the decode
1852: to perform the currency conversion only when the currency code of
1853: PO and contract are different.
1854: Also removed the join to FND_CURRENCIES
1855: */
1856: if x_min_unit is null then
1857: x_progress := 172;
1858: --< Bug 3549096 > Use _ALL tables instead of org-striped views.

Line 1875: --,FND_CURRENCIES C

1871: PO_LINE_LOCATIONS_ALL PLL,
1872: PO_LINES_ALL PL,
1873: PO_HEADERS_ALL PH,
1874: PO_HEADERS_ALL PH1
1875: --,FND_CURRENCIES C
1876: WHERE PH.po_header_id = x_object_id
1877: AND PH.po_header_id = PL.contract_id --
1878: --AND PH.currency_code = C.currency_code
1879: AND PL.po_line_id = PLL.po_line_id

Line 1909: --,FND_CURRENCIES C

1905: PO_LINE_LOCATIONS_ALL PLL,
1906: PO_LINES_ALL PL,
1907: PO_HEADERS_ALL PH,
1908: PO_HEADERS_ALL PH1
1909: --,FND_CURRENCIES C
1910: WHERE PH.po_header_id = x_object_id
1911: AND PH.po_header_id = PL.contract_id --
1912: --AND PH.currency_code = C.currency_code
1913: AND PL.po_line_id = PLL.po_line_id

Line 2062: FROM FND_CURRENCIES C,

2058: SELECT c.minimum_accountable_unit,
2059: c.precision
2060: INTO x_min_unit,
2061: x_precision
2062: FROM FND_CURRENCIES C,
2063: PO_RELEASES_ALL POR,
2064: PO_HEADERS_ALL PH
2065: WHERE POR.po_release_id = x_object_id
2066: AND PH.po_header_id = POR.PO_HEADER_ID

Line 2133: FROM FND_CURRENCIES C,

2129: SELECT sum(c.minimum_accountable_unit),
2130: sum(c.precision)
2131: INTO x_min_unit,
2132: x_precision
2133: FROM FND_CURRENCIES C,
2134: PO_HEADERS_ALL PH,
2135: PO_LINES_ALL POL
2136: WHERE POL.po_line_id = x_object_id
2137: AND PH.po_header_id = POL.po_header_id

Line 2200: FROM FND_CURRENCIES C,

2196: SELECT c.minimum_accountable_unit,
2197: c.precision
2198: INTO x_min_unit,
2199: x_precision
2200: FROM FND_CURRENCIES C,
2201: PO_HEADERS_ALL PH,
2202: PO_LINE_LOCATIONS_ALL PLL
2203: WHERE PLL.line_location_id = x_object_id
2204: AND PH.po_header_id = PLL.po_header_id

Line 2305: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2301: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2302:
2303: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2304: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2305: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2306: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2307: l_precision FND_CURRENCIES.PRECISION%TYPE;
2308: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2309: l_archive_total_amt NUMBER;

Line 2306: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2302:
2303: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2304: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2305: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2306: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2307: l_precision FND_CURRENCIES.PRECISION%TYPE;
2308: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2309: l_archive_total_amt NUMBER;
2310: l_progress VARCHAR2(3):='000';

Line 2307: l_precision FND_CURRENCIES.PRECISION%TYPE;

2303: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2304: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2305: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2306: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2307: l_precision FND_CURRENCIES.PRECISION%TYPE;
2308: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2309: l_archive_total_amt NUMBER;
2310: l_progress VARCHAR2(3):='000';
2311: BEGIN

Line 2308: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

2304: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2305: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2306: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2307: l_precision FND_CURRENCIES.PRECISION%TYPE;
2308: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2309: l_archive_total_amt NUMBER;
2310: l_progress VARCHAR2(3):='000';
2311: BEGIN
2312: l_progress := '010';

Line 2412: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2408: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2409:
2410: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2411: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2412: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2413: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2414: l_precision FND_CURRENCIES.PRECISION%TYPE;
2415: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2416: l_archive_total_amt NUMBER;

Line 2413: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2409:
2410: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2411: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2412: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2413: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2414: l_precision FND_CURRENCIES.PRECISION%TYPE;
2415: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2416: l_archive_total_amt NUMBER;
2417: l_progress VARCHAR2(3):='000';

Line 2414: l_precision FND_CURRENCIES.PRECISION%TYPE;

2410: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2411: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2412: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2413: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2414: l_precision FND_CURRENCIES.PRECISION%TYPE;
2415: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2416: l_archive_total_amt NUMBER;
2417: l_progress VARCHAR2(3):='000';
2418:

Line 2415: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

2411: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2412: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2413: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2414: l_precision FND_CURRENCIES.PRECISION%TYPE;
2415: l_base_precision FND_CURRENCIES.PRECISION%TYPE;
2416: l_archive_total_amt NUMBER;
2417: l_progress VARCHAR2(3):='000';
2418:
2419: BEGIN

Line 2501: FROM FND_CURRENCIES C,

2497: SELECT c.minimum_accountable_unit,
2498: c.precision
2499: INTO l_min_unit,
2500: l_precision
2501: FROM FND_CURRENCIES C,
2502: PO_HEADERS_ALL PH,
2503: PO_LINE_LOCATIONS_ALL PLL
2504: WHERE PLL.line_location_id = p_object_id
2505: AND PH.po_header_id = PLL.po_header_id

Line 2563: FROM FND_CURRENCIES C,

2559: SELECT sum(c.minimum_accountable_unit),
2560: sum(c.precision)
2561: INTO l_min_unit,
2562: l_precision
2563: FROM FND_CURRENCIES C,
2564: PO_HEADERS_ALL PH,
2565: PO_LINES_ALL POL
2566: WHERE POL.po_line_id = p_object_id
2567: AND PH.po_header_id = POL.po_header_id

Line 2780: FROM FND_CURRENCIES C,

2776: SELECT c.minimum_accountable_unit,
2777: c.precision
2778: INTO l_min_unit,
2779: l_precision
2780: FROM FND_CURRENCIES C,
2781: PO_RELEASES_ALL POR,
2782: PO_HEADERS_ALL PH
2783: WHERE POR.po_release_id = p_object_id
2784: AND PH.po_header_id = POR.PO_HEADER_ID

Line 2899: FROM FND_CURRENCIES C,

2895: SELECT sum(c.minimum_accountable_unit),
2896: sum(c.precision)
2897: INTO x_min_unit,
2898: x_precision
2899: FROM FND_CURRENCIES C,
2900: PO_HEADERS_ALL PH,
2901: PO_LINES_ALL POL
2902: WHERE POL.po_line_id = p_line_id
2903: AND PH.po_header_id = POL.po_header_id

Line 2966: l_base_currency FND_CURRENCIES.currency_code%TYPE;

2962: p_convert_to_base BOOLEAN := FALSE
2963: )
2964: RETURN NUMBER
2965: IS
2966: l_base_currency FND_CURRENCIES.currency_code%TYPE;
2967: l_base_precision FND_CURRENCIES.precision%TYPE;
2968: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2970:

Line 2967: l_base_precision FND_CURRENCIES.precision%TYPE;

2963: )
2964: RETURN NUMBER
2965: IS
2966: l_base_currency FND_CURRENCIES.currency_code%TYPE;
2967: l_base_precision FND_CURRENCIES.precision%TYPE;
2968: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2970:
2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;

Line 2968: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;

2964: RETURN NUMBER
2965: IS
2966: l_base_currency FND_CURRENCIES.currency_code%TYPE;
2967: l_base_precision FND_CURRENCIES.precision%TYPE;
2968: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2970:
2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;
2972: l_po_precision FND_CURRENCIES.precision%TYPE;

Line 2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

2965: IS
2966: l_base_currency FND_CURRENCIES.currency_code%TYPE;
2967: l_base_precision FND_CURRENCIES.precision%TYPE;
2968: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2970:
2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;
2972: l_po_precision FND_CURRENCIES.precision%TYPE;
2973: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

Line 2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;

2967: l_base_precision FND_CURRENCIES.precision%TYPE;
2968: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2970:
2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;
2972: l_po_precision FND_CURRENCIES.precision%TYPE;
2973: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2974: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2975:

Line 2972: l_po_precision FND_CURRENCIES.precision%TYPE;

2968: l_base_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2970:
2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;
2972: l_po_precision FND_CURRENCIES.precision%TYPE;
2973: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2974: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2975:
2976: l_rate PO_HEADERS_ALL.rate%TYPE;

Line 2973: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

2969: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2970:
2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;
2972: l_po_precision FND_CURRENCIES.precision%TYPE;
2973: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2974: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2975:
2976: l_rate PO_HEADERS_ALL.rate%TYPE;
2977:

Line 2974: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

2970:
2971: l_po_currency FND_CURRENCIES.currency_code%TYPE;
2972: l_po_precision FND_CURRENCIES.precision%TYPE;
2973: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2974: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2975:
2976: l_rate PO_HEADERS_ALL.rate%TYPE;
2977:
2978: x_total NUMBER;

Line 3203: l_base_currency FND_CURRENCIES.currency_code%TYPE;

3199: x_quantity_released OUT NOCOPY NUMBER,
3200: x_amount_released OUT NOCOPY NUMBER
3201: )
3202: IS
3203: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3204:
3205: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3206: l_po_precision FND_CURRENCIES.precision%TYPE;
3207: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

Line 3205: l_po_currency FND_CURRENCIES.currency_code%TYPE;

3201: )
3202: IS
3203: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3204:
3205: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3206: l_po_precision FND_CURRENCIES.precision%TYPE;
3207: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3208: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3209:

Line 3206: l_po_precision FND_CURRENCIES.precision%TYPE;

3202: IS
3203: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3204:
3205: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3206: l_po_precision FND_CURRENCIES.precision%TYPE;
3207: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3208: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3209:
3210: l_rate PO_HEADERS_ALL.rate%TYPE;

Line 3207: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;

3203: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3204:
3205: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3206: l_po_precision FND_CURRENCIES.precision%TYPE;
3207: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3208: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3209:
3210: l_rate PO_HEADERS_ALL.rate%TYPE;
3211:

Line 3208: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3204:
3205: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3206: l_po_precision FND_CURRENCIES.precision%TYPE;
3207: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3208: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3209:
3210: l_rate PO_HEADERS_ALL.rate%TYPE;
3211:
3212: BEGIN

Line 3297: l_base_currency FND_CURRENCIES.currency_code%TYPE;

3293: p_convert_to_base IN BOOLEAN := FALSE
3294: ) RETURN NUMBER
3295: IS
3296:
3297: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3298: l_base_precision FND_CURRENCIES.precision%TYPE;
3299: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3300:
3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;

Line 3298: l_base_precision FND_CURRENCIES.precision%TYPE;

3294: ) RETURN NUMBER
3295: IS
3296:
3297: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3298: l_base_precision FND_CURRENCIES.precision%TYPE;
3299: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3300:
3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3302: l_po_precision FND_CURRENCIES.precision%TYPE;

Line 3299: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3295: IS
3296:
3297: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3298: l_base_precision FND_CURRENCIES.precision%TYPE;
3299: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3300:
3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3302: l_po_precision FND_CURRENCIES.precision%TYPE;
3303: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

Line 3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;

3297: l_base_currency FND_CURRENCIES.currency_code%TYPE;
3298: l_base_precision FND_CURRENCIES.precision%TYPE;
3299: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3300:
3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3302: l_po_precision FND_CURRENCIES.precision%TYPE;
3303: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3304:
3305: l_rate PO_HEADERS_ALL.rate%TYPE;

Line 3302: l_po_precision FND_CURRENCIES.precision%TYPE;

3298: l_base_precision FND_CURRENCIES.precision%TYPE;
3299: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3300:
3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3302: l_po_precision FND_CURRENCIES.precision%TYPE;
3303: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3304:
3305: l_rate PO_HEADERS_ALL.rate%TYPE;
3306: l_total NUMBER;

Line 3303: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

3299: l_base_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3300:
3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3302: l_po_precision FND_CURRENCIES.precision%TYPE;
3303: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3304:
3305: l_rate PO_HEADERS_ALL.rate%TYPE;
3306: l_total NUMBER;
3307: