VIEW: APPS.WIP_OPERATIONS_V

Source

View Text - Preformatted

SELECT WO.ROWID ROW_ID , WO.WIP_ENTITY_ID , WO.OPERATION_SEQ_NUM , WO.ORGANIZATION_ID , WO.REPETITIVE_SCHEDULE_ID , WO.LAST_UPDATE_DATE , WO.LAST_UPDATED_BY , WO.CREATION_DATE , WO.CREATED_BY , WO.LAST_UPDATE_LOGIN , WO.REQUEST_ID , WO.PROGRAM_APPLICATION_ID , WO.PROGRAM_ID , WO.PROGRAM_UPDATE_DATE , 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 , DECODE(WO.QUANTITY_IN_QUEUE, 0, NULL, WO.QUANTITY_IN_QUEUE) , DECODE(WO.QUANTITY_RUNNING, 0, NULL, WO.QUANTITY_RUNNING) , DECODE(WO.QUANTITY_WAITING_TO_MOVE, 0, NULL, WO.QUANTITY_WAITING_TO_MOVE) , DECODE(WO.QUANTITY_REJECTED, 0, NULL, WO.QUANTITY_REJECTED) , DECODE(WO.QUANTITY_SCRAPPED, 0, NULL, WO.QUANTITY_SCRAPPED) , DECODE(WO.QUANTITY_COMPLETED, 0, NULL, 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 , DECODE(WO.COUNT_POINT_TYPE,1, 1, 2) "COUNT_POINT_FLAG" , DECODE(WO.COUNT_POINT_TYPE,3,2,1) "AUTOCHARGE_FLAG" , WO.BACKFLUSH_FLAG , 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 ,NVL(WO.OPERATION_COMPLETED,'N') ,WO.SHUTDOWN_TYPE ,LU1.MEANING ,WO.X_POS ,WO.Y_POS ,WO.LONG_DESCRIPTION ,WO.DISABLE_DATE ,WO.RECOMMENDED ,WO.PROGRESS_PERCENTAGE ,WO.WSM_BONUS_QUANTITY ,WO.ACTUAL_START_DATE ,WO.ACTUAL_COMPLETION_DATE ,WO.EMPLOYEE_ID ,PAP.FULL_NAME ,WO.LOWEST_ACCEPTABLE_YIELD ,nvl(wo.CHECK_SKILL,2) CHECK_SKILL FROM BOM_DEPARTMENTS BD , BOM_STANDARD_OPERATIONS BSO , WIP_OPERATIONS WO , MFG_LOOKUPS LU1 , PER_ALL_PEOPLE_F PAP WHERE BD.DEPARTMENT_ID = WO.DEPARTMENT_ID AND BSO.STANDARD_OPERATION_ID(+) = WO.STANDARD_OPERATION_ID AND NVL(BSO.OPERATION_TYPE,1) = 1 AND BSO.LINE_ID IS NULL AND LU1.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE' AND LU1.LOOKUP_CODE(+) = WO.SHUTDOWN_TYPE AND WO.EMPLOYEE_ID = PAP.PERSON_ID (+) ORDER BY WO.OPERATION_SEQ_NUM

View Text - HTML Formatted

SELECT WO.ROWID ROW_ID
, WO.WIP_ENTITY_ID
, WO.OPERATION_SEQ_NUM
, WO.ORGANIZATION_ID
, WO.REPETITIVE_SCHEDULE_ID
, WO.LAST_UPDATE_DATE
, WO.LAST_UPDATED_BY
, WO.CREATION_DATE
, WO.CREATED_BY
, WO.LAST_UPDATE_LOGIN
, WO.REQUEST_ID
, WO.PROGRAM_APPLICATION_ID
, WO.PROGRAM_ID
, WO.PROGRAM_UPDATE_DATE
, 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
, DECODE(WO.QUANTITY_IN_QUEUE
, 0
, NULL
, WO.QUANTITY_IN_QUEUE)
, DECODE(WO.QUANTITY_RUNNING
, 0
, NULL
, WO.QUANTITY_RUNNING)
, DECODE(WO.QUANTITY_WAITING_TO_MOVE
, 0
, NULL
, WO.QUANTITY_WAITING_TO_MOVE)
, DECODE(WO.QUANTITY_REJECTED
, 0
, NULL
, WO.QUANTITY_REJECTED)
, DECODE(WO.QUANTITY_SCRAPPED
, 0
, NULL
, WO.QUANTITY_SCRAPPED)
, DECODE(WO.QUANTITY_COMPLETED
, 0
, NULL
, 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
, DECODE(WO.COUNT_POINT_TYPE
, 1
, 1
, 2) "COUNT_POINT_FLAG"
, DECODE(WO.COUNT_POINT_TYPE
, 3
, 2
, 1) "AUTOCHARGE_FLAG"
, WO.BACKFLUSH_FLAG
, 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
, NVL(WO.OPERATION_COMPLETED
, 'N')
, WO.SHUTDOWN_TYPE
, LU1.MEANING
, WO.X_POS
, WO.Y_POS
, WO.LONG_DESCRIPTION
, WO.DISABLE_DATE
, WO.RECOMMENDED
, WO.PROGRESS_PERCENTAGE
, WO.WSM_BONUS_QUANTITY
, WO.ACTUAL_START_DATE
, WO.ACTUAL_COMPLETION_DATE
, WO.EMPLOYEE_ID
, PAP.FULL_NAME
, WO.LOWEST_ACCEPTABLE_YIELD
, NVL(WO.CHECK_SKILL
, 2) CHECK_SKILL
FROM BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO
, WIP_OPERATIONS WO
, MFG_LOOKUPS LU1
, PER_ALL_PEOPLE_F PAP
WHERE BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND BSO.STANDARD_OPERATION_ID(+) = WO.STANDARD_OPERATION_ID
AND NVL(BSO.OPERATION_TYPE
, 1) = 1
AND BSO.LINE_ID IS NULL
AND LU1.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'
AND LU1.LOOKUP_CODE(+) = WO.SHUTDOWN_TYPE
AND WO.EMPLOYEE_ID = PAP.PERSON_ID (+) ORDER BY WO.OPERATION_SEQ_NUM