1. Tables and Views for SCM
  2. RCS_RESOURCE_AVL_DTLS_V

RCS_RESOURCE_AVL_DTLS_V

Details

  • Schema: FUSION

  • Object owner: RCS

  • Object type: VIEW

Columns

Name

RESOURCE_SCHEDULE_ID

SCHEDULE_DETAIL_ID

SCHEDULE_ID

SHIFT_ID

EXCEPTION_ID

START_DATE_TIME

END_DATE_TIME

MFG_ORG_IDENTIFIER

WORK_CENTER_ID

WC_RESOURCE_IDENTIFIER

AVAILABLE_UNITS

Query

SQL_Statement

SELECT

RCS_RESOURCE_AVL_DTLS.RESOURCE_SCHEDULE_ID RESOURCE_SCHEDULE_ID,

RCS_RESOURCE_AVL_DTLS.SCHEDULE_DETAIL_ID SCHEDULE_DETAIL_ID,

RCS_RESOURCE_AVL_DTLS.SCHEDULE_ID SCHEDULE_ID,

RCS_RESOURCE_AVL_DTLS.SHIFT_ID SHIFT_ID,

RCS_RESOURCE_AVL_DTLS.EXCEPTION_ID EXCEPTION_ID,

RCS_RESOURCE_AVL_DTLS.START_DATE_TIME START_DATE_TIME,

RCS_RESOURCE_AVL_DTLS.END_DATE_TIME END_DATE_TIME,

RCS_RESOURCE_AVL_DTLS.MFG_ORG_IDENTIFIER MFG_ORG_IDENTIFIER,

RCS_RESOURCE_AVL_DTLS.WORK_CENTER_ID WORK_CENTER_ID,

RCS_RESOURCE_AVL_DTLS.WC_RESOURCE_IDENTIFIER WC_RESOURCE_IDENTIFIER,

RCS_RESOURCE_AVL_DTLS.AVAILABLE_UNITS AVAILABLE_UNITS

FROM

RCS_RESOURCE_AVL_DTLS