VIEW: APPS.MTL_EAM_ITEMS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'