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 543: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure

539: ** while using tables in functions. Refer to bug 191321 for details.
540: */
541:
542: if ( from_unit IS NULL and to_unit IS NULL ) then
543: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
544: WHERE unit_of_measure = from_name;
545:
546: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
547: WHERE unit_of_measure = to_name;

Line 546: SELECT uom_code INTO to_unt FROM mtl_units_of_measure

542: if ( from_unit IS NULL and to_unit IS NULL ) then
543: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
544: WHERE unit_of_measure = from_name;
545:
546: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
547: WHERE unit_of_measure = to_name;
548: else
549: fm_unt := from_unit;
550: to_unt := to_unit;

Line 662: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure

658: ** while using tables in functions. Refer to bug 191321 for details.
659: */
660:
661: if ( from_unit IS NULL and to_unit IS NULL ) then
662: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
663: WHERE unit_of_measure = from_name;
664:
665: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
666: WHERE unit_of_measure = to_name;

Line 665: SELECT uom_code INTO to_unt FROM mtl_units_of_measure

661: if ( from_unit IS NULL and to_unit IS NULL ) then
662: SELECT uom_code INTO fm_unt FROM mtl_units_of_measure
663: WHERE unit_of_measure = from_name;
664:
665: SELECT uom_code INTO to_unt FROM mtl_units_of_measure
666: WHERE unit_of_measure = to_name;
667: else
668: fm_unt := from_unit;
669: to_unt := to_unit;

Line 765: MTL_UNITS_OF_MEASURE MTLUOM2

761:
762: Cursor c_msi is
763: select PRIMARY_UOM_CODE, ALLOWED_UNITS_LOOKUP_CODE
764: from mtl_system_items msi,
765: MTL_UNITS_OF_MEASURE MTLUOM2
766: where msi.ORGANIZATION_ID = p_organization_id AND
767: msi.INVENTORY_ITEM_ID = p_item_id AND
768: MTLUOM2.uom_code = msi.PRIMARY_UOM_CODE AND
769: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE);

Line 774: from MTL_UNITS_OF_MEASURE MTLUOM2,

770:
771:
772: cursor c_std_cvr_sameClass is
773: select MTLUOM2.uom_code, MTLUCV.uom_class
774: from MTL_UNITS_OF_MEASURE MTLUOM2,
775: MTL_UOM_CONVERSIONS MTLUCV,
776: MTL_UOM_CLASSES MTLCLS
777: where
778: MTLUOM2.uom_code = p_uom_code AND

Line 786: from MTL_UNITS_OF_MEASURE MTLPRI1

782: NVL(MTLCLS.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
783: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
784: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
785: MTLUCV.uom_class = (select MTLPRI1.uom_class
786: from MTL_UNITS_OF_MEASURE MTLPRI1
787: where MTLPRI1.uom_code = l_primary_uom_code AND
788: NVL(MTLPRI1.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
789: );
790:

Line 793: from MTL_UNITS_OF_MEASURE MTLUOM2,

789: );
790:
791: cursor c_item_cvr_sameClass is
792: select MTLUOM2.uom_code, MTLUCV.uom_class
793: from MTL_UNITS_OF_MEASURE MTLUOM2,
794: MTL_UOM_CONVERSIONS MTLUCV,
795: MTL_UOM_CLASSES MTLCLS
796: where MTLUOM2.uom_code = p_uom_code AND
797: MTLUCV.uom_code = MTLUOM2.uom_code AND

Line 808: from MTL_UNITS_OF_MEASURE MTLUOM2,

804:
805: cursor c_complex is
806:
807: select MTLUOM2.uom_code, MTLUOM2.uom_class
808: from MTL_UNITS_OF_MEASURE MTLUOM2,
809: MTL_UOM_CONVERSIONS MTLUCV,
810: MTL_UOM_CLASSES MTLCLS
811: where
812: MTLUOM2.uom_code = p_uom_code AND

Line 821: from MTL_UNITS_OF_MEASURE MTLUOM2,

817: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
818: l_allowed_units in (1,3) AND MTLUCV.inventory_item_id = p_item_id
819: UNION ALL
820: select MTLUOM2.uom_code, MTLUOM2.uom_class
821: from MTL_UNITS_OF_MEASURE MTLUOM2,
822: MTL_UOM_CONVERSIONS MTLUCV,
823: MTL_UOM_CLASSES MTLCLS
824: where
825: MTLUOM2.uom_code = p_uom_code AND

Line 833: from MTL_UNITS_OF_MEASURE MTLPRI1

829: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
830: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
831: l_allowed_units in (1,3) AND MTLUCV.inventory_item_id=0 AND
832: MTLUCV.uom_class = (select MTLPRI1.uom_class
833: from MTL_UNITS_OF_MEASURE MTLPRI1
834: where MTLPRI1.uom_code = l_primary_uom_code
835: )
836: UNION ALL
837: select MTLUOM2.uom_code, MTLUOM2.uom_class

Line 838: from MTL_UNITS_OF_MEASURE MTLUOM2,

834: where MTLPRI1.uom_code = l_primary_uom_code
835: )
836: UNION ALL
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 859: from MTL_UNITS_OF_MEASURE MTLUOM2,

855: NVL(MTLUCC1.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
856: )
857: UNION ALL
858: select MTLUOM2.uom_code, MTLUOM2.uom_class
859: from MTL_UNITS_OF_MEASURE MTLUOM2,
860: MTL_UOM_CONVERSIONS MTLUCV,
861: MTL_UOM_CLASSES MTLCLS
862: where
863: MTLUOM2.uom_code = p_uom_code AND

Line 880: from MTL_UNITS_OF_MEASURE MTLUOM2,

876: NVL(MTLUCC.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
877: )
878: UNION ALL
879: select MTLUOM2.uom_code, MTLUOM2.uom_class
880: from MTL_UNITS_OF_MEASURE MTLUOM2,
881: MTL_UOM_CONVERSIONS MTLUCV,
882: MTL_UOM_CLASSES MTLCLS
883: where
884: MTLUOM2.uom_code = p_uom_code AND

Line 892: from MTL_UNITS_OF_MEASURE MTLPRI

888: NVL(MTLUOM2.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
889: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
890: l_allowed_units in (2,3) AND MTLUCV.inventory_item_id=0 AND
891: MTLUCV.uom_class = (select MTLPRI.uom_class
892: from MTL_UNITS_OF_MEASURE MTLPRI
893: where MTLPRI.uom_code = l_primary_uom_code
894: );
895:
896:

Line 1151: FROM mtl_units_of_measure

1147: ========================================*/
1148:
1149: CURSOR c_get_uom_code (p_unit VARCHAR2) IS
1150: SELECT uom_code
1151: FROM mtl_units_of_measure
1152: WHERE unit_of_measure = p_unit;
1153:
1154: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1155: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 1154: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1150: SELECT uom_code
1151: FROM mtl_units_of_measure
1152: WHERE unit_of_measure = p_unit;
1153:
1154: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1155: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1156: x_precision NUMBER;
1157: l_debug PLS_INTEGER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1158: l_procname VARCHAR2 (20) := 'within_deviation';

Line 1155: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1151: FROM mtl_units_of_measure
1152: WHERE unit_of_measure = p_unit;
1153:
1154: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1155: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1156: x_precision NUMBER;
1157: l_debug PLS_INTEGER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1158: l_procname VARCHAR2 (20) := 'within_deviation';
1159: BEGIN