1. Tables and Views for SCM
  2. WIS_WD_OPERATIONS_V

WIS_WD_OPERATIONS_V

Details

  • Schema: FUSION

  • Object owner: WIS

  • Object type: VIEW

Columns

Name

ROW_ID

WD_OPERATION_ID

REFERENCED_FLAG

OBJECT_VERSION_NUMBER

OPERATION_TYPE

OPERATION_SEQ_NUMBER

EFFECTIVE_FROM_DATE

OPERATION_NAME

OPERATION_DESCRIPTION

AUTO_TRANSACT_FLAG

COUNT_POINT_FLAG

SERIAL_TRACKING_FLAG

EFFECTIVE_TO_DATE

WORK_DEFINITION_ID

OPTION_DEPENDENT_FLAG

PLANNING_PERCENT

APPLICABILITY_RULE_ID

STANDARD_OPERATION_ID

STANDARD_OPERATION_CODE

ORGANIZATION_ID

STD_OPERATION_INACTIVE_DATE

WORK_CENTER_ID

WORK_CENTER_CODE

WORK_CENTER_NAME

WC_INACTIVE_DATE

WORK_CENTER_DESCRIPTION

SHIPPING_DOCUMENTS_FLAG

OSP_ITEM_ID

SUPPLIER_ID

SUPPLIER_SITE_ID

LEAD_TIME_UOM

FIXED_LEAD_TIME

VARIABLE_LEAD_TIME

LEAD_TIME_PERCENT

ACTION_STATUS_CODE

ADDL_MTL_AT_MANUAL_ISSUE

OP_COMPL_WITH_UNDER_ISSUE

OP_COMPL_WITH_OPEN_EXCEPTIONS

RESEQUENCE_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT

WDO.B_ROW_ID ROW_ID,

WDO.WD_OPERATION_ID WD_OPERATION_ID,

WDO.REFERENCED_FLAG REFERENCED_FLAG,

WDO.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

WDO.OPERATION_TYPE OPERATION_TYPE,

WDO.OPERATION_SEQ_NUMBER OPERATION_SEQ_NUMBER,

WDO.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.STANDARD_OPERATION_NAME ELSE WDO.OPERATION_NAME END) as OPERATION_NAME,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.STANDARD_OPERATION_DESCRIPTION ELSE WDO.OPERATION_DESCRIPTION END) as OPERATION_DESCRIPTION,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.AUTO_TRANSACT_FLAG ELSE WDO.AUTO_TRANSACT_FLAG END) as AUTO_TRANSACT_FLAG,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.COUNT_POINT_FLAG ELSE WDO.COUNT_POINT_FLAG END) as COUNT_POINT_FLAG,

WDO.SERIAL_TRACKING_FLAG SERIAL_TRACKING_FLAG,

WDO.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE,

WDO.WORK_DEFINITION_ID WORK_DEFINITION_ID,

WDO.OPTION_DEPENDENT_FLAG OPTION_DEPENDENT_FLAG,

WDO.PLANNING_PERCENT PLANNING_PERCENT,

WDO.APPLICABILITY_RULE_ID APPLICABILITY_RULE_ID,

STDO.STANDARD_OPERATION_ID STANDARD_OPERATION_ID,

STDO.STANDARD_OPERATION_CODE,

STDO.ORGANIZATION_ID ORGANIZATION_ID,

STDO.INACTIVE_DATE STD_OPERATION_INACTIVE_DATE,

WC.WORK_CENTER_ID WORK_CENTER_ID,

WC.WORK_CENTER_CODE WORK_CENTER_CODE,

WC.WORK_CENTER_NAME WORK_CENTER_NAME,

WC.INACTIVE_DATE WC_INACTIVE_DATE,

WC.WORK_CENTER_DESCRIPTION WORK_CENTER_DESCRIPTION,

WDO.SHIPPING_DOCUMENTS_FLAG SHIPPING_DOCUMENTS_FLAG,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.OSP_ITEM_ID ELSE WDO.OSP_ITEM_ID END) as OSP_ITEM_ID,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.SUPPLIER_ID ELSE WDO.SUPPLIER_ID END) as SUPPLIER_ID,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.SUPPLIER_SITE_ID ELSE WDO.SUPPLIER_SITE_ID END) as SUPPLIER_SITE_ID,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.LEAD_TIME_UOM ELSE WDO.LEAD_TIME_UOM END) as LEAD_TIME_UOM,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.FIXED_LEAD_TIME ELSE WDO.FIXED_LEAD_TIME END) as FIXED_LEAD_TIME,

(CASE WHEN WDO.REFERENCED_FLAG = 'Y' THEN STDO.VARIABLE_LEAD_TIME ELSE WDO.VARIABLE_LEAD_TIME END) as VARIABLE_LEAD_TIME,

WDO.LEAD_TIME_PERCENT,

WDO.ACTION_STATUS_CODE ACTION_STATUS_CODE,

(

CASE

WHEN WDO.REFERENCED_FLAG = 'Y'

THEN STDO.ADDL_MTL_AT_MANUAL_ISSUE

ELSE WDO.ADDL_MTL_AT_MANUAL_ISSUE

END) AS ADDL_MTL_AT_MANUAL_ISSUE,

(

CASE

WHEN WDO.REFERENCED_FLAG = 'Y'

THEN STDO.OP_COMPL_WITH_UNDER_ISSUE

ELSE WDO.OP_COMPL_WITH_UNDER_ISSUE

END) AS OP_COMPL_WITH_UNDER_ISSUE,

(

CASE

WHEN WDO.REFERENCED_FLAG = 'Y'

THEN STDO.OP_COMPL_WITH_OPEN_EXCEPTIONS

ELSE WDO.OP_COMPL_WITH_OPEN_EXCEPTIONS

END) AS OP_COMPL_WITH_OPEN_EXCEPTIONS,

WDO.RESEQUENCE_FLAG RESEQUENCE_FLAG,

WDO.CREATED_BY CREATED_BY,

WDO.CREATION_DATE CREATION_DATE,

WDO.LAST_UPDATED_BY LAST_UPDATED_BY,

WDO.LAST_UPDATE_DATE LAST_UPDATE_DATE,

WDO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

WDO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

WDO.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

WDO.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

WDO.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

WDO.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

WDO.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

WDO.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

WDO.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

WDO.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

WDO.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

WDO.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

WDO.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

WDO.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

WDO.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

WDO.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

WDO.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

WDO.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

WDO.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

WDO.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

WDO.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

WDO.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

WDO.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

WDO.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

WDO.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

WDO.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

WDO.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

WDO.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

WDO.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

WDO.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

WDO.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

WDO.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

WDO.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

WDO.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

WDO.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

WDO.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

WDO.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

WDO.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

WDO.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

WDO.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

WDO.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

WDO.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5

FROM

WIS_WD_OPERATIONS_VL WDO,

WIS_STANDARD_OPERATIONS_VL STDO,

WIS_WORK_CENTERS_VL WC

WHERE

WDO.STANDARD_OPERATION_ID = STDO.STANDARD_OPERATION_ID(+) AND

((WDO.REFERENCED_FLAG = 'N' AND WC.WORK_CENTER_ID = WDO.WORK_CENTER_ID) OR

(WDO.REFERENCED_FLAG = 'Y' AND WC.WORK_CENTER_ID = STDO.WORK_CENTER_ID)) AND (WDO.ACTION_STATUS_CODE IS NULL OR WDO.ACTION_STATUS_CODE = 'DELETE' )