WIS_WD_OPERATION_RESOURCES

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

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

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