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

Source

View Text - Preformatted


SELECT WO.WORKORDER_ID, WO.WIP_ENTITY_ID, WO.OBJECT_VERSION_NUMBER, WO.WORKORDER_NAME JOB_NUMBER, WDJ.DESCRIPTION, VST.ORGANIZATION_ID, ORGN.ORGANIZATION_NAME, BMD.DESCRIPTION, WDJ.OWNING_DEPARTMENT, BMD.DEPARTMENT_CLASS_CODE, BMD.DEPARTMENT_CODE, WO.STATUS_CODE, MLU.MEANING, WDJ.SCHEDULED_START_DATE, TO_CHAR (WDJ.SCHEDULED_START_DATE,'HH24'), TO_CHAR (WDJ.SCHEDULED_START_DATE,'MI'), WDJ.SCHEDULED_COMPLETION_DATE, TO_CHAR (WDJ.SCHEDULED_COMPLETION_DATE,'HH24'), TO_CHAR (WDJ.SCHEDULED_COMPLETION_DATE,'MI'), WO.ACTUAL_START_DATE, TO_CHAR (WO.ACTUAL_START_DATE,'HH24'), TO_CHAR (WO.ACTUAL_START_DATE,'MI'), WO.ACTUAL_END_DATE, TO_CHAR (WO.ACTUAL_END_DATE,'HH24'), TO_CHAR (WO.ACTUAL_END_DATE,'MI'), VTS.INVENTORY_ITEM_ID, NVL(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID), AHL_UTILITY_PVT.GET_UNIT_NAME(NVL(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)), CSI.INSTANCE_NUMBER, CSI.QUANTITY, MTLI.CONCATENATED_SEGMENTS, MTLI.DESCRIPTION, CSI.SERIAL_NUMBER, CSI.UNIT_OF_MEASURE, WDJ.COMPLETION_SUBINVENTORY, WDJ.COMPLETION_LOCATOR_ID, (select MLC.CONCATENATED_SEGMENTS from MTL_ITEM_LOCATIONS_KFV MLC WHERE WDJ.COMPLETION_LOCATOR_ID=MLC.INVENTORY_LOCATION_ID) completion_locator_name, VST.VISIT_ID, VST.VISIT_NUMBER, VST.VISIT_NAME, WO.VISIT_TASK_ID, VST.STATUS_CODE, VTS.VISIT_TASK_NUMBER, VTS.MR_ROUTE_ID, WO.ROUTE_ID, WDJ.CLASS_CODE, VTS.UNIT_EFFECTIVITY_ID, WDJ.PRIORITY, (select MLK.MEANING from MFG_LOOKUPS MLK where MLK.LOOKUP_TYPE ='WIP_EAM_ACTIVITY_PRIORITY' AND WDJ.PRIORITY=MLK.LOOKUP_CODE), WO.CONFIRM_FAILURE_FLAG, CSI.LOT_NUMBER, WDJ.FIRM_PLANNED_FLAG, WO.ATTRIBUTE_CATEGORY, WO.ATTRIBUTE1, WO.ATTRIBUTE2, WO.ATTRIBUTE3, WO.ATTRIBUTE4, WO.ATTRIBUTE5, WO.ATTRIBUTE6, WO.ATTRIBUTE7, WO.ATTRIBUTE8, WO.ATTRIBUTE9, WO.ATTRIBUTE10, WO.ATTRIBUTE11, WO.ATTRIBUTE12, WO.ATTRIBUTE13, WO.ATTRIBUTE14, WO.ATTRIBUTE15, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY, WO.CREATION_DATE, WO.CREATED_BY, WO.LAST_UPDATE_LOGIN, AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(NVL(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)) UC_HEADER_ID, AHL_UTIL_UC_PKG.Is_Unit_Quarantined(NULL, NVL(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)), AHL_COMPLETIONS_PVT.are_all_operations_complete(WO.WORKORDER_ID), WO.HOLD_REASON_CODE, (SELECT MEANING FROM FND_LOOKUP_VALUES_VL WHERE LOOKUP_TYPE = 'AHL_PRD_WO_HOLD_REASON' and LOOKUP_CODE = WO.HOLD_REASON_CODE) HOLD_REASON FROM AHL_WORKORDERS WO, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS, INV_ORGANIZATION_NAME_V ORGN, (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG, BOM_DEPARTMENTS BMD, FND_LOOKUP_VALUES_VL MLU, CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTLI, WIP_DISCRETE_JOBS WDJ WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID AND VST.VISIT_ID=VTS.VISIT_ID AND WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID AND ORGN.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND VST.ORGANIZATION_ID=ORGN.ORGANIZATION_ID AND VST.ORGANIZATION_ID=MTLI.ORGANIZATION_ID AND VTS.INVENTORY_ITEM_ID=MTLI.INVENTORY_ITEM_ID AND NVL(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)=CSI.INSTANCE_ID AND MLU.LOOKUP_TYPE ='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE AND WO.MASTER_WORKORDER_FLAG = 'N' AND WO.STATUS_CODE NOT IN ( '17' , '22' ) AND WDJ.OWNING_DEPARTMENT=BMD.DEPARTMENT_ID(+)

View Text - HTML Formatted

SELECT WO.WORKORDER_ID
, WO.WIP_ENTITY_ID
, WO.OBJECT_VERSION_NUMBER
, WO.WORKORDER_NAME JOB_NUMBER
, WDJ.DESCRIPTION
, VST.ORGANIZATION_ID
, ORGN.ORGANIZATION_NAME
, BMD.DESCRIPTION
, WDJ.OWNING_DEPARTMENT
, BMD.DEPARTMENT_CLASS_CODE
, BMD.DEPARTMENT_CODE
, WO.STATUS_CODE
, MLU.MEANING
, WDJ.SCHEDULED_START_DATE
, TO_CHAR (WDJ.SCHEDULED_START_DATE
, 'HH24')
, TO_CHAR (WDJ.SCHEDULED_START_DATE
, 'MI')
, WDJ.SCHEDULED_COMPLETION_DATE
, TO_CHAR (WDJ.SCHEDULED_COMPLETION_DATE
, 'HH24')
, TO_CHAR (WDJ.SCHEDULED_COMPLETION_DATE
, 'MI')
, WO.ACTUAL_START_DATE
, TO_CHAR (WO.ACTUAL_START_DATE
, 'HH24')
, TO_CHAR (WO.ACTUAL_START_DATE
, 'MI')
, WO.ACTUAL_END_DATE
, TO_CHAR (WO.ACTUAL_END_DATE
, 'HH24')
, TO_CHAR (WO.ACTUAL_END_DATE
, 'MI')
, VTS.INVENTORY_ITEM_ID
, NVL(VTS.INSTANCE_ID
, VST.ITEM_INSTANCE_ID)
, AHL_UTILITY_PVT.GET_UNIT_NAME(NVL(VTS.INSTANCE_ID
, VST.ITEM_INSTANCE_ID))
, CSI.INSTANCE_NUMBER
, CSI.QUANTITY
, MTLI.CONCATENATED_SEGMENTS
, MTLI.DESCRIPTION
, CSI.SERIAL_NUMBER
, CSI.UNIT_OF_MEASURE
, WDJ.COMPLETION_SUBINVENTORY
, WDJ.COMPLETION_LOCATOR_ID
, (SELECT MLC.CONCATENATED_SEGMENTS
FROM MTL_ITEM_LOCATIONS_KFV MLC
WHERE WDJ.COMPLETION_LOCATOR_ID=MLC.INVENTORY_LOCATION_ID) COMPLETION_LOCATOR_NAME
, VST.VISIT_ID
, VST.VISIT_NUMBER
, VST.VISIT_NAME
, WO.VISIT_TASK_ID
, VST.STATUS_CODE
, VTS.VISIT_TASK_NUMBER
, VTS.MR_ROUTE_ID
, WO.ROUTE_ID
, WDJ.CLASS_CODE
, VTS.UNIT_EFFECTIVITY_ID
, WDJ.PRIORITY
, (SELECT MLK.MEANING
FROM MFG_LOOKUPS MLK
WHERE MLK.LOOKUP_TYPE ='WIP_EAM_ACTIVITY_PRIORITY'
AND WDJ.PRIORITY=MLK.LOOKUP_CODE)
, WO.CONFIRM_FAILURE_FLAG
, CSI.LOT_NUMBER
, WDJ.FIRM_PLANNED_FLAG
, WO.ATTRIBUTE_CATEGORY
, WO.ATTRIBUTE1
, WO.ATTRIBUTE2
, WO.ATTRIBUTE3
, WO.ATTRIBUTE4
, WO.ATTRIBUTE5
, WO.ATTRIBUTE6
, WO.ATTRIBUTE7
, WO.ATTRIBUTE8
, WO.ATTRIBUTE9
, WO.ATTRIBUTE10
, WO.ATTRIBUTE11
, WO.ATTRIBUTE12
, WO.ATTRIBUTE13
, WO.ATTRIBUTE14
, WO.ATTRIBUTE15
, WO.LAST_UPDATE_DATE
, WO.LAST_UPDATED_BY
, WO.CREATION_DATE
, WO.CREATED_BY
, WO.LAST_UPDATE_LOGIN
, AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(NVL(VTS.INSTANCE_ID
, VST.ITEM_INSTANCE_ID)) UC_HEADER_ID
, AHL_UTIL_UC_PKG.IS_UNIT_QUARANTINED(NULL
, NVL(VTS.INSTANCE_ID
, VST.ITEM_INSTANCE_ID))
, AHL_COMPLETIONS_PVT.ARE_ALL_OPERATIONS_COMPLETE(WO.WORKORDER_ID)
, WO.HOLD_REASON_CODE
, (SELECT MEANING
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE = 'AHL_PRD_WO_HOLD_REASON'
AND LOOKUP_CODE = WO.HOLD_REASON_CODE) HOLD_REASON
FROM AHL_WORKORDERS WO
, AHL_VISITS_VL VST
, AHL_VISIT_TASKS_VL VTS
, INV_ORGANIZATION_NAME_V ORGN
, (SELECT ORGANIZATION_ID
FROM INV_ORGANIZATION_INFO_V
WHERE NVL (OPERATING_UNIT
, MO_GLOBAL.GET_CURRENT_ORG_ID()) = MO_GLOBAL.GET_CURRENT_ORG_ID()) ORG
, BOM_DEPARTMENTS BMD
, FND_LOOKUP_VALUES_VL MLU
, CSI_ITEM_INSTANCES CSI
, MTL_SYSTEM_ITEMS_KFV MTLI
, WIP_DISCRETE_JOBS WDJ
WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
AND VST.VISIT_ID=VTS.VISIT_ID
AND WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
AND ORGN.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND VST.ORGANIZATION_ID=ORGN.ORGANIZATION_ID
AND VST.ORGANIZATION_ID=MTLI.ORGANIZATION_ID
AND VTS.INVENTORY_ITEM_ID=MTLI.INVENTORY_ITEM_ID
AND NVL(VTS.INSTANCE_ID
, VST.ITEM_INSTANCE_ID)=CSI.INSTANCE_ID
AND MLU.LOOKUP_TYPE ='AHL_JOB_STATUS'
AND WO.STATUS_CODE=MLU.LOOKUP_CODE
AND WO.MASTER_WORKORDER_FLAG = 'N'
AND WO.STATUS_CODE NOT IN ( '17'
, '22' )
AND WDJ.OWNING_DEPARTMENT=BMD.DEPARTMENT_ID(+)