[Home] [Help]
View: WSM_COPY_ALL_OPERATIONS_V
Product: | WSM - Shop Floor Management |
Description: | View for getting all standard operations in an OSFM org |
Implementation/DBA Data: |
APPS.WSM_COPY_ALL_OPERATIONS_V
|
View Text
SELECT WCO.WIP_ENTITY_ID
, 10 TO_OP_SEQ_NUM
, WCO.OPERATION_SEQ_NUM TO_WCO_OP_SEQ_NUM
, WCO.OPERATION_SEQUENCE_ID TO_OP_SEQ_ID
, WCO.STANDARD_OPERATION_CODE NEXT_OPERATION_CODE
, WCO.OPERATION_DESCRIPTION
, WCO.STANDARD_OPERATION_ID
, WCO.DEPARTMENT_CODE
, WCO.DEPARTMENT_ID
, WCO.RECOMMENDED FROM WSM_COPY_OPERATIONS WCO
, WSM_COPY_OP_NETWORKS WCON
WHERE WCO.WIP_ENTITY_ID=WCON.WIP_ENTITY_ID AND ((WCO.OPERATION_SEQ_NUM = WCON.FROM_OP_SEQ_NUM) OR (WCO.OPERATION_SEQ_NUM = WCON.TO_OP_SEQ_NUM))
Columns
Name |
WIP_ENTITY_ID |
TO_OP_SEQ_NUM |
TO_WCO_OP_SEQ_NUM |
TO_OP_SEQ_ID |
NEXT_OPERATION_CODE |
OPERATION_DESCRIPTION |
STANDARD_OPERATION_ID |
DEPARTMENT_CODE |
DEPARTMENT_ID |
RECOMMENDED |