1. Tables and Views for HCM
  2. HWM_TM_ALLOW_EXPS_V

HWM_TM_ALLOW_EXPS_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

TM_REP_MSGS_ID

APPLICATION_ID

APPLICATION_SHORT_NAME

MESSAGE_NAME

MESSAGE_LEVEL

TM_BLDG_BLK_ID

TM_BLDG_BLK_VERSION

ENTERPRISE_ID

OBJECT_VERSION_NUMBER

TM_REP_ATRB_USAGE_ID

TM_REC_ID

TM_REC_VERSION

TM_REC_GRP_ID

TM_REC_GRP_VERSION

TRN_ID

TM_EVENT_ID

MESSAGE_FIELD

DATE_FROM

DATE_TO

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

TM_REP_ALLOW_EXPS_ID

ALLOW_EXCEPTION

ALLOW_EXCEPTION_FLAG

ALLOWEX_CREATED_BY

ALLOWEX_CREATION_DATE

ALLOWEX_LAST_UPDATED_BY

ALLOWEX_LAST_UPDATE_DATE

ALLOWEX_LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

TimeMessagePEO.TM_REP_MSGS_ID,

TimeMessagePEO.APPLICATION_ID,

TimeMessagePEO.APPLICATION_SHORT_NAME,

TimeMessagePEO.MESSAGE_NAME,

TimeMessagePEO.MESSAGE_LEVEL,

TimeMessagePEO.TM_BLDG_BLK_ID,

TimeMessagePEO.TM_BLDG_BLK_VERSION,

TimeMessagePEO.ENTERPRISE_ID,

TimeMessagePEO.OBJECT_VERSION_NUMBER,

TimeMessagePEO.TM_REP_ATRB_USAGE_ID,

TimeMessagePEO.TM_REC_ID,

TimeMessagePEO.TM_REC_VERSION,

TimeMessagePEO.TM_REC_GRP_ID,

TimeMessagePEO.TM_REC_GRP_VERSION,

TimeMessagePEO.TRN_ID,

TimeMessagePEO.TM_EVENT_ID,

TimeMessagePEO.MESSAGE_FIELD,

TimeMessagePEO.DATE_FROM,

TimeMessagePEO.DATE_TO,

TimeMessagePEO.CREATED_BY,

TimeMessagePEO.CREATION_DATE,

TimeMessagePEO.LAST_UPDATED_BY,

TimeMessagePEO.LAST_UPDATE_DATE,

TimeMessagePEO.LAST_UPDATE_LOGIN,

AllowExceptionPEO.TM_REP_ALLOW_EXPS_ID,

AllowExceptionPEO.ALLOW_EXCEPTION,

DECODE(TimeMessagePEO.TM_REP_MSGS_ID, NULL, NULL,

NVL(AllowExceptionPEO.ALLOW_EXCEPTION, 'N')) ALLOW_EXCEPTION_FLAG,

AllowExceptionPEO.CREATED_BY AllowEx_CREATED_BY,

AllowExceptionPEO.CREATION_DATE AllowEx_CREATION_DATE,

AllowExceptionPEO.LAST_UPDATED_BY AllowEx_LAST_UPDATED_BY,

AllowExceptionPEO.LAST_UPDATE_DATE AllowEx_LAST_UPDATE_DATE,

AllowExceptionPEO.LAST_UPDATE_LOGIN AllowEx_LAST_UPDATE_LOGIN

FROM HWM_TM_REP_MSGS TimeMessagePEO,

HWM_TM_REP_ALLOW_EXPS AllowExceptionPEO

WHERE TimeMessagePEO.MESSAGE_NAME = AllowExceptionPEO.TM_REP_MSGS_NAME(+)

AND TimeMessagePEO.TM_BLDG_BLK_ID = AllowExceptionPEO.TM_BLDG_BLK_ID(+)

AND TimeMessagePEO.TM_BLDG_BLK_VERSION = AllowExceptionPEO.TM_BLDG_BLK_VERSION(+)

AND AllowExceptionPEO.CREATION_DATE (+) BETWEEN TimeMessagePEO.DATE_FROM AND TimeMessagePEO.DATE_TO