View: EAM_WORK_ASSET_ROUTE_V

Product:	EAM - Enterprise Asset Management
Description:	The view shows the work order route infromation
Implementation/DBA Data:	APPS.EAM_WORK_ASSET_ROUTE_V

View Text

SELECT WDJ.WIP_ENTITY_ID
, MENA.START_DATE_ACTIVE
, MENA.END_DATE_ACTIVE
, CII.INSTANCE_NUMBER
, CII.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, WDJ.MAINTENANCE_OBJECT_ID
, WDJ.ORGANIZATION_ID
FROM WIP_DISCRETE_JOBS WDJ
, MTL_EAM_NETWORK_ASSETS MENA
, CSI_ITEM_INSTANCES CII
, EAM_WORK_ORDER_ROUTE EWOR
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE WDJ.WIP_ENTITY_ID = EWOR.WIP_ENTITY_ID
AND CII.INSTANCE_ID = EWOR.INSTANCE_ID
AND MENA.NETWORK_OBJECT_ID = WDJ.MAINTENANCE_OBJECT_ID
AND MENA.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID UNION SELECT NULL
, MENA.START_DATE_ACTIVE
, MENA.END_DATE_ACTIVE
, CII.INSTANCE_NUMBER
, CII.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, MENA.NETWORK_OBJECT_ID
, MP.MAINT_ORGANIZATION_ID
FROM MTL_EAM_NETWORK_ASSETS MENA
, MTL_SYSTEM_ITEMS_KFV MSIK
, CSI_ITEM_INSTANCES CII
, MTL_PARAMETERS MP
WHERE MENA.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND MP.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND NVL(MENA.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(MENA.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE

Columns