WIS_WD_OPERATION_RESOURCES_V
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: VIEW
Columns
Name |
---|
ROW_ID WD_OPERATION_RESOURCE_ID STD_OPERATION_RESOURCE_ID OBJECT_VERSION_NUMBER RESOURCE_SEQ_NUMBER ASSIGNED_UNITS USAGE_RATE UOM_CODE BASIS_TYPE SCHEDULE_TYPE PRINCIPAL_FLAG CHARGE_TYPE RESOURCE_ACTIVITY_CODE INVERSE_USAGE_RATE WORK_CENTER_ID RESOURCE_ID WD_OPERATION_ID 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 PROFILE_ID EQP_QUAL_PROFILE_ID DOCUMENT_ITEM_ID EQP_PARAMS_FILENAME 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 WDR.ROWID ROW_ID, WDR.WD_OPERATION_RESOURCE_ID, NULL AS STD_OPERATION_RESOURCE_ID, WDR.OBJECT_VERSION_NUMBER, WDR.RESOURCE_SEQ_NUMBER, WDR.ASSIGNED_UNITS, WDR.USAGE_RATE, WDR.UOM_CODE, WDR.BASIS_TYPE, WDR.SCHEDULE_TYPE, WDR.PRINCIPAL_FLAG, WDR.CHARGE_TYPE, WDR.RESOURCE_ACTIVITY_CODE, WDR.INVERSE_USAGE_RATE, WDR.WORK_CENTER_ID, WDR.RESOURCE_ID, WDR.WD_OPERATION_ID, 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, WDR.PROFILE_ID, WDR.EQP_QUAL_PROFILE_ID, WDR.DOCUMENT_ITEM_ID, WDR.EQP_PARAMS_FILENAME, WDR.CREATED_BY CREATED_BY, WDR.CREATION_DATE CREATION_DATE, WDR.LAST_UPDATED_BY LAST_UPDATED_BY, WDR.LAST_UPDATE_DATE LAST_UPDATE_DATE, WDR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WDR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WDR.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, WDR.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, WDR.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, WDR.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, WDR.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, WDR.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, WDR.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, WDR.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, WDR.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, WDR.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, WDR.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, WDR.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, WDR.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, WDR.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, WDR.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, WDR.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, WDR.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, WDR.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, WDR.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, WDR.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, WDR.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, WDR.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, WDR.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, WDR.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, WDR.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, WDR.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, WDR.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, WDR.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, WDR.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, WDR.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, WDR.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, WDR.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, WDR.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, WDR.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, WDR.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, WDR.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, WDR.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, WDR.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, WDR.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, WDR.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5 FROM WIS_WD_OPERATION_RESOURCES WDR, WIS_WC_RESOURCES WCR, WIS_RESOURCES_VL RSC WHERE WCR.WORK_CENTER_ID = WDR.WORK_CENTER_ID AND WCR.RESOURCE_ID = WDR.RESOURCE_ID AND RSC.RESOURCE_ID = WDR.RESOURCE_ID UNION ALL SELECT WDR.ROWID ROW_ID, NULL AS WD_OPERATION_RESOURCE_ID, WDR.STD_OPERATION_RESOURCE_ID, WDR.OBJECT_VERSION_NUMBER, WDR.RESOURCE_SEQ_NUMBER, WDR.ASSIGNED_UNITS, WDR.USAGE_RATE, WDR.UOM_CODE, WDR.BASIS_TYPE, WDR.SCHEDULE_TYPE, WDR.PRINCIPAL_FLAG, WDR.CHARGE_TYPE, WDR.RESOURCE_ACTIVITY_CODE, WDR.INVERSE_USAGE_RATE, WDR.WORK_CENTER_ID, WDR.RESOURCE_ID, WDO.WD_OPERATION_ID, 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, WDR.PROFILE_ID, WDR.EQP_QUAL_PROFILE_ID, NULL AS DOCUMENT_ITEM_ID, NULL AS EQP_PARAMS_FILENAME, WDR.CREATED_BY CREATED_BY, WDR.CREATION_DATE CREATION_DATE, WDR.LAST_UPDATED_BY LAST_UPDATED_BY, WDR.LAST_UPDATE_DATE LAST_UPDATE_DATE, WDR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WDR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WDR.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, WDR.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, WDR.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, WDR.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, WDR.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, WDR.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, WDR.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, WDR.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, WDR.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, WDR.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, WDR.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, WDR.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, WDR.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, WDR.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, WDR.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, WDR.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, WDR.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, WDR.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, WDR.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, WDR.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, WDR.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, WDR.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, WDR.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, WDR.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, WDR.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, WDR.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, WDR.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, WDR.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, WDR.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, WDR.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, WDR.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, WDR.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, WDR.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, WDR.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, WDR.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, WDR.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, WDR.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, WDR.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, WDR.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, WDR.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5 FROM WIS_WD_OPERATIONS_B WDO, WIS_STANDARD_OPERATIONS_B STO, WIS_STD_OPERATION_RESOURCES WDR, WIS_WC_RESOURCES WCR, WIS_RESOURCES_VL RSC WHERE WDO.REFERENCED_FLAG = 'Y' AND STO.STANDARD_OPERATION_ID = WDO.STANDARD_OPERATION_ID AND WDR.STANDARD_OPERATION_ID = STO.STANDARD_OPERATION_ID AND WCR.WORK_CENTER_ID = WDR.WORK_CENTER_ID AND WCR.RESOURCE_ID = WDR.RESOURCE_ID AND RSC.RESOURCE_ID = WDR.RESOURCE_ID |