VIEW: APPS.JAI_CMN_UOM_DTLS_V

Source

View Text - Preformatted

SELECT DISTINCT unit_of_measure, uom_code, inventory_item_id, organization_id FROM (SELECT unit_of_measure, uom_code, inventory_item_id, to_number(NULL) ORGANIZATION_ID FROM MTL_UOM_CONVERSIONS WHERE (disable_date IS NULL OR disable_date+1 > SYSDATE ) UNION ALL SELECT to_unit_of_measure unit_of_measure, to_uom_code uom_code, inventory_item_id, to_number(NULL) ORGANIZATION_ID FROM mtl_uom_class_conversions WHERE (disable_date IS NULL OR disable_date+1 > SYSDATE ) ) UNION ALL SELECT PRIMARY_UNIT_OF_MEASURE, primary_uom_code, inventory_item_id, organization_id FROM mtl_system_items

View Text - HTML Formatted

SELECT DISTINCT UNIT_OF_MEASURE
, UOM_CODE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
FROM (SELECT UNIT_OF_MEASURE
, UOM_CODE
, INVENTORY_ITEM_ID
, TO_NUMBER(NULL) ORGANIZATION_ID
FROM MTL_UOM_CONVERSIONS
WHERE (DISABLE_DATE IS NULL OR DISABLE_DATE+1 > SYSDATE ) UNION ALL SELECT TO_UNIT_OF_MEASURE UNIT_OF_MEASURE
, TO_UOM_CODE UOM_CODE
, INVENTORY_ITEM_ID
, TO_NUMBER(NULL) ORGANIZATION_ID
FROM MTL_UOM_CLASS_CONVERSIONS
WHERE (DISABLE_DATE IS NULL OR DISABLE_DATE+1 > SYSDATE ) ) UNION ALL SELECT PRIMARY_UNIT_OF_MEASURE
, PRIMARY_UOM_CODE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS