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_UOM_CONVERSIONS

Line 79: from mtl_uom_conversions t,

75: select t.conversion_rate std_to_rate,
76: t.uom_class std_to_class,
77: f.conversion_rate std_from_rate,
78: f.uom_class std_from_class
79: from mtl_uom_conversions t,
80: mtl_uom_conversions f
81: where t.inventory_item_id in (item_id, 0)
82: and t.uom_code = to_unit
83: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)

Line 80: mtl_uom_conversions f

76: t.uom_class std_to_class,
77: f.conversion_rate std_from_rate,
78: f.uom_class std_from_class
79: from mtl_uom_conversions t,
80: mtl_uom_conversions f
81: where t.inventory_item_id in (item_id, 0)
82: and t.uom_code = to_unit
83: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
84: and f.inventory_item_id in (item_id, 0)

Line 97: from mtl_uom_conversions

93:
94: cursor from_standard_conversions is
95: select conversion_rate std_from_rate,
96: uom_class std_from_class
97: from mtl_uom_conversions
98: where inventory_item_id in (item_id, 0)
99: and uom_code = from_unit
100: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate)
101: order by inventory_item_id desc;

Line 108: from mtl_uom_conversions

104:
105: cursor to_standard_conversions is
106: select conversion_rate std_to_rate,
107: uom_class std_to_class
108: from mtl_uom_conversions
109: where inventory_item_id in (item_id, 0)
110: and uom_code = to_unit
111: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate)
112: order by inventory_item_id desc;

Line 775: MTL_UOM_CONVERSIONS MTLUCV,

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
779: MTLUCV.uom_code = MTLUOM2.uom_code AND

Line 794: MTL_UOM_CONVERSIONS MTLUCV,

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
798: MTLUCV.inventory_item_id = p_item_id AND

Line 809: MTL_UOM_CONVERSIONS MTLUCV,

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
813: MTLUCV.uom_code = MTLUOM2.uom_code AND

Line 822: MTL_UOM_CONVERSIONS MTLUCV,

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
826: MTLUCV.uom_code = MTLUOM2.uom_code AND

Line 839: MTL_UOM_CONVERSIONS MTLUCV,

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
843: MTLUCV.uom_code = MTLUOM2.uom_code AND

Line 860: MTL_UOM_CONVERSIONS MTLUCV,

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
864: MTLUCV.uom_code = MTLUOM2.uom_code AND

Line 881: MTL_UOM_CONVERSIONS MTLUCV,

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
885: MTLUCV.uom_code = MTLUOM2.uom_code AND