WIE_WO_OPERATION_RESOURCES

Details

Schema: FUSION
Object owner: WIE
Object type: VIEW

Columns

Name
ROW_ID WO_OPERATION_RESOURCE_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID WO_OPERATION_ID RESOURCE_SEQ_NUMBER WORK_CENTER_ID RESOURCE_ID PRINCIPAL_FLAG USAGE_RATE BASIS_TYPE REQUIRED_USAGE INVERSE_REQUIRED_USAGE UOM_CODE CHARGE_TYPE ASSIGNED_UNITS PLANNED_START_DATE PLANNED_COMPLETION_DATE RESOURCE_ACTIVITY_CODE SCHEDULED_FLAG PHANTOM_FLAG ACTUAL_RESOURCE_USAGE WD_OPERATION_RESOURCE_ID PROFILE_ID EQP_QUAL_PROFILE_ID REASON_FOR_REPAIR_CODE_ID REPAIR_TXN_CODE_ID WORK_ACCOMPLISHED_CODE_ID 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 REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Name

ROW_ID

WO_OPERATION_RESOURCE_ID

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

WO_OPERATION_ID

RESOURCE_SEQ_NUMBER

WORK_CENTER_ID

RESOURCE_ID

PRINCIPAL_FLAG

USAGE_RATE

BASIS_TYPE

REQUIRED_USAGE

INVERSE_REQUIRED_USAGE

UOM_CODE

CHARGE_TYPE

ASSIGNED_UNITS

PLANNED_START_DATE

PLANNED_COMPLETION_DATE

RESOURCE_ACTIVITY_CODE

SCHEDULED_FLAG

PHANTOM_FLAG

ACTUAL_RESOURCE_USAGE

WD_OPERATION_RESOURCE_ID

PROFILE_ID

EQP_QUAL_PROFILE_ID

REASON_FOR_REPAIR_CODE_ID

REPAIR_TXN_CODE_ID

WORK_ACCOMPLISHED_CODE_ID

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

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

Query

SQL_Statement
SELECT WOR.ROWID ROW_ID, WOR.WO_OPERATION_RESOURCE_ID WO_OPERATION_RESOURCE_ID, WOR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WOR.ORGANIZATION_ID ORGANIZATION_ID, WOR.WO_OPERATION_ID WO_OPERATION_ID, WOR.RESOURCE_SEQ_NUMBER RESOURCE_SEQ_NUMBER, WOR.WORK_CENTER_ID WORK_CENTER_ID, WOR.RESOURCE_ID RESOURCE_ID, WOR.PRINCIPAL_FLAG PRINCIPAL_FLAG, WOR.USAGE_RATE USAGE_RATE, WOR.BASIS_TYPE BASIS_TYPE, WOR.REQUIRED_USAGE REQUIRED_USAGE, WOR.INVERSE_REQUIRED_USAGE INVERSE_REQUIRED_USAGE, WOR.UOM_CODE UOM_CODE, WOR.CHARGE_TYPE CHARGE_TYPE, WOR.ASSIGNED_UNITS ASSIGNED_UNITS, WOR.PLANNED_START_DATE PLANNED_START_DATE, WOR.PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE, WOR.RESOURCE_ACTIVITY_CODE RESOURCE_ACTIVITY_CODE, WOR.SCHEDULED_FLAG SCHEDULED_FLAG, WOR.PHANTOM_FLAG PHANTOM_FLAG, WOR.ACTUAL_RESOURCE_USAGE ACTUAL_RESOURCE_USAGE, WOR.WD_OPERATION_RESOURCE_ID WD_OPERATION_RESOURCE_ID, WOR.PROFILE_ID PROFILE_ID, WOR.EQP_QUAL_PROFILE_ID EQP_QUAL_PROFILE_ID, WOR.REASON_FOR_REPAIR_CODE_ID REASON_FOR_REPAIR_CODE_ID, WOR.REPAIR_TXN_CODE_ID REPAIR_TXN_CODE_ID, WOR.WORK_ACCOMPLISHED_CODE_ID WORK_ACCOMPLISHED_CODE_ID, WOR.CREATED_BY CREATED_BY, WOR.CREATION_DATE CREATION_DATE, WOR.LAST_UPDATED_BY LAST_UPDATED_BY, WOR.LAST_UPDATE_DATE LAST_UPDATE_DATE, WOR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WOR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WOR.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, WOR.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, WOR.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, WOR.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, WOR.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, WOR.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, WOR.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, WOR.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, WOR.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, WOR.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, WOR.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, WOR.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, WOR.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, WOR.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, WOR.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, WOR.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, WOR.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, WOR.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, WOR.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, WOR.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, WOR.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, WOR.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, WOR.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, WOR.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, WOR.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, WOR.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, WOR.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, WOR.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, WOR.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, WOR.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, WOR.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, WOR.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, WOR.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, WOR.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, WOR.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, WOR.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, WOR.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, WOR.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, WOR.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, WOR.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, WOR.REQUEST_ID REQUEST_ID, WOR.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, WOR.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM WIE_WO_OPERATION_RESOURCES WOR

SQL_Statement

SELECT

WOR.ROWID ROW_ID,

WOR.WO_OPERATION_RESOURCE_ID WO_OPERATION_RESOURCE_ID,

WOR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

WOR.ORGANIZATION_ID ORGANIZATION_ID,

WOR.WO_OPERATION_ID WO_OPERATION_ID,

WOR.RESOURCE_SEQ_NUMBER RESOURCE_SEQ_NUMBER,

WOR.WORK_CENTER_ID WORK_CENTER_ID,

WOR.RESOURCE_ID RESOURCE_ID,

WOR.PRINCIPAL_FLAG PRINCIPAL_FLAG,

WOR.USAGE_RATE USAGE_RATE,

WOR.BASIS_TYPE BASIS_TYPE,

WOR.REQUIRED_USAGE REQUIRED_USAGE,

WOR.INVERSE_REQUIRED_USAGE INVERSE_REQUIRED_USAGE,

WOR.UOM_CODE UOM_CODE,

WOR.CHARGE_TYPE CHARGE_TYPE,

WOR.ASSIGNED_UNITS ASSIGNED_UNITS,

WOR.PLANNED_START_DATE PLANNED_START_DATE,

WOR.PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE,

WOR.RESOURCE_ACTIVITY_CODE RESOURCE_ACTIVITY_CODE,

WOR.SCHEDULED_FLAG SCHEDULED_FLAG,

WOR.PHANTOM_FLAG PHANTOM_FLAG,

WOR.ACTUAL_RESOURCE_USAGE ACTUAL_RESOURCE_USAGE,

WOR.WD_OPERATION_RESOURCE_ID WD_OPERATION_RESOURCE_ID,

WOR.PROFILE_ID PROFILE_ID,

WOR.EQP_QUAL_PROFILE_ID EQP_QUAL_PROFILE_ID,

WOR.REASON_FOR_REPAIR_CODE_ID REASON_FOR_REPAIR_CODE_ID,

WOR.REPAIR_TXN_CODE_ID REPAIR_TXN_CODE_ID,

WOR.WORK_ACCOMPLISHED_CODE_ID WORK_ACCOMPLISHED_CODE_ID,

WOR.CREATED_BY CREATED_BY,

WOR.CREATION_DATE CREATION_DATE,

WOR.LAST_UPDATED_BY LAST_UPDATED_BY,

WOR.LAST_UPDATE_DATE LAST_UPDATE_DATE,

WOR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

WOR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

WOR.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

WOR.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

WOR.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

WOR.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

WOR.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

WOR.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

WOR.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

WOR.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

WOR.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

WOR.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

WOR.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

WOR.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

WOR.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

WOR.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

WOR.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

WOR.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

WOR.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

WOR.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

WOR.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

WOR.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

WOR.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

WOR.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

WOR.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

WOR.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

WOR.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

WOR.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

WOR.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

WOR.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

WOR.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

WOR.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

WOR.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

WOR.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

WOR.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

WOR.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

WOR.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

WOR.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

WOR.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

WOR.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

WOR.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

WOR.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

WOR.REQUEST_ID REQUEST_ID,

WOR.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

WOR.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE

FROM

WIE_WO_OPERATION_RESOURCES WOR