Product: | EAM - Enterprise Asset Management |
---|---|
Description: | This view displays information on operations for work orders. |
Implementation/DBA Data: | APPS.EAM_CFR_OPERATIONS_V |
SELECT WO.WIP_ENTITY_ID
, WO.OPERATION_SEQ_NUM
, WO.ORGANIZATION_ID
, WO.REPETITIVE_SCHEDULE_ID
, WO.OPERATION_SEQUENCE_ID
, WO.STANDARD_OPERATION_ID
, BSO.OPERATION_CODE
, WO.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BD.LOCATION_ID
, WO.DESCRIPTION
, WO.SCHEDULED_QUANTITY
, WO.QUANTITY_IN_QUEUE
, WO.QUANTITY_RUNNING
, WO.QUANTITY_WAITING_TO_MOVE
, WO.QUANTITY_REJECTED
, WO.QUANTITY_SCRAPPED
, WO.QUANTITY_COMPLETED
, WO.FIRST_UNIT_START_DATE
, WO.FIRST_UNIT_COMPLETION_DATE
, WO.LAST_UNIT_START_DATE
, WO.LAST_UNIT_COMPLETION_DATE
, WO.PREVIOUS_OPERATION_SEQ_NUM
, WO.NEXT_OPERATION_SEQ_NUM
, WO.COUNT_POINT_TYPE
, ML2.MEANING AS COUNT_POINT_TYPE_DISP
, WO.BACKFLUSH_FLAG
, ML3.MEANING AS BACKFLUSH_FLAG_DISP
, WO.MINIMUM_TRANSFER_QUANTITY
, WO.DATE_LAST_MOVED
, 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.OPERATION_YIELD
, WO.CUMULATIVE_SCRAP_QUANTITY
, WO.OPERATION_YIELD_ENABLED
, WO.OPERATION_COMPLETED
, ML4.MEANING OPERATION_COMPLETED_DISP
, WO.SHUTDOWN_TYPE
, ML1.MEANING
, WO.X_POS
, WO.Y_POS
, WO.LONG_DESCRIPTION
, WO.DISABLE_DATE
, WO.RECOMMENDED
, WO.PROGRESS_PERCENTAGE
FROM BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO
, WIP_OPERATIONS WO
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
WHERE BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID(+)
AND ( BSO.OPERATION_TYPE IS NULL OR BSO.OPERATION_TYPE = 1)
AND BSO.LINE_ID IS NULL
AND ML1.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'
AND ML1.LOOKUP_CODE(+) = WO.SHUTDOWN_TYPE
AND ML2.LOOKUP_TYPE = 'BOM_COUNT_POINT_TYPE'
AND ML2.LOOKUP_CODE = WO.COUNT_POINT_TYPE
AND ML3.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML3.LOOKUP_CODE = WO.BACKFLUSH_FLAG
AND ML4.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML4.LOOKUP_CODE = DECODE(NVL(WO.OPERATION_COMPLETED
, 'N')
, 'Y'
, 1
, 2)