HWM_TIMECARD_MESSAGES_V

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
TM_REC_GRP_ID TM_REC_GRP_VERSION MESSAGE_NAME MESSAGE_NUMBER APPLICATION_SHORT_NAME APPLICATION_ID MESSAGE_LEVEL MESSAGE_TEXT CONTEXT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN GRP_TYPE_ID MESSAGE_USER_DETAILS DATE_FROM DATE_TO MESSAGE_FIELD

Query

SQL_Statement

select distinct TimeRecordGroupPEO.TM_REC_GRP_ID, TimeRecordGroupPEO.TM_REC_GRP_VERSION, TimeMessagePEO.MESSAGE_NAME, fndMessagesVLPEO.MESSAGE_NUMBER, TimeMessagePEO.APPLICATION_SHORT_NAME, fndMessagesVLPEO.APPLICATION_ID, TimeMessagePEO.MESSAGE_LEVEL, fndMessagesVLPEO.MESSAGE_TEXT, fndMessagesVLPEO.CONTEXT, fndMessagesVLPEO.CREATED_BY, fndMessagesVLPEO.CREATION_DATE, fndMessagesVLPEO.LAST_UPDATED_BY, fndMessagesVLPEO.LAST_UPDATE_DATE, fndMessagesVLPEO.LAST_UPDATE_LOGIN, TimeRecordGroupPEO.GRP_TYPE_ID, fndMessagesVLPEO.MESSAGE_USER_DETAILS, TimeMessagePEO.DATE_FROM, TimeMessagePEO.DATE_TO, TimeMessagePEO.MESSAGE_FIELD from fusion.HWM_TM_REP_MSGS TimeMessagePEO, fusion.FND_MESSAGES_VL fndMessagesVLPEO, fusion.FND_APPLICATION fndApplicationPEO, fusion.HWM_TM_REC_GRP TimeRecordGroupPEO where TimeMessagePEO.APPLICATION_SHORT_NAME = fndApplicationPEO.APPLICATION_SHORT_NAME and TimeMessagePEO.MESSAGE_NAME = fndMessagesVLPEO.MESSAGE_NAME and fndApplicationPEO.APPLICATION_ID = fndMessagesVLPEO.APPLICATION_ID and TimeMessagePEO.TM_BLDG_BLK_ID = TimeRecordGroupPEO.TM_REC_GRP_ID and TimeMessagePEO.TM_BLDG_BLK_VERSION = TimeRecordGroupPEO.TM_REC_GRP_VERSION and TimeRecordGroupPEO.GRP_TYPE_ID IN (100, 101)