[Home] [Help]
View: WSM_WIP_OPERATIONS_V
View Text
SELECT WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, ORGANIZATION_ID
, REPETITIVE_SCHEDULE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OPERATION_SEQUENCE_ID
, STANDARD_OPERATION_ID
, DEPARTMENT_ID
, DESCRIPTION
, SCHEDULED_QUANTITY
, QUANTITY_IN_QUEUE
, QUANTITY_RUNNING
, QUANTITY_WAITING_TO_MOVE
, QUANTITY_REJECTED
, QUANTITY_SCRAPPED
, QUANTITY_COMPLETED
, FIRST_UNIT_START_DATE
, FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, PREVIOUS_OPERATION_SEQ_NUM
, NEXT_OPERATION_SEQ_NUM
, COUNT_POINT_TYPE
, BACKFLUSH_FLAG
, MINIMUM_TRANSFER_QUANTITY
, DATE_LAST_MOVED
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PRE_SPLIT_QUANTITY
, OPERATION_YIELD_ENABLED
, OPERATION_YIELD
, PREVIOUS_OPERATION_SEQ_ID
FROM WIP_OPERATIONS
Columns
Name |
WIP_ENTITY_ID |
OPERATION_SEQ_NUM |
ORGANIZATION_ID |
REPETITIVE_SCHEDULE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
OPERATION_SEQUENCE_ID |
STANDARD_OPERATION_ID |
DEPARTMENT_ID |
DESCRIPTION |
SCHEDULED_QUANTITY |
QUANTITY_IN_QUEUE |
QUANTITY_RUNNING |
QUANTITY_WAITING_TO_MOVE |
QUANTITY_REJECTED |
QUANTITY_SCRAPPED |
QUANTITY_COMPLETED |
FIRST_UNIT_START_DATE |
FIRST_UNIT_COMPLETION_DATE |
LAST_UNIT_START_DATE |
LAST_UNIT_COMPLETION_DATE |
PREVIOUS_OPERATION_SEQ_NUM |
NEXT_OPERATION_SEQ_NUM |
COUNT_POINT_TYPE |
BACKFLUSH_FLAG |
MINIMUM_TRANSFER_QUANTITY |
DATE_LAST_MOVED |
ATTRIBUTE_CATEGORY |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |
PRE_SPLIT_QUANTITY |
OPERATION_YIELD_ENABLED |
OPERATION_YIELD |
PREVIOUS_OPERATION_SEQ_ID |