VIEW: APPS.AHL_WORKORDER_OPERATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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