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.

[Home] [Help]

View: AHL_WORKORDER_OPERATIONS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	Ahl WorkOrder Operations view.
Implementation/DBA Data:	APPS.AHL_WORKORDER_OPERATIONS_V

View Text

SELECT WOP.WORKORDER_OPERATION_ID
, WIP.ORGANIZATION_ID
, WOP.OPERATION_SEQUENCE_NUM
, WOP.WORKORDER_ID
, WIP.WIP_ENTITY_ID
, WOP.OBJECT_VERSION_NUMBER
, WOP.LAST_UPDATE_DATE
, WOP.LAST_UPDATED_BY
, WOP.CREATION_DATE
, WOP.CREATED_BY
, WOP.LAST_UPDATE_LOGIN
, WIP.DEPARTMENT_ID
, BMD.DEPARTMENT_CODE
, BMD.DESCRIPTION
, WOP.OPERATION_ID
, RMK.CONCATENATED_SEGMENTS
, WOP.OPERATION_TYPE_CODE
, OPTYPE.MEANING
, WOP.STATUS_CODE
, OPST.MEANING
, WIP.FIRST_UNIT_START_DATE
, TO_CHAR(WIP.FIRST_UNIT_START_DATE
, 'HH24')
, TO_CHAR(WIP.FIRST_UNIT_START_DATE
, 'MI')
, WIP.LAST_UNIT_COMPLETION_DATE
, TO_CHAR(WIP.LAST_UNIT_COMPLETION_DATE
, 'HH24')
, TO_CHAR(WIP.LAST_UNIT_COMPLETION_DATE
, 'MI')
, WOP.ACTUAL_START_DATE
, TO_CHAR(WOP.ACTUAL_START_DATE
, 'HH24')
, TO_CHAR(WOP.ACTUAL_START_DATE
, 'MI')
, WOP.ACTUAL_END_DATE
, TO_CHAR(WOP.ACTUAL_END_DATE
, 'HH24')
, TO_CHAR(WOP.ACTUAL_END_DATE
, 'MI')
, WOP.PLAN_ID
, WOP.COLLECTION_ID
, WIP.DESCRIPTION
, WOP.SECURITY_GROUP_ID
, WOP.ATTRIBUTE_CATEGORY
, WOP.ATTRIBUTE1
, WOP.ATTRIBUTE2
, WOP.ATTRIBUTE3
, WOP.ATTRIBUTE4
, WOP.ATTRIBUTE5
, WOP.ATTRIBUTE6
, WOP.ATTRIBUTE7
, WOP.ATTRIBUTE8
, WOP.ATTRIBUTE9
, WOP.ATTRIBUTE10
, WOP.ATTRIBUTE11
, WOP.ATTRIBUTE12
, WOP.ATTRIBUTE13
, WOP.ATTRIBUTE14
, WOP.ATTRIBUTE15
FROM AHL_WORKORDER_OPERATIONS WOP
, WIP_OPERATIONS WIP
, AHL_WORKORDERS AWO
, AHL_OPERATIONS_B_KFV RMK
, BOM_DEPARTMENTS BMD
, FND_LOOKUP_VALUES_VL OPTYPE
, FND_LOOKUP_VALUES_VL OPST
WHERE WOP.OPERATION_ID = RMK.OPERATION_ID(+)
AND WOP.WORKORDER_ID = AWO.WORKORDER_ID
AND AWO.WIP_ENTITY_ID= WIP.WIP_ENTITY_ID
AND WOP.OPERATION_SEQUENCE_NUM = WIP.OPERATION_SEQ_NUM
AND WIP.DEPARTMENT_ID=BMD.DEPARTMENT_ID
AND OPTYPE.LOOKUP_TYPE(+)='AHL_OPERATION_TYPE'
AND OPTYPE.LOOKUP_CODE(+) = WOP.OPERATION_TYPE_CODE
AND OPST.LOOKUP_TYPE(+)= 'AHL_OPERATION_STATUS'
AND OPST.LOOKUP_CODE(+) = WOP.STATUS_CODE

Columns

Name
WORKORDER_OPERATION_ID
ORGANIZATION_ID
OPERATION_SEQUENCE_NUM
WORKORDER_ID
WIP_ENTITY_ID
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
DEPARTMENT_ID
DEPARTMENT_CODE
DEPARTMENT_NAME
OPERATION_ID
OPERATION_CODE
OPERATION_TYPE_CODE
OPERATION_TYPE
STATUS_CODE
STATUS
SCHEDULED_START_DATE
SCHEDULED_START_HR
SCHEDULED_START_MI
SCHEDULED_END_DATE
SCHEDULED_END_HR
SCHEDULED_END_MI
ACTUAL_START_DATE
ACTUAL_START_HR
ACTUAL_START_MI
ACTUAL_END_DATE
ACTUAL_END_HR
ACTUAL_END_MI
PLAN_ID
COLLECTION_ID
DESCRIPTION
SECURITY_GROUP_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15