eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EAM_WORKORDER_DOWNTIME_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')