VIEW: MTH.MTH_WORKDAY_SHIFTS_D#

Source

View Text - Preformatted

select SHIFT_WORKDAY_PK_KEY SHIFT_WORKDAY_PK_KEY, SHIFT_WORKDAY_PK SHIFT_WORKDAY_PK, SHIFT_DATE SHIFT_DATE, SHIFT_DATE_JULIAN SHIFT_DATE_JULIAN, PLANT_FK_KEY PLANT_FK_KEY, SYSTEM_FK_KEY SYSTEM_FK_KEY, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_SYSTEM_ID CREATION_SYSTEM_ID, LAST_UPDATE_SYSTEM_ID LAST_UPDATE_SYSTEM_ID, FROM_DATE FROM_DATE, TO_DATE TO_DATE, SHIFT_NUM SHIFT_NUM, SHIFT_NAME SHIFT_NAME, SOURCE_ORG_CODE SOURCE_ORG_CODE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, SHIFT_TYPE SHIFT_TYPE, GRAVEYARD_SHIFT GRAVEYARD_SHIFT from "MTH"."MTH_WORKDAY_SHIFTS_D"

View Text - HTML Formatted

SELECT SHIFT_WORKDAY_PK_KEY SHIFT_WORKDAY_PK_KEY
, SHIFT_WORKDAY_PK SHIFT_WORKDAY_PK
, SHIFT_DATE SHIFT_DATE
, SHIFT_DATE_JULIAN SHIFT_DATE_JULIAN
, PLANT_FK_KEY PLANT_FK_KEY
, SYSTEM_FK_KEY SYSTEM_FK_KEY
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_SYSTEM_ID CREATION_SYSTEM_ID
, LAST_UPDATE_SYSTEM_ID LAST_UPDATE_SYSTEM_ID
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, SHIFT_NUM SHIFT_NUM
, SHIFT_NAME SHIFT_NAME
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, SHIFT_TYPE SHIFT_TYPE
, GRAVEYARD_SHIFT GRAVEYARD_SHIFT
FROM "MTH"."MTH_WORKDAY_SHIFTS_D"