MSC_ATP_UOM_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ITEMCODE TOUNIT UNITTYPE FACTOR

Query

SQL_Statement

SELECT DISTINCT 'STANDARD' itemcode, msc_units_of_measure.uom_code tounit, msc_units_of_measure.uom_class unittype, 1 factor FROM msc_units_of_measure WHERE base_uom_flag = 'Y' UNION ALL SELECT DISTINCT 'STANDARD' itemcode, msc_uom_conversions.uom_code tounit, msc_uom_conversions.uom_class unittype, msc_uom_conversions.conversion_rate factor FROM msc_uom_conversions, MSC_UNITS_OF_MEASURE WHERE msc_uom_conversions.inventory_item_id = 0 AND MSC_UNITS_OF_MEASURE.uom_code= msc_uom_conversions.uom_code AND MSC_UNITS_OF_MEASURE.base_uom_flag <> 'Y' UNION ALL SELECT to_char(msc_uom_class_conversions.inventory_item_id) itemcode, msc_uom_class_conversions.to_uom_code tounit, msc_uom_class_conversions.to_uom_class unittype, msc_uom_class_conversions.conversion_rate factor FROM msc_uom_class_conversions WHERE inventory_item_id <> 0 AND from_uom_code = (select uom_code from msc_system_items where inventory_item_id = msc_uom_class_conversions.inventory_item_id and rownum = 1) UNION ALL SELECT TO_CHAR(msc_uom_conversions.inventory_item_id) itemcode, msc_uom_conversions.uom_code tounit, msc_uom_conversions.uom_class unittype, msc_uom_conversions.conversion_rate factor FROM msc_uom_conversions WHERE msc_uom_conversions.inventory_item_id <> 0 UNION ALL SELECT DISTINCT to_char(msc_uom_class_conversions.inventory_item_id) itemcode, msc_uom_class_conversions.from_uom_code tounit, msc_uom_class_conversions.from_uom_class unittype, 1 factor FROM msc_uom_class_conversions WHERE inventory_item_id <> 0 AND from_uom_code = (select uom_code from msc_system_items where inventory_item_id = msc_uom_class_conversions.inventory_item_id and rownum = 1) UNION SELECT TO_CHAR(uom.inventory_item_id) itemcode, base.uom_code tounit, base.uom_class unittype, 1 factor FROM msc_uom_conversions uom, MSC_UNITS_OF_MEASURE base, MSC_UNITS_OF_MEASURE nonbase WHERE uom.inventory_item_id <> 0 AND nonbase.uom_code = uom.uom_code AND nonbase.uom_class = base.uom_class AND base.base_uom_flag = 'Y'