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.INV_UOM_API_PUB dependencies on MTL_UNITS_OF_MEASURE_VL

Line 601: FROM MTL_UNITS_OF_MEASURE_VL

597: BEGIN
598:
599: SELECT UNIT_OF_MEASURE
600: INTO L_UNIT_OF_MEASURE
601: FROM MTL_UNITS_OF_MEASURE_VL
602: WHERE UNIT_OF_MEASURE_TL = P_BASE_UNIT_OF_MEASURE
603: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
604:
605: EXCEPTION

Line 629: FROM MTL_UNITS_OF_MEASURE_VL

625: BEGIN
626:
627: SELECT UOM_CODE
628: INTO L_UOM_CODE
629: FROM MTL_UNITS_OF_MEASURE_VL
630: WHERE UOM_CODE = P_BASE_UOM_CODE
631: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
632:
633: EXCEPTION

Line 739: FROM MTL_UNITS_OF_MEASURE_VL

735: SELECT UNIT_OF_MEASURE,
736: UOM_CODE
737: INTO L_UNIT_OF_MEASURE ,
738: L_UOM_CODE
739: FROM MTL_UNITS_OF_MEASURE_VL
740: WHERE UOM_CLASS = P_UOM_CLASS
741: AND UNIT_OF_MEASURE_TL = P_BASE_UNIT_OF_MEASURE
742: AND UOM_CODE = P_BASE_UOM_CODE ;
743:

Line 1442: FROM MTL_UNITS_OF_MEASURE_VL

1438: BEGIN
1439:
1440: SELECT UNIT_OF_MEASURE , UOM_CODE , BASE_UOM_FLAG
1441: INTO L_UNIT_OF_MEASURE , L_UOM_CODE , L_BASE_UOM_FLAG
1442: FROM MTL_UNITS_OF_MEASURE_VL
1443: WHERE UOM_CLASS = P_UOM_CLASS
1444: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE)
1445: AND (UNIT_OF_MEASURE_TL = P_UNIT_OF_MEASURE
1446: OR UOM_CODE = P_UOM_CODE) ;

Line 1516: FROM MTL_UNITS_OF_MEASURE_VL

1512: BEGIN
1513:
1514: SELECT UNIT_OF_MEASURE , UOM_CODE
1515: INTO L_UNIT_OF_MEASURE , L_UOM_CODE
1516: FROM MTL_UNITS_OF_MEASURE_VL
1517: WHERE UNIT_OF_MEASURE_TL = P_UNIT_OF_MEASURE
1518: -- AND uom_code = p_uom_code
1519: OR UOM_CODE = P_UOM_CODE
1520: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);

Line 2105: FROM MTL_UNITS_OF_MEASURE_VL

2101:
2102: BEGIN
2103: SELECT UNIT_OF_MEASURE , UOM_CLASS , BASE_UOM_FLAG
2104: INTO L_FROM_UNIT_OF_MEASURE , L_FROM_CLASS , P_FROM_BASE_UOM_FLAG
2105: FROM MTL_UNITS_OF_MEASURE_VL
2106: WHERE UOM_CODE = P_FROM_UOM_CODE
2107: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2108: EXCEPTION
2109: WHEN NO_DATA_FOUND THEN

Line 2123: FROM MTL_UNITS_OF_MEASURE_VL

2119:
2120: BEGIN
2121: SELECT UNIT_OF_MEASURE , UOM_CLASS , BASE_UOM_FLAG
2122: INTO L_TO_UNIT_OF_MEASURE , L_TO_CLASS , P_TO_BASE_UOM_FLAG
2123: FROM MTL_UNITS_OF_MEASURE_VL
2124: WHERE UOM_CODE = P_TO_UOM_CODE
2125: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2126: EXCEPTION
2127: WHEN NO_DATA_FOUND THEN

Line 2357: FROM MTL_UNITS_OF_MEASURE_VL

2353: -- These uom code must be base uom.
2354: BEGIN
2355: SELECT UOM_CODE , UOM_CLASS
2356: INTO l_uom_code , l_from_uom_class
2357: FROM MTL_UNITS_OF_MEASURE_VL
2358: WHERE UOM_CODE = P_FROM_UOM_CODE
2359: AND base_uom_flag = 'Y'
2360: AND NVL(disable_date, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2361: EXCEPTION

Line 2377: FROM MTL_UNITS_OF_MEASURE_VL

2373: BEGIN
2374:
2375: SELECT UOM_CODE
2376: INTO L_PRIMARY_UOM_CODE
2377: FROM MTL_UNITS_OF_MEASURE_VL
2378: WHERE UOM_CODE = L_PRIMARY_UOM_CODE
2379: and uom_class = l_from_uom_class
2380: AND NVL(disable_date, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2381:

Line 2397: FROM MTL_UNITS_OF_MEASURE_VL

2393:
2394: BEGIN
2395: SELECT uom_code
2396: INTO l_uom_code
2397: FROM MTL_UNITS_OF_MEASURE_VL
2398: WHERE UOM_CODE = P_TO_UOM_CODE
2399: AND BASE_UOM_FLAG = 'Y'
2400: AND NVL(disable_date, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2401: EXCEPTION

Line 2491: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.

2487: AND INVENTORY_ITEM_ID = P_ITEM_ID
2488: AND LOT_NUMBER = P_LOT_NUMBER
2489: AND TO_UOM_CODE = P_TO_UOM_CODE ;
2490: --AND to_unit_of_measure = p_to_unit_of_measure;
2491: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.
2492: EXCEPTION
2493: WHEN NO_DATA_FOUND THEN
2494: IF (L_DEBUG = 1) THEN
2495: INV_LOG_UTIL.TRACE('uom class conversion not exists', 'inv_uom_api_pub', '9');

Line 2534: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.

2530: AND LOT_NUMBER = P_LOT_NUMBER
2531: AND TO_UOM_CODE = P_TO_UOM_CODE
2532: AND from_uom_code = P_FROM_UOM_CODE ;
2533: --AND to_unit_of_measure = p_to_unit_of_measure;
2534: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND THEN
2537: IF (L_DEBUG = 1) THEN
2538: INV_LOG_UTIL.TRACE('No data found exception, lot conversion does not exists', 'inv_uom_api_pub', '9');