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.WIP_EAM_WO_SRV_ASSOC_V

Source

View Text - Preformatted


SELECT we.wip_entity_name work_order_name, ewodv.WORK_ORDER_STATUS as status, bd.department_code, msibkfv1.concatenated_segments asset_group, cii.instance_number asset_number, msibkfv2.concatenated_segments activity, mp.organization_code , mlu1.meaning priority, decode(wdj.firm_planned_flag,1,'Y',2,'N','N') firm_flag, wdj.description, ewosa.service_request_id, wdj.requested_start_date, wdj.due_date, wdj.scheduled_start_date, wdj.scheduled_completion_date, trunc((wdj.scheduled_completion_date-wdj.scheduled_start_date)*24,2) duration, decode(wdj.status_type,17,to_date(null),1,to_date(null),wdj.scheduled_start_date) actual_start_date, wdj.date_completed actual_end_date, wdj.date_completed, wdj.owning_department department_id, wdj.wip_entity_id , wdj.organization_id , wdj.priority priority_id, ewodv.USER_DEFINED_STATUS_ID status_id, nvl(wdj.asset_group_id,rebuild_item_id) inventory_item_id, wdj.primary_item_id activity_id, wdj.date_closed, mlu3.meaning asset_type, wdj.date_released from (select * from eam_wo_service_association where enable_flag is null or enable_flag = 'Y') ewosa, wip_discrete_jobs wdj, wip_entities we, bom_departments bd, mtl_system_items_b_kfv msibkfv1, mtl_parameters mp, mtl_parameters mp1, mfg_lookups mlu1, eam_work_order_details_v ewodv, mfg_lookups mlu3, mtl_system_items_b_kfv msibkfv2, csi_item_instances cii WHERE msibkfv1.eam_item_type=mlu3.lookup_code(+) and mlu3.lookup_type (+) ='MTL_EAM_ASSET_TYPE' and wdj.wip_entity_id=ewosa.wip_entity_id and we.wip_entity_id=wdj.wip_entity_id and we.organization_id=wdj.organization_id and nvl(wdj.asset_group_id,rebuild_item_id)=msibkfv1.inventory_item_id and wdj.organization_id= mp1.maint_organization_id and mp1.organization_id = msibkfv1.organization_id and wdj.owning_department=bd.department_id(+) and wdj.organization_id=bd.organization_id(+) and mp.organization_id=wdj.organization_id and wdj.priority=mlu1.lookup_code(+) and mlu1.lookup_type(+)='WIP_EAM_ACTIVITY_PRIORITY' and mlu1.enabled_flag(+)='Y' and msibkfv2.inventory_item_id(+)=wdj.primary_item_id and msibkfv2.organization_id(+)=wdj.organization_id and wdj.maintenance_object_id= cii.instance_id and wdj.maintenance_object_type = 3 and ewodv.organization_id = wdj.organization_id and ewodv.wip_entity_id = wdj.wip_entity_id union all select we.wip_entity_name work_order_name, ewodv.WORK_ORDER_STATUS as status, bd.department_code, msibkfv1.concatenated_segments asset_group, null asset_number, msibkfv2.concatenated_segments activity, mp.organization_code , mlu1.meaning priority, decode(wdj.firm_planned_flag,1,'Y',2,'N','N') firm_flag, wdj.description, ewosa.service_request_id, wdj.requested_start_date, wdj.due_date, wdj.scheduled_start_date, wdj.scheduled_completion_date, trunc((wdj.scheduled_completion_date-wdj.scheduled_start_date)*24,2) duration, decode(wdj.status_type,17,to_date(null),1,to_date(null),wdj.scheduled_start_date) actual_start_date, wdj.date_completed actual_end_date, wdj.date_completed, wdj.owning_department department_id, wdj.wip_entity_id , wdj.organization_id , wdj.priority priority_id, ewodv.USER_DEFINED_STATUS_ID status_id, rebuild_item_id inventory_item_id, wdj.primary_item_id activity_id, wdj.date_closed, mlu3.meaning asset_type, wdj.date_released from (select * from eam_wo_service_association where enable_flag is null or enable_flag = 'Y') ewosa, wip_discrete_jobs wdj, wip_entities we, bom_departments bd, mtl_system_items_b_kfv msibkfv1, mtl_parameters mp, mtl_parameters mp1, mfg_lookups mlu1, eam_work_order_details_v ewodv, mfg_lookups mlu3, mtl_system_items_b_kfv msibkfv2 where msibkfv1.eam_item_type=mlu3.lookup_code(+) and mlu3.lookup_type (+) ='MTL_EAM_ASSET_TYPE' and wdj.wip_entity_id=ewosa.wip_entity_id and we.wip_entity_id=wdj.wip_entity_id and we.organization_id=wdj.organization_id and nvl(wdj.asset_group_id,rebuild_item_id)=msibkfv1.inventory_item_id and wdj.organization_id= mp1.maint_organization_id and mp1.organization_id = msibkfv1.organization_id and wdj.owning_department=bd.department_id(+) and wdj.organization_id=bd.organization_id(+) and mp.organization_id=wdj.organization_id and wdj.priority=mlu1.lookup_code(+) and mlu1.lookup_type(+)='WIP_EAM_ACTIVITY_PRIORITY' and mlu1.enabled_flag(+)='Y' and msibkfv2.inventory_item_id(+)=wdj.primary_item_id and msibkfv2.organization_id(+)=wdj.organization_id and wdj.maintenance_object_type = 2 and ewodv.organization_id = wdj.organization_id and ewodv.wip_entity_id = wdj.wip_entity_id

View Text - HTML Formatted

SELECT WE.WIP_ENTITY_NAME WORK_ORDER_NAME
, EWODV.WORK_ORDER_STATUS AS STATUS
, BD.DEPARTMENT_CODE
, MSIBKFV1.CONCATENATED_SEGMENTS ASSET_GROUP
, CII.INSTANCE_NUMBER ASSET_NUMBER
, MSIBKFV2.CONCATENATED_SEGMENTS ACTIVITY
, MP.ORGANIZATION_CODE
, MLU1.MEANING PRIORITY
, DECODE(WDJ.FIRM_PLANNED_FLAG
, 1
, 'Y'
, 2
, 'N'
, 'N') FIRM_FLAG
, WDJ.DESCRIPTION
, EWOSA.SERVICE_REQUEST_ID
, WDJ.REQUESTED_START_DATE
, WDJ.DUE_DATE
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, TRUNC((WDJ.SCHEDULED_COMPLETION_DATE-WDJ.SCHEDULED_START_DATE)*24
, 2) DURATION
, DECODE(WDJ.STATUS_TYPE
, 17
, TO_DATE(NULL)
, 1
, TO_DATE(NULL)
, WDJ.SCHEDULED_START_DATE) ACTUAL_START_DATE
, WDJ.DATE_COMPLETED ACTUAL_END_DATE
, WDJ.DATE_COMPLETED
, WDJ.OWNING_DEPARTMENT DEPARTMENT_ID
, WDJ.WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID
, WDJ.PRIORITY PRIORITY_ID
, EWODV.USER_DEFINED_STATUS_ID STATUS_ID
, NVL(WDJ.ASSET_GROUP_ID
, REBUILD_ITEM_ID) INVENTORY_ITEM_ID
, WDJ.PRIMARY_ITEM_ID ACTIVITY_ID
, WDJ.DATE_CLOSED
, MLU3.MEANING ASSET_TYPE
, WDJ.DATE_RELEASED
FROM (SELECT *
FROM EAM_WO_SERVICE_ASSOCIATION
WHERE ENABLE_FLAG IS NULL OR ENABLE_FLAG = 'Y') EWOSA
, WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, BOM_DEPARTMENTS BD
, MTL_SYSTEM_ITEMS_B_KFV MSIBKFV1
, MTL_PARAMETERS MP
, MTL_PARAMETERS MP1
, MFG_LOOKUPS MLU1
, EAM_WORK_ORDER_DETAILS_V EWODV
, MFG_LOOKUPS MLU3
, MTL_SYSTEM_ITEMS_B_KFV MSIBKFV2
, CSI_ITEM_INSTANCES CII
WHERE MSIBKFV1.EAM_ITEM_TYPE=MLU3.LOOKUP_CODE(+)
AND MLU3.LOOKUP_TYPE (+) ='MTL_EAM_ASSET_TYPE'
AND WDJ.WIP_ENTITY_ID=EWOSA.WIP_ENTITY_ID
AND WE.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND NVL(WDJ.ASSET_GROUP_ID
, REBUILD_ITEM_ID)=MSIBKFV1.INVENTORY_ITEM_ID
AND WDJ.ORGANIZATION_ID= MP1.MAINT_ORGANIZATION_ID
AND MP1.ORGANIZATION_ID = MSIBKFV1.ORGANIZATION_ID
AND WDJ.OWNING_DEPARTMENT=BD.DEPARTMENT_ID(+)
AND WDJ.ORGANIZATION_ID=BD.ORGANIZATION_ID(+)
AND MP.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WDJ.PRIORITY=MLU1.LOOKUP_CODE(+)
AND MLU1.LOOKUP_TYPE(+)='WIP_EAM_ACTIVITY_PRIORITY'
AND MLU1.ENABLED_FLAG(+)='Y'
AND MSIBKFV2.INVENTORY_ITEM_ID(+)=WDJ.PRIMARY_ITEM_ID
AND MSIBKFV2.ORGANIZATION_ID(+)=WDJ.ORGANIZATION_ID
AND WDJ.MAINTENANCE_OBJECT_ID= CII.INSTANCE_ID
AND WDJ.MAINTENANCE_OBJECT_TYPE = 3
AND EWODV.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND EWODV.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID UNION ALL SELECT WE.WIP_ENTITY_NAME WORK_ORDER_NAME
, EWODV.WORK_ORDER_STATUS AS STATUS
, BD.DEPARTMENT_CODE
, MSIBKFV1.CONCATENATED_SEGMENTS ASSET_GROUP
, NULL ASSET_NUMBER
, MSIBKFV2.CONCATENATED_SEGMENTS ACTIVITY
, MP.ORGANIZATION_CODE
, MLU1.MEANING PRIORITY
, DECODE(WDJ.FIRM_PLANNED_FLAG
, 1
, 'Y'
, 2
, 'N'
, 'N') FIRM_FLAG
, WDJ.DESCRIPTION
, EWOSA.SERVICE_REQUEST_ID
, WDJ.REQUESTED_START_DATE
, WDJ.DUE_DATE
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, TRUNC((WDJ.SCHEDULED_COMPLETION_DATE-WDJ.SCHEDULED_START_DATE)*24
, 2) DURATION
, DECODE(WDJ.STATUS_TYPE
, 17
, TO_DATE(NULL)
, 1
, TO_DATE(NULL)
, WDJ.SCHEDULED_START_DATE) ACTUAL_START_DATE
, WDJ.DATE_COMPLETED ACTUAL_END_DATE
, WDJ.DATE_COMPLETED
, WDJ.OWNING_DEPARTMENT DEPARTMENT_ID
, WDJ.WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID
, WDJ.PRIORITY PRIORITY_ID
, EWODV.USER_DEFINED_STATUS_ID STATUS_ID
, REBUILD_ITEM_ID INVENTORY_ITEM_ID
, WDJ.PRIMARY_ITEM_ID ACTIVITY_ID
, WDJ.DATE_CLOSED
, MLU3.MEANING ASSET_TYPE
, WDJ.DATE_RELEASED
FROM (SELECT *
FROM EAM_WO_SERVICE_ASSOCIATION
WHERE ENABLE_FLAG IS NULL OR ENABLE_FLAG = 'Y') EWOSA
, WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, BOM_DEPARTMENTS BD
, MTL_SYSTEM_ITEMS_B_KFV MSIBKFV1
, MTL_PARAMETERS MP
, MTL_PARAMETERS MP1
, MFG_LOOKUPS MLU1
, EAM_WORK_ORDER_DETAILS_V EWODV
, MFG_LOOKUPS MLU3
, MTL_SYSTEM_ITEMS_B_KFV MSIBKFV2
WHERE MSIBKFV1.EAM_ITEM_TYPE=MLU3.LOOKUP_CODE(+)
AND MLU3.LOOKUP_TYPE (+) ='MTL_EAM_ASSET_TYPE'
AND WDJ.WIP_ENTITY_ID=EWOSA.WIP_ENTITY_ID
AND WE.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND NVL(WDJ.ASSET_GROUP_ID
, REBUILD_ITEM_ID)=MSIBKFV1.INVENTORY_ITEM_ID
AND WDJ.ORGANIZATION_ID= MP1.MAINT_ORGANIZATION_ID
AND MP1.ORGANIZATION_ID = MSIBKFV1.ORGANIZATION_ID
AND WDJ.OWNING_DEPARTMENT=BD.DEPARTMENT_ID(+)
AND WDJ.ORGANIZATION_ID=BD.ORGANIZATION_ID(+)
AND MP.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WDJ.PRIORITY=MLU1.LOOKUP_CODE(+)
AND MLU1.LOOKUP_TYPE(+)='WIP_EAM_ACTIVITY_PRIORITY'
AND MLU1.ENABLED_FLAG(+)='Y'
AND MSIBKFV2.INVENTORY_ITEM_ID(+)=WDJ.PRIMARY_ITEM_ID
AND MSIBKFV2.ORGANIZATION_ID(+)=WDJ.ORGANIZATION_ID
AND WDJ.MAINTENANCE_OBJECT_TYPE = 2
AND EWODV.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND EWODV.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID