View: EAM_WORKORDER_DOWNTIME_V

Product:	EAM - Enterprise Asset Management
Description:	Downtime view by work order/operation
Implementation/DBA Data:	APPS.EAM_WORKORDER_DOWNTIME_V

View Text

SELECT WDJ.ORGANIZATION_ID MAINT_ORG_ID
, MSN.CURRENT_ORGANIZATION_ID PROD_ORG_ID
, WDJ.WIP_ENTITY_ID WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME WORKORDER_NUMBER
, WDJ.ASSET_GROUP_ID ASSET_GROUP_ID
, CII.INSTANCE_NUMBER ASSET_NUMBER
, TO_NUMBER(NULL) OP_SEQ
, WDJ.SCHEDULED_START_DATE FROM_DATE
, WDJ.SCHEDULED_COMPLETION_DATE TO_DATE
, MSN.INVENTORY_ITEM_ID EQUIPMENT_ITEM_ID
, MSN.SERIAL_NUMBER EQP_SERIAL_NUMBER
, WDJ.SHUTDOWN_TYPE SHUTDOWN_TYPE
, WDJ.STATUS_TYPE STATUS_TYPE
, WDJ.FIRM_PLANNED_FLAG FIRM_FLAG
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, MTL_SERIAL_NUMBERS MSN
, CSI_ITEM_INSTANCES CII
WHERE WE.ENTITY_TYPE = 6
AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WDJ.SHUTDOWN_TYPE IN ('2'
, '3')
AND WDJ.MAINTENANCE_OBJECT_TYPE = 3
AND WDJ.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND CII.EQUIPMENT_GEN_OBJECT_ID = MSN.GEN_OBJECT_ID
AND CII.NETWORK_ASSET_FLAG = 'N' UNION ALL SELECT WDJ.ORGANIZATION_ID MAINT_ORG_ID
, MSN.CURRENT_ORGANIZATION_ID PROD_ORG_ID
, WDJ.WIP_ENTITY_ID WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME WORKORDER_NUMBER
, WDJ.ASSET_GROUP_ID ASSET_GROUP_ID
, CII.INSTANCE_NUMBER ASSET_NUMBER
, WO.OPERATION_SEQ_NUM OP_SEQ
, WO.FIRST_UNIT_START_DATE FROM_DATE
, WO.LAST_UNIT_COMPLETION_DATE TO_DATE
, MSN.INVENTORY_ITEM_ID EQUIPMENT_ITEM_ID
, MSN.SERIAL_NUMBER EQP_SERIAL_NUMBER
, WO.SHUTDOWN_TYPE SHUTDOWN_TYPE
, WDJ.STATUS_TYPE STATUS_TYPE
, WDJ.FIRM_PLANNED_FLAG FIRM_FLAG
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, MTL_SERIAL_NUMBERS MSN
, WIP_OPERATIONS WO
, CSI_ITEM_INSTANCES CII
WHERE WE.ENTITY_TYPE = 6
AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND NVL(WDJ.SHUTDOWN_TYPE
, '0') NOT IN ('2'
, '3')
AND WDJ.MAINTENANCE_OBJECT_TYPE = 3
AND WDJ.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND CII.EQUIPMENT_GEN_OBJECT_ID = MSN.GEN_OBJECT_ID
AND CII.NETWORK_ASSET_FLAG = 'N'
AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND WO.SHUTDOWN_TYPE IN ('2'
, '3')

Columns