View: MTL_EAM_ITEMS_V

Product:	INV - Inventory
Description:	View of all EAM items.
Implementation/DBA Data:	APPS.MTL_EAM_ITEMS_V

View Text

SELECT MSI.CONCATENATED_SEGMENTS
, MSI.INVENTORY_ITEM_ID
, MP.MAINT_ORGANIZATION_ID
, MSI.ORGANIZATION_ID
, MSI.DESCRIPTION
, ML.MEANING
, MSI.EAM_ITEM_TYPE
, MSI.SERIAL_NUMBER_CONTROL_CODE
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS MP
, MFG_LOOKUPS ML
WHERE MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ML.LOOKUP_TYPE = 'MTL_EAM_ASSET_TYPE'
AND ML.LOOKUP_CODE = MSI.EAM_ITEM_TYPE
AND SYSDATE BETWEEN NVL(ML.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(ML.END_DATE_ACTIVE
, SYSDATE+1)
AND ML.ENABLED_FLAG = 'Y'

Columns