[Home] [Help]
2056: WO.workorder_id = UE.ORIGINATING_WO_ID
2057: and WO.unit_effectivity_id = UE.unit_effectivity_id) OriginatingWorkorder,
2058: WO.item_instance_id,
2059: decode(WO.plan_id,null,'F','T') isQualityEnabled
2060: FROM AHL_WORKORDERS_V WO, WIP_DISCRETE_JOBS WIP, AHL_ROUTES_V RO, AHL_UNIT_EFFECTIVITIES_B UE, HZ_PARTIES HZ, CSI_ITEM_INSTANCES CSI
2061: WHERE WO.wip_entity_id = WIP.wip_entity_id
2062: AND WO.route_id = RO.route_id (+)
2063: AND UE.unit_effectivity_id(+) = WO.unit_effectivity_id
2064: AND CSI.instance_id = WO.ITEM_INSTANCE_ID(+)
2101: AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID
2102: )
2103: INCIDENT_NUMBER,
2104: (SELECT HZ.PARTY_NAME
2105: FROM HZ_PARTIES HZ
2106: WHERE HZ.PARTY_ID = CSI.OWNER_PARTY_ID
2107: )
2108: PARTY_NAME,
2109: (SELECT WORKORDER_NAME
2119: FROM AHL_WORKORDER_TASKS_V WO ,
2120: WIP_DISCRETE_JOBS WIP ,
2121: AHL_ROUTES_B RO ,
2122: AHL_UNIT_EFFECTIVITIES_B UE ,
2123: --HZ_PARTIES HZ ,
2124: CSI_ITEM_INSTANCES CSI ,
2125: --CS_INCIDENTS_ALL_B CSIN ,
2126: --AHL_VISIT_TASKS_VL VTS ,
2127: AHL_WORKORDERS W ,
2592: CSI_ITEM_INSTANCES CSI ,
2593: CS_INCIDENTS_ALL_B CS,
2594: AHL_WORKORDERS WO,
2595: AHL_VISIT_TASKS_B VISIT_TASK,
2596: HZ_PARTIES PARTY ,
2597: CS_INCIDENT_TYPES_TL CS_TYPE,
2598: (SELECT INCIDENT_ID ,
2599: PARTY_ID ,
2600: CONTACT_TYPE
7869: INCIDENTDET.INCIDENT_NUMBER,
7870: INCIDENTDET.NAME INCIDENT_TYPE,
7871: INCIDENTDET.SUMMARY INCIDENT_SUMMARY,
7872: (SELECT HZ.PARTY_NAME
7873: FROM HZ_PARTIES HZ
7874: WHERE HZ.PARTY_ID = CSI.OWNER_PARTY_ID
7875: )
7876: PARTY_NAME,
7877: (SELECT WORKORDER_NAME
7887: FROM AHL_WORKORDER_TASKS_V WO ,
7888: WIP_DISCRETE_JOBS WIP ,
7889: AHL_ROUTES_B RO ,
7890: AHL_UNIT_EFFECTIVITIES_B UE ,
7891: --HZ_PARTIES HZ ,
7892: CSI_ITEM_INSTANCES CSI ,
7893: --CS_INCIDENTS_ALL_B CSIN ,
7894: --AHL_VISIT_TASKS_VL VTS ,
7895: AHL_WORKORDERS W ,