VIEW: APPS.EAM_CFR_OPERATIONS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)