[Home] [Help]
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)
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)
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;
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;
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
809: MTLUCV.uom_code = MTLUOM2.uom_code AND
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
828: MTLUCV.inventory_item_id = p_item_id AND
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
843: MTLUCV.uom_code = MTLUOM2.uom_code 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
856: MTLUCV.uom_code = MTLUOM2.uom_code AND
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
873: MTLUCV.uom_code = MTLUOM2.uom_code AND
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
894: MTLUCV.uom_code = MTLUOM2.uom_code AND
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
915: MTLUCV.uom_code = MTLUOM2.uom_code AND
1774:
1775: BEGIN
1776: SELECT 'Y'
1777: INTO l_conversion_exists
1778: FROM mtl_uom_conversions
1779: WHERE inventory_item_id = p_item_id
1780: AND uom_code = p_to_uom_code ;
1781: EXCEPTION
1782: WHEN no_data_found THEN
1787: ELSE
1788: BEGIN
1789: SELECT 'Y'
1790: INTO l_conversion_exists
1791: FROM mtl_uom_conversions
1792: WHERE inventory_item_id = 0
1793: AND uom_code = p_to_uom_code ;
1794: EXCEPTION
1795: WHEN no_data_found THEN
1799:
1800: END IF ;
1801:
1802: IF l_conversion_exists = 'N' THEN
1803: INSERT INTO mtl_uom_conversions
1804: (inventory_item_id,
1805: unit_of_measure,
1806: uom_code,
1807: uom_class,