View: JAI_CMN_UOM_DTLS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_UOM_DTLS_V

View Text

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

Columns