WIS_WD_OPERATION_REPORTS_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 RESEQUENCE_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 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.RESEQUENCE_FLAG RESEQUENCE_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.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))