Product: | WSM - Shop Floor Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSM_OPERATION_DETAILS_V |
SELECT WOD.ROWID AS ROW_ID
, WOD.STANDARD_OPERATION_ID
, BSO.OPERATION_CODE
, BSO.OPERATION_DESCRIPTION
, WOD.ORGANIZATION_ID
, WOD.SECONDARY_INVENTORY_NAME
, WOD.INVENTORY_LOCATION_ID
, WOD.QUEUE_MANDATORY_FLAG
, WOD.RUN_MANDATORY_FLAG
, WOD.TO_MOVE_MANDATORY_FLAG
, WOD.CREATION_DATE
, WOD.CREATED_BY
, WOD.LAST_UPDATE_DATE
, WOD.LAST_UPDATED_BY
, WOD.LAST_UPDATE_LOGIN
FROM BOM_STANDARD_OPERATIONS BSO
, WSM_OPERATION_DETAILS WOD
WHERE BSO.STANDARD_OPERATION_ID = WOD.STANDARD_OPERATION_ID