[Home] [Help]
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
Name |
CONCATENATED_SEGMENTS |
INVENTORY_ITEM_ID |
MAINT_ORGANIZATION_ID |
ORGANIZATION_ID |
DESCRIPTION |
MEANING |
EAM_ITEM_TYPE |
SERIAL_NUMBER_CONTROL_CODE |