Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: WSM.WSM_COPY_OPERATIONS

Object Details
Object Name: WSM_COPY_OPERATIONS
Object Type: TABLE
Owner: WSM
Subobject Name:
Status: VALID


COPY table for effective operations for lot based jobs


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSM_COPY_OPERATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnOPERATION_SEQ_NUM
WSM_COPY_OPERATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECO_COMPLETION_DATE
ColumnRECO_START_DATE
ColumnSTANDARD_OPERATION_ID
ColumnDEPARTMENT_ID
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Yes Lot Based Job Identifier
OPERATION_SEQ_NUM NUMBER
Yes Operation sequence number within a routing
RECO_PATH_SEQ_NUM NUMBER

Sequence number of operations on the recommended path
RECO_SCHEDULED_QUANTITY NUMBER

Number of units scheduled for the operation
RECO_START_DATE DATE

Operation Start Date recommended by planning or user preferred
RECO_COMPLETION_DATE DATE

Operation Completion Date recommended by planning or user preferred
NETWORK_START_END VARCHAR2 (1)
Specifies Start or End Operation of Network Routing (Values: 'S' or 'E' or NULL)
OPERATION_SEQUENCE_ID NUMBER
Yes Routing operation unique identifier
ROUTING_SEQUENCE_ID NUMBER

Routing unique identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
STANDARD_OPERATION_ID NUMBER

Standard operation unique identifier
STANDARD_OPERATION_CODE VARCHAR2 (4)
Standard operation code
DEPARTMENT_ID NUMBER
Yes Department unique identifier
DEPARTMENT_CODE VARCHAR2 (10) Yes Department code
SCRAP_ACCOUNT NUMBER

Scrap account of department
EST_ABSORPTION_ACCOUNT NUMBER

Estimated scrap absorption account
OPERATION_LEAD_TIME_PERCENT NUMBER

Indicates the amount of overlap its lead time has with the parents lead time
MINIMUM_TRANSFER_QUANTITY NUMBER

Minimum operation transfer quantity
COUNT_POINT_TYPE NUMBER
Yes Count point
OPERATION_DESCRIPTION VARCHAR2 (240)
Description of operation
EFFECTIVITY_DATE DATE
Yes Date operation is effective
DISABLE_DATE DATE

Date operation is no longer effective - effectivity lasts until the end of the disable date
BACKFLUSH_FLAG NUMBER
Yes Indicates whether operation requires backflushing
OPTION_DEPENDENT_FLAG NUMBER
Yes Indicates whether to use this operation in all configuration routings, even if no components of the configuration are used in this operation
OPERATION_TYPE NUMBER

Process, Line Operation or Event
REFERENCE_FLAG NUMBER

If the Standard Operation is referenced or copied then the operation can not be updated
YIELD NUMBER

Process yield at this operation
CUMULATIVE_YIELD NUMBER

Cumulative process yield from beginning of routing to this operation
REVERSE_CUMULATIVE_YIELD NUMBER

Cumulative process yield from end of routing to comparable operation
LABOR_TIME_CALC NUMBER

System calculated run time attributable to labor
MACHINE_TIME_CALC NUMBER

System calculated run time attributable to machines
TOTAL_TIME_CALC NUMBER

System calculated run time attributable to both labor and machines
LABOR_TIME_USER NUMBER

User calculated run time attributable to labor
MACHINE_TIME_USER NUMBER

User calculated run time attributable to machines
TOTAL_TIME_USER NUMBER

User calculated run time attributable to both labor and machines
NET_PLANNING_PERCENT NUMBER

Cumulative planning percents derived from the operation network
X_COORDINATE NUMBER

X coordinate of the operation
Y_COORDINATE NUMBER

Y coordinate of the operation
INCLUDE_IN_ROLLUP NUMBER

Indicates whether operation yield is to be considered in cost rollup
OPERATION_YIELD_ENABLED NUMBER

Indicates whether operation yield is to be considered during costing
OLD_OPERATION_SEQUENCE_ID NUMBER

Identifier of original operation row an ECO effects
ACD_TYPE NUMBER

Add, change, or disable code for operations on an engineering change order
REVISED_ITEM_SEQUENCE_ID NUMBER

Revised Item Sequence Id
CHANGE_NOTICE VARCHAR2 (10)
Engineering change notice code
IMPLEMENTATION_DATE DATE

Factor used to multiply component quantity with to obtain planning quantity
ECO_FOR_PRODUCTION NUMBER

Indicates if this operation on an Engineering Change Order is only for WIP jobs
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown type
ACTUAL_IPK NUMBER

Actual In-Process Kanbans
CRITICAL_TO_QUALITY VARCHAR2 (1)
Critical to quality
VALUE_ADDED VARCHAR2 (1)
Value Added
LONG_DESCRIPTION VARCHAR2 (4000)
Not used deprecated
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original system that data for the current record has come from
LOWEST_ACCEPTABLE_YIELD NUMBER

The lowest yield beyond which the job will be put on hold
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      RECOMMENDED
,      RECO_PATH_SEQ_NUM
,      RECO_SCHEDULED_QUANTITY
,      RECO_START_DATE
,      RECO_COMPLETION_DATE
,      NETWORK_START_END
,      OPERATION_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      ORGANIZATION_ID
,      STANDARD_OPERATION_ID
,      STANDARD_OPERATION_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      SCRAP_ACCOUNT
,      EST_ABSORPTION_ACCOUNT
,      OPERATION_LEAD_TIME_PERCENT
,      MINIMUM_TRANSFER_QUANTITY
,      COUNT_POINT_TYPE
,      OPERATION_DESCRIPTION
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      BACKFLUSH_FLAG
,      OPTION_DEPENDENT_FLAG
,      OPERATION_TYPE
,      REFERENCE_FLAG
,      YIELD
,      CUMULATIVE_YIELD
,      REVERSE_CUMULATIVE_YIELD
,      LABOR_TIME_CALC
,      MACHINE_TIME_CALC
,      TOTAL_TIME_CALC
,      LABOR_TIME_USER
,      MACHINE_TIME_USER
,      TOTAL_TIME_USER
,      NET_PLANNING_PERCENT
,      X_COORDINATE
,      Y_COORDINATE
,      INCLUDE_IN_ROLLUP
,      OPERATION_YIELD_ENABLED
,      OLD_OPERATION_SEQUENCE_ID
,      ACD_TYPE
,      REVISED_ITEM_SEQUENCE_ID
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      ECO_FOR_PRODUCTION
,      SHUTDOWN_TYPE
,      ACTUAL_IPK
,      CRITICAL_TO_QUALITY
,      VALUE_ADDED
,      LONG_DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIGINAL_SYSTEM_REFERENCE
,      LOWEST_ACCEPTABLE_YIELD
FROM WSM.WSM_COPY_OPERATIONS;

Dependencies

[top of page]

WSM.WSM_COPY_OPERATIONS does not reference any database object

WSM.WSM_COPY_OPERATIONS is referenced by following:

SchemaWSM
ViewWSM_COPY_OPERATIONS#