VIEW: APPS.WSM_WIP_OPERATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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