1. Tables and Views for SCM
  2. MSC_AP_RESOURCE_AVL_V

MSC_AP_RESOURCE_AVL_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ORGANIZATION_CODE

DEPARTMENT_CODE

RESOURCE_CODE

FROM_TIME

TO_TIME

CAPACITY_UNITS

AVAILABILITY

AVAILABLE_UOM

Query

SQL_Statement

SELECT

RES.ORGANIZATION_CODE,

RES.DEPARTMENT_CODE,

RES.RESOURCE_CODE,

RCS.START_DATE_TIME FROM_TIME,

RCS.END_DATE_TIME TO_TIME,

RCS.AVAILABLE_UNITS CAPACITY_UNITS,

(case (trunc(RCS.END_DATE_TIME,'DDD')-trunc( RCS.START_DATE_TIME,'DDD')) when 0 then ((to_char(RCS.END_DATE_TIME,'SSSSS') - to_char(RCS.START_DATE_TIME,'SSSSS'))/3600)

else ((to_char(RCS.END_DATE_TIME,'SSSSS') - to_char(RCS.START_DATE_TIME,'SSSSS'))/3600)+(trunc(RCS.END_DATE_TIME,'DDD')-trunc( RCS.START_DATE_TIME,'DDD'))*24 end) AVAILABILITY,

NULL AVAILABLE_UOM

FROM RCS_RESOURCE_AVL_DTLS_V RCS, MSC_AP_RESOURCES_V RES

WHERE RCS.MFG_ORG_IDENTIFIER = RES.ORGANIZATION_ID

AND RCS.WORK_CENTER_ID = RES.DEPARTMENT_ID

AND RCS.WC_RESOURCE_IDENTIFIER = RES.RESOURCE_ID

AND RCS.AVAILABLE_UNITS > 0