WIS_WD_OP_ALT_RESOURCES

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

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

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