WIS_WD_OP_ALT_RESOURCES_V
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: VIEW
Columns
Name |
---|
ROW_ID WD_OP_ALT_RESOURCE_ID WD_OPERATION_RESOURCE_ID STD_OP_ALT_RESOURCE_ID STD_OPERATION_RESOURCE_ID OBJECT_VERSION_NUMBER ASSIGNED_UNITS USAGE_RATE UOM_CODE INVERSE_USAGE_RATE RESOURCE_ID PRIORITY_RANKING WD_OPERATION_ID RESOURCE_SEQ_NUMBER OPER_RES_ASSIGNED_UNITS BASIS_TYPE SCHEDULE_TYPE PRINCIPAL_FLAG WORK_CENTER_ID RESOURCE_ACTIVITY_CODE CHARGE_TYPE STANDARD_OPERATION_ID RESOURCE_QUANTITY AVAILABLE_24_HOURS_FLAG CHECK_CTP_FLAG UTILIZATION_PERCENTAGE EFFICIENCY_PERCENTAGE RESOURCE_TYPE RESOURCE_CODE RESOURCE_NAME RESOURCE_DESCRIPTION RESOURCE_CLASS_CODE COSTED_FLAG INACTIVE_DATE RESOURCE_UOM_CODE 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 WDOAR.ROWID ROW_ID, WDOAR.WD_OP_ALT_RESOURCE_ID, WDOAR.WD_OPERATION_RESOURCE_ID, NULL AS STD_OP_ALT_RESOURCE_ID, NULL AS STD_OPERATION_RESOURCE_ID, WDOAR.OBJECT_VERSION_NUMBER, WDOAR.ASSIGNED_UNITS, WDOAR.USAGE_RATE, WDOAR.UOM_CODE, WDOAR.INVERSE_USAGE_RATE, WDOAR.RESOURCE_ID, WDOAR.PRIORITY_RANKING, WWOR.WD_OPERATION_ID, WWOR.RESOURCE_SEQ_NUMBER, WDOAR.ASSIGNED_UNITS AS OPER_RES_ASSIGNED_UNITS, WWOR.BASIS_TYPE, WWOR.SCHEDULE_TYPE, WWOR.PRINCIPAL_FLAG, WWOR.WORK_CENTER_ID, WWOR.RESOURCE_ACTIVITY_CODE, WWOR.CHARGE_TYPE, NULL AS STANDARD_OPERATION_ID, WCR.RESOURCE_QUANTITY, WCR.AVAILABLE_24_HOURS_FLAG, WCR.CHECK_CTP_FLAG, WCR.UTILIZATION_PERCENTAGE, WCR.EFFICIENCY_PERCENTAGE, RSC.RESOURCE_TYPE, RSC.RESOURCE_CODE, RSC.RESOURCE_NAME, RSC.RESOURCE_DESCRIPTION, RSC.RESOURCE_CLASS_CODE, RSC.COSTED_FLAG, RSC.INACTIVE_DATE, RSC.UOM_CODE AS RESOURCE_UOM_CODE, WDOAR.CREATED_BY CREATED_BY, WDOAR.CREATION_DATE CREATION_DATE, WDOAR.LAST_UPDATED_BY LAST_UPDATED_BY, WDOAR.LAST_UPDATE_DATE LAST_UPDATE_DATE, WDOAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WDOAR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WDOAR.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, WDOAR.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, WDOAR.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, WDOAR.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, WDOAR.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, WDOAR.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, WDOAR.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, WDOAR.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, WDOAR.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, WDOAR.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, WDOAR.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, WDOAR.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, WDOAR.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, WDOAR.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, WDOAR.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, WDOAR.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, WDOAR.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, WDOAR.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, WDOAR.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, WDOAR.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, WDOAR.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, WDOAR.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, WDOAR.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, WDOAR.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, WDOAR.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, WDOAR.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, WDOAR.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, WDOAR.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, WDOAR.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, WDOAR.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, WDOAR.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, WDOAR.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, WDOAR.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, WDOAR.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, WDOAR.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, WDOAR.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, WDOAR.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, WDOAR.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, WDOAR.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, WDOAR.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5 FROM WIS_WD_OP_ALT_RESOURCES WDOAR, WIS_WD_OPERATION_RESOURCES WWOR, WIS_WC_RESOURCES WCR, WIS_RESOURCES_VL RSC WHERE WCR.WORK_CENTER_ID = WWOR.WORK_CENTER_ID AND WWOR.WD_OPERATION_RESOURCE_ID=WDOAR.WD_OPERATION_RESOURCE_ID AND WCR.RESOURCE_ID = WDOAR.RESOURCE_ID AND RSC.RESOURCE_ID = WCR.RESOURCE_ID UNION ALL SELECT WSOPAR.ROWID ROW_ID, NULL AS WD_OP_ALT_RESOURCE_ID, NULL AS WD_OPERATION_RESOURCE_ID, WSOPAR.STD_OP_ALT_RESOURCE_ID, WSOPAR.STD_OPERATION_RESOURCE_ID, WSOPAR.OBJECT_VERSION_NUMBER, WSOPAR.ASSIGNED_UNITS, WSOPAR.USAGE_RATE, WSOPAR.UOM_CODE, WSOPAR.INVERSE_USAGE_RATE, WSOPAR.RESOURCE_ID, WSOPAR.PRIORITY_RANKING, WDO.WD_OPERATION_ID, WSDOAR.RESOURCE_SEQ_NUMBER, WSOPAR.ASSIGNED_UNITS AS OPER_RES_ASSIGNED_UNITS, WSDOAR.BASIS_TYPE, WSDOAR.SCHEDULE_TYPE, WSDOAR.PRINCIPAL_FLAG, WSDOAR.WORK_CENTER_ID, WSDOAR.RESOURCE_ACTIVITY_CODE, WSDOAR.CHARGE_TYPE, WDO.STANDARD_OPERATION_ID, WCR.RESOURCE_QUANTITY, WCR.AVAILABLE_24_HOURS_FLAG, WCR.CHECK_CTP_FLAG, WCR.UTILIZATION_PERCENTAGE, WCR.EFFICIENCY_PERCENTAGE, RSC.RESOURCE_TYPE, RSC.RESOURCE_CODE, RSC.RESOURCE_NAME, RSC.RESOURCE_DESCRIPTION, RSC.RESOURCE_CLASS_CODE, RSC.COSTED_FLAG, RSC.INACTIVE_DATE, RSC.UOM_CODE AS RESOURCE_UOM_CODE, WSDOAR.CREATED_BY CREATED_BY, WSOPAR.CREATION_DATE CREATION_DATE, WSOPAR.LAST_UPDATED_BY LAST_UPDATED_BY, WSOPAR.LAST_UPDATE_DATE LAST_UPDATE_DATE, WSOPAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WSOPAR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WSOPAR.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, WSOPAR.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, WSOPAR.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, WSOPAR.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, WSOPAR.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, WSOPAR.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, WSOPAR.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, WSOPAR.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, WSOPAR.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, WSOPAR.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, WSOPAR.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, WSOPAR.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, WSOPAR.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, WSOPAR.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, WSOPAR.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, WSOPAR.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, WSOPAR.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, WSOPAR.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, WSOPAR.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, WSOPAR.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, WSOPAR.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, WSOPAR.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, WSOPAR.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, WSOPAR.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, WSOPAR.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, WSOPAR.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, WSOPAR.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, WSOPAR.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, WSOPAR.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, WSOPAR.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, WSOPAR.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, WSOPAR.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, WSOPAR.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, WSOPAR.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, WSOPAR.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, WSOPAR.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, WSOPAR.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, WSOPAR.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, WSOPAR.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, WSOPAR.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5 FROM WIS_WD_OPERATIONS_B WDO, WIS_STANDARD_OPERATIONS_B STO, WIS_STD_OPERATION_RESOURCES WSDOAR, WIS_STD_OP_ALT_RESOURCES WSOPAR, WIS_WC_RESOURCES WCR, WIS_RESOURCES_VL RSC WHERE WDO.REFERENCED_FLAG = 'Y' AND WCR.WORK_CENTER_ID = STO.WORK_CENTER_ID AND STO.STANDARD_OPERATION_ID = WDO.STANDARD_OPERATION_ID AND WSOPAR.STD_OPERATION_RESOURCE_ID =WSDOAR.STD_OPERATION_RESOURCE_ID AND WSDOAR.STANDARD_OPERATION_ID = STO.STANDARD_OPERATION_ID AND WCR.RESOURCE_ID = WSOPAR.RESOURCE_ID AND RSC.RESOURCE_ID = WCR.RESOURCE_ID |