RCS_PLANT_SHIFT_EXC

Details

Schema: FUSION
Object owner: RCS
Object type: VIEW

Columns

Name
PLANT_SHIFT_EXC_ID NAME REASON ORGANIZATION_ID MFG_WC_ID SCHEDULE_ID ASSOCIATED_SHIFT_ID START_DATE END_DATE EXCEPTION_TYPE EXC_START_TIME EXC_DURATION EXC_END_TIME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Name

PLANT_SHIFT_EXC_ID

NAME

REASON

ORGANIZATION_ID

MFG_WC_ID

SCHEDULE_ID

ASSOCIATED_SHIFT_ID

START_DATE

END_DATE

EXCEPTION_TYPE

EXC_START_TIME

EXC_DURATION

EXC_END_TIME

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT RCS_PLANT_SHIFT_EXC_B.PLANT_SHIFT_EXC_ID PLANT_SHIFT_EXC_ID, RCS_PLANT_SHIFT_EXC_TL.NAME NAME, RCS_PLANT_SHIFT_EXC_TL.REASON REASON, RCS_PLANT_SHIFT_EXC_B.ORGANIZATION_ID ORGANIZATION_ID, RCS_PLANT_SHIFT_EXC_B.MFG_WC_ID MFG_WC_ID, RCS_PLANT_SHIFT_EXC_B.SCHEDULE_ID SCHEDULE_ID, RCS_PLANT_SHIFT_EXC_B.ASSOCIATED_SHIFT_ID ASSOCIATED_SHIFT_ID, RCS_PLANT_SHIFT_EXC_B.START_DATE START_DATE, RCS_PLANT_SHIFT_EXC_B.END_DATE END_DATE, RCS_PLANT_SHIFT_EXC_B.EXCEPTION_TYPE EXCEPTION_TYPE, RCS_PLANT_SHIFT_EXC_B.EXC_START_TIME EXC_START_TIME, RCS_PLANT_SHIFT_EXC_B.EXC_DURATION EXC_DURATION, RCS_PLANT_SHIFT_EXC_B.EXC_END_TIME EXC_END_TIME, RCS_PLANT_SHIFT_EXC_B.CREATED_BY CREATED_BY, RCS_PLANT_SHIFT_EXC_B.CREATION_DATE CREATION_DATE, RCS_PLANT_SHIFT_EXC_B.LAST_UPDATED_BY LAST_UPDATED_BY, RCS_PLANT_SHIFT_EXC_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, RCS_PLANT_SHIFT_EXC_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RCS_PLANT_SHIFT_EXC_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM RCS_PLANT_SHIFT_EXC_B, RCS_PLANT_SHIFT_EXC_TL WHERE RCS_PLANT_SHIFT_EXC_B.PLANT_SHIFT_EXC_ID = RCS_PLANT_SHIFT_EXC_TL.PLANT_SHIFT_EXC_ID AND RCS_PLANT_SHIFT_EXC_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

RCS_PLANT_SHIFT_EXC_B.PLANT_SHIFT_EXC_ID PLANT_SHIFT_EXC_ID,

RCS_PLANT_SHIFT_EXC_TL.NAME NAME,

RCS_PLANT_SHIFT_EXC_TL.REASON REASON,

RCS_PLANT_SHIFT_EXC_B.ORGANIZATION_ID ORGANIZATION_ID,

RCS_PLANT_SHIFT_EXC_B.MFG_WC_ID MFG_WC_ID,

RCS_PLANT_SHIFT_EXC_B.SCHEDULE_ID SCHEDULE_ID,

RCS_PLANT_SHIFT_EXC_B.ASSOCIATED_SHIFT_ID ASSOCIATED_SHIFT_ID,

RCS_PLANT_SHIFT_EXC_B.START_DATE START_DATE,

RCS_PLANT_SHIFT_EXC_B.END_DATE END_DATE,

RCS_PLANT_SHIFT_EXC_B.EXCEPTION_TYPE EXCEPTION_TYPE,

RCS_PLANT_SHIFT_EXC_B.EXC_START_TIME EXC_START_TIME,

RCS_PLANT_SHIFT_EXC_B.EXC_DURATION EXC_DURATION,

RCS_PLANT_SHIFT_EXC_B.EXC_END_TIME EXC_END_TIME,

RCS_PLANT_SHIFT_EXC_B.CREATED_BY CREATED_BY,

RCS_PLANT_SHIFT_EXC_B.CREATION_DATE CREATION_DATE,

RCS_PLANT_SHIFT_EXC_B.LAST_UPDATED_BY LAST_UPDATED_BY,

RCS_PLANT_SHIFT_EXC_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

RCS_PLANT_SHIFT_EXC_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

RCS_PLANT_SHIFT_EXC_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM

RCS_PLANT_SHIFT_EXC_B,

RCS_PLANT_SHIFT_EXC_TL

WHERE

RCS_PLANT_SHIFT_EXC_B.PLANT_SHIFT_EXC_ID = RCS_PLANT_SHIFT_EXC_TL.PLANT_SHIFT_EXC_ID AND RCS_PLANT_SHIFT_EXC_TL.LANGUAGE = USERENV('LANG')