HWM_TCD_EXP_DATA_SCH_ALL_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

SCHEDULE_DATA_ID DELETE_FLAG SCHEDULE_DATA_VERSION PERSON_ID SCH_REC_ID SCH_REC_VERSION SHIFT_ORIGIN LATEST_VERSION SHIFT_ID START_TIME END_TIME REC_TYPE OBJECT_VERSION_NUMBER ENTERPRISE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN STATUS TCD_EXP_DATA_ESS_PROCESS_ID TCD_EXP_DATA_SCH_TXN_ID TXN_SCHEDULE_DATA_ID TXN_SCHEDULE_DATA_VERSION TCD_EXP_DATA_TXN_ID TCD_EXP_DATA_TXN_BATCH_ID TXN_DELETE_FLAG TXN_OBJECT_VERSION_NUMBER TXN_ENTERPRISE_ID TXN_CREATED_BY TXN_CREATION_DATE TXN_LAST_UPDATED_BY TXN_LAST_UPDATE_DATE TXN_LAST_UPDATE_LOGIN TCD_EXP_DATA_TXN_TYPE TXN_STATUS

Query

SQL_Statement

SELECT SCH.SCHEDULE_DATA_ID, SCH.DELETE_FLAG, SCH.SCHEDULE_DATA_VERSION, SCH.PERSON_ID, SCH.SCH_REC_ID, SCH.SCH_REC_VERSION, SCH.SHIFT_ORIGIN, SCH.LATEST_VERSION, SCH.SHIFT_ID, SCH.START_TIME, SCH.END_TIME, SCH.REC_TYPE, SCH.OBJECT_VERSION_NUMBER, SCH.ENTERPRISE_ID, SCH.CREATED_BY, SCH.CREATION_DATE, SCH.LAST_UPDATED_BY, SCH.LAST_UPDATE_DATE, SCH.LAST_UPDATE_LOGIN, SCH.STATUS, SCH.TCD_EXP_DATA_ESS_PROCESS_ID, SCH_TXN.TCD_EXP_DATA_SCH_TXN_ID, SCH_TXN.SCHEDULE_DATA_ID TXN_SCHEDULE_DATA_ID, SCH_TXN.SCHEDULE_DATA_VERSION TXN_SCHEDULE_DATA_VERSION, SCH_TXN.TCD_EXP_DATA_TXN_ID, SCH_TXN.TCD_EXP_DATA_TXN_BATCH_ID, SCH_TXN.DELETE_FLAG TXN_DELETE_FLAG, SCH_TXN.OBJECT_VERSION_NUMBER TXN_OBJECT_VERSION_NUMBER, SCH_TXN.ENTERPRISE_ID TXN_ENTERPRISE_ID, SCH_TXN.CREATED_BY TXN_CREATED_BY, SCH_TXN.CREATION_DATE TXN_CREATION_DATE, SCH_TXN.LAST_UPDATED_BY TXN_LAST_UPDATED_BY, SCH_TXN.LAST_UPDATE_DATE TXN_LAST_UPDATE_DATE, SCH_TXN.LAST_UPDATE_LOGIN TXN_LAST_UPDATE_LOGIN, SCH_TXN.TCD_EXP_DATA_TXN_TYPE, SCH_TXN.STATUS TXN_STATUS FROM HWM_TCD_EXP_DATA_SCH SCH, HWM_TCD_EXP_DATA_SCH_TXN SCH_TXN WHERE SCH.SCHEDULE_DATA_ID = SCH_TXN.SCHEDULE_DATA_ID AND SCH.SCHEDULE_DATA_VERSION = SCH_TXN.SCHEDULE_DATA_VERSION AND SCH.LATEST_VERSION = 'Y'