1. Tables and Views for SCM
  2. MSS_WO_DURATION_RESOURCES_V

MSS_WO_DURATION_RESOURCES_V

Details

  • Schema: FUSION

  • Object owner: MSS

  • Object type: VIEW

Columns

Name

PLAN_ID

WO_OPERATION_ID

RESOURCE_SEQ_NUMBER

OPERATION_SEQ_NUMBER

OPERATION_CODE

OPERATION_NAME

WORK_CENTER_ID

WORK_CENTER_CODE

WORK_ORDER_ID

WO_OPERATION_RESOURCE_ID

WD_OPERATION_RESOURCE_ID

DURATION_RES_SET_CODE

DURATION_RES_ID

DURATION_RES_CODE

DURATION

EXPENDED_DURATION

REMAINING_DURATION

DURATION_UNIT

Query

SQL_Statement

SELECT

wop.PLAN_ID,

wop.WO_OPERATION_ID,

wop.RESOURCE_SEQ_NUMBER,

wop.OPERATION_SEQ_NUMBER,

wop.OPERATION_CODE,

wop.OPERATION_NAME,

r.WORK_CENTER_ID,

r.WORK_CENTER_CODE,

wop.WORK_ORDER_ID,

wres.WO_OPERATION_RESOURCE_ID,

wres.WD_OPERATION_RESOURCE_ID,

wop.DURATION_RES_SET_CODE,

NVL(wop.DURATION_RES_ID, wres.RESOURCE_ID) DURATION_RES_ID,

r.RESOURCE_CODE DURATION_RES_CODE,

wres.DURATION,

wres.EXPENDED_DURATION,

wres.REMAINING_DURATION,

wres.DURATION_UNIT

FROM MSS_WO_OPERATION_RESOURCES wres

INNER JOIN MSS_WO_OPERATIONS wop

ON wres.PLAN_ID = wop.PLAN_ID AND wres.WO_OPERATION_ID = wop.WO_OPERATION_ID AND wres.RESOURCE_SEQ_NUMBER = wop.RESOURCE_SEQ_NUMBER

INNER JOIN MSS_RESOURCES r

ON wop.PLAN_ID = r.PLAN_ID AND (wop.WORK_CENTER_ID = r.WORK_CENTER_ID or r.WORK_CENTER_ID = -1) and NVL(wop.DURATION_RES_ID, wres.RESOURCE_ID) = r.RESOURCE_ID

WHERE

wres.DURATION_RESOURCE_FLAG = 'Y'