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_CONVERT dependencies on MTL_UNITS_OF_MEASURE

Line 573: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure

569: ** while using tables in functions. Refer to bug 191321 for details.
570: */
571:
572: if ( from_unit IS NULL and to_unit IS NULL ) then
573: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
574: WHERE unit_of_measure = from_name;
575:
576: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
577: WHERE unit_of_measure = to_name;

Line 576: SELECT uom_code INTO to_unt FROM mtl_units_of_measure

572: if ( from_unit IS NULL and to_unit IS NULL ) then
573: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
574: WHERE unit_of_measure = from_name;
575:
576: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
577: WHERE unit_of_measure = to_name;
578: else
579: fm_unt := from_unit;
580: to_unt := to_unit;

Line 692: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure

688: ** while using tables in functions. Refer to bug 191321 for details.
689: */
690:
691: if ( from_unit IS NULL and to_unit IS NULL ) then
692: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
693: WHERE unit_of_measure = from_name;
694:
695: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
696: WHERE unit_of_measure = to_name;

Line 695: SELECT uom_code INTO to_unt FROM mtl_units_of_measure

691: if ( from_unit IS NULL and to_unit IS NULL ) then
692: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
693: WHERE unit_of_measure = from_name;
694:
695: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
696: WHERE unit_of_measure = to_name;
697: else
698: fm_unt := from_unit;
699: to_unt := to_unit;

Line 795: MTL_UNITS_OF_MEASURE MTLUOM2

791:
792: Cursor c_msi is
793: select PRIMARY_UOM_CODE, ALLOWED_UNITS_LOOKUP_CODE
794: from mtl_system_items msi,
795: MTL_UNITS_OF_MEASURE MTLUOM2
796: where msi.ORGANIZATION_ID = p_organization_id AND
797: msi.INVENTORY_ITEM_ID = p_item_id AND
798: MTLUOM2.uom_code = msi.PRIMARY_UOM_CODE AND
799: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE);

Line 804: from MTL_UNITS_OF_MEASURE MTLUOM2,

800:
801:
802: cursor c_std_cvr_sameClass is
803: select MTLUOM2.uom_code, MTLUCV.uom_class
804: from MTL_UNITS_OF_MEASURE MTLUOM2,
805: MTL_UOM_CONVERSIONS MTLUCV,
806: MTL_UOM_CLASSES MTLCLS
807: where
808: MTLUOM2.uom_code = p_uom_code AND

Line 816: from MTL_UNITS_OF_MEASURE MTLPRI1

812: NVL(MTLCLS.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
813: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
814: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
815: MTLUCV.uom_class = (select MTLPRI1.uom_class
816: from MTL_UNITS_OF_MEASURE MTLPRI1
817: where MTLPRI1.uom_code = l_primary_uom_code AND
818: NVL(MTLPRI1.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
819: );
820:

Line 823: from MTL_UNITS_OF_MEASURE MTLUOM2,

819: );
820:
821: cursor c_item_cvr_sameClass is
822: select MTLUOM2.uom_code, MTLUCV.uom_class
823: from MTL_UNITS_OF_MEASURE MTLUOM2,
824: MTL_UOM_CONVERSIONS MTLUCV,
825: MTL_UOM_CLASSES MTLCLS
826: where MTLUOM2.uom_code = p_uom_code AND
827: MTLUCV.uom_code = MTLUOM2.uom_code AND

Line 838: from MTL_UNITS_OF_MEASURE MTLUOM2,

834:
835: cursor c_complex is
836:
837: select MTLUOM2.uom_code, MTLUOM2.uom_class
838: from MTL_UNITS_OF_MEASURE MTLUOM2,
839: MTL_UOM_CONVERSIONS MTLUCV,
840: MTL_UOM_CLASSES MTLCLS
841: where
842: MTLUOM2.uom_code = p_uom_code AND

Line 851: from MTL_UNITS_OF_MEASURE MTLUOM2,

847: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
848: l_allowed_units in (1,3) AND MTLUCV.inventory_item_id = p_item_id
849: UNION ALL
850: select MTLUOM2.uom_code, MTLUOM2.uom_class
851: from MTL_UNITS_OF_MEASURE MTLUOM2,
852: MTL_UOM_CONVERSIONS MTLUCV,
853: MTL_UOM_CLASSES MTLCLS
854: where
855: MTLUOM2.uom_code = p_uom_code AND

Line 863: from MTL_UNITS_OF_MEASURE MTLPRI1

859: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
860: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
861: l_allowed_units in (1,3) AND MTLUCV.inventory_item_id=0 AND
862: MTLUCV.uom_class = (select MTLPRI1.uom_class
863: from MTL_UNITS_OF_MEASURE MTLPRI1
864: where MTLPRI1.uom_code = l_primary_uom_code
865: )
866: UNION ALL
867: select MTLUOM2.uom_code, MTLUOM2.uom_class

Line 868: from MTL_UNITS_OF_MEASURE MTLUOM2,

864: where MTLPRI1.uom_code = l_primary_uom_code
865: )
866: UNION ALL
867: select MTLUOM2.uom_code, MTLUOM2.uom_class
868: from MTL_UNITS_OF_MEASURE MTLUOM2,
869: MTL_UOM_CONVERSIONS MTLUCV,
870: MTL_UOM_CLASSES MTLCLS
871: where
872: MTLUOM2.uom_code = p_uom_code AND

Line 889: from MTL_UNITS_OF_MEASURE MTLUOM2,

885: NVL(MTLUCC1.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
886: )
887: UNION ALL
888: select MTLUOM2.uom_code, MTLUOM2.uom_class
889: from MTL_UNITS_OF_MEASURE MTLUOM2,
890: MTL_UOM_CONVERSIONS MTLUCV,
891: MTL_UOM_CLASSES MTLCLS
892: where
893: MTLUOM2.uom_code = p_uom_code AND

Line 910: from MTL_UNITS_OF_MEASURE MTLUOM2,

906: NVL(MTLUCC.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
907: )
908: UNION ALL
909: select MTLUOM2.uom_code, MTLUOM2.uom_class
910: from MTL_UNITS_OF_MEASURE MTLUOM2,
911: MTL_UOM_CONVERSIONS MTLUCV,
912: MTL_UOM_CLASSES MTLCLS
913: where
914: MTLUOM2.uom_code = p_uom_code AND

Line 922: from MTL_UNITS_OF_MEASURE MTLPRI

918: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
919: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
920: l_allowed_units in (2,3) AND MTLUCV.inventory_item_id=0 AND
921: MTLUCV.uom_class = (select MTLPRI.uom_class
922: from MTL_UNITS_OF_MEASURE MTLPRI
923: where MTLPRI.uom_code = l_primary_uom_code
924: );
925:
926:

Line 1400: FROM mtl_units_of_measure

1396: ========================================*/
1397:
1398: CURSOR c_get_uom_code (p_unit VARCHAR2) IS
1399: SELECT uom_code
1400: FROM mtl_units_of_measure
1401: WHERE unit_of_measure = p_unit;
1402:
1403: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1404: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 1403: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1399: SELECT uom_code
1400: FROM mtl_units_of_measure
1401: WHERE unit_of_measure = p_unit;
1402:
1403: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1404: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1405: x_precision NUMBER;
1406: l_debug PLS_INTEGER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1407: l_procname VARCHAR2 (20) := 'within_deviation';

Line 1404: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1400: FROM mtl_units_of_measure
1401: WHERE unit_of_measure = p_unit;
1402:
1403: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1404: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1405: x_precision NUMBER;
1406: l_debug PLS_INTEGER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1407: l_procname VARCHAR2 (20) := 'within_deviation';
1408: BEGIN

Line 1700: FROM MTL_UNITS_OF_MEASURE_VL

1696:
1697: BEGIN
1698: SELECT unit_of_measure , uom_class , base_uom_flag
1699: INTO l_from_unit_of_measure , l_from_class , l_from_base_uom_flag
1700: FROM MTL_UNITS_OF_MEASURE_VL
1701: WHERE uom_code = p_from_uom_code
1702: AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
1703: EXCEPTION
1704: WHEN no_data_found THEN

Line 1712: FROM MTL_UNITS_OF_MEASURE_VL

1708:
1709: BEGIN
1710: SELECT unit_of_measure , uom_class , base_uom_flag
1711: INTO l_to_unit_of_measure ,l_to_class , l_to_base_uom_flag
1712: FROM MTL_UNITS_OF_MEASURE_VL
1713: WHERE uom_code = p_to_uom_code
1714: AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
1715: EXCEPTION
1716: WHEN no_data_found THEN

Line 1738: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A

1734: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I
1735: WHERE I.enabled_flag = 'Y'
1736: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )
1737: AND NVL(TRUNC(I.end_date_active),SYSDATE))
1738: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A
1739: WHERE (A.uom_class IN (SELECT to_uom_class FROM mtl_uom_class_conversions B
1740: WHERE B.inventory_item_id = I.inventory_item_id)
1741: OR A.uom_class = (SELECT Z.uom_class FROM mtl_units_of_measure Z
1742: WHERE Z.uom_code = I.primary_uom_code))

Line 1741: OR A.uom_class = (SELECT Z.uom_class FROM mtl_units_of_measure Z

1737: AND NVL(TRUNC(I.end_date_active),SYSDATE))
1738: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A
1739: WHERE (A.uom_class IN (SELECT to_uom_class FROM mtl_uom_class_conversions B
1740: WHERE B.inventory_item_id = I.inventory_item_id)
1741: OR A.uom_class = (SELECT Z.uom_class FROM mtl_units_of_measure Z
1742: WHERE Z.uom_code = I.primary_uom_code))
1743: AND A.base_uom_flag <> 'Y'
1744: AND NVL(A.disable_date, SYSDATE+1) > SYSDATE
1745: AND A.uom_class = NVL(l_to_class, A.uom_class))));

Line 1755: FROM mtl_units_of_measure x

1751:
1752: BEGIN
1753: SELECT DISTINCT x.uom_code
1754: INTO l_temp_uom
1755: FROM mtl_units_of_measure x
1756: WHERE x.uom_code = p_to_uom_code
1757: AND x.uom_code IN (SELECT DISTINCT a.uom_code FROM mtl_units_of_measure a
1758: WHERE (a.uom_class in (select to_uom_class
1759: from mtl_uom_class_conversions b

Line 1757: AND x.uom_code IN (SELECT DISTINCT a.uom_code FROM mtl_units_of_measure a

1753: SELECT DISTINCT x.uom_code
1754: INTO l_temp_uom
1755: FROM mtl_units_of_measure x
1756: WHERE x.uom_code = p_to_uom_code
1757: AND x.uom_code IN (SELECT DISTINCT a.uom_code FROM mtl_units_of_measure a
1758: WHERE (a.uom_class in (select to_uom_class
1759: from mtl_uom_class_conversions b
1760: where b.inventory_item_id = p_item_id)
1761: or a.uom_class =(select DISTINCT z.uom_class

Line 1762: from mtl_units_of_measure z , mtl_system_items_vl m

1758: WHERE (a.uom_class in (select to_uom_class
1759: from mtl_uom_class_conversions b
1760: where b.inventory_item_id = p_item_id)
1761: or a.uom_class =(select DISTINCT z.uom_class
1762: from mtl_units_of_measure z , mtl_system_items_vl m
1763: where m.inventory_item_id = p_item_id
1764: AND z.uom_code = m.primary_uom_code
1765: ))
1766: and a.base_uom_flag <> 'Y'

Line 1849: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A

1845: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I
1846: WHERE I.enabled_flag = 'Y'
1847: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )
1848: AND NVL(TRUNC(I.end_date_active),SYSDATE))
1849: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A
1850: WHERE (A.uom_class <> (SELECT R.uom_class FROM mtl_units_of_measure R
1851: WHERE R.uom_code = I.primary_uom_code))
1852: AND A.base_uom_flag = 'Y'
1853: AND NVL(A.disable_date, SYSDATE+1) > SYSDATE

Line 1850: WHERE (A.uom_class <> (SELECT R.uom_class FROM mtl_units_of_measure R

1846: WHERE I.enabled_flag = 'Y'
1847: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )
1848: AND NVL(TRUNC(I.end_date_active),SYSDATE))
1849: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A
1850: WHERE (A.uom_class <> (SELECT R.uom_class FROM mtl_units_of_measure R
1851: WHERE R.uom_code = I.primary_uom_code))
1852: AND A.base_uom_flag = 'Y'
1853: AND NVL(A.disable_date, SYSDATE+1) > SYSDATE
1854: AND A.uom_class = NVL(l_to_class,A.uom_class))));