1. Tables and Views for HCM
  2. HWM_EXT_TIMECARD_DETAIL_V

HWM_EXT_TIMECARD_DETAIL_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

TM_REC_ID

ORIG_TM_REC_ID

ORIG_TM_REC_VERSION

TM_REC_VERSION

OBJECT_VERSION_NUMBER

ENTERPRISE_ID

TM_REC_TYPE

ACTIVITY_TYPE

ACTIVITY_EVENT_TIME

MEASURE

UNIT_OF_MEASURE

START_TIME

STOP_TIME

USER_STATUS

DELETE_FLAG

LAYER_CODE

COMMENT_TEXT

RESOURCE_ID

RESOURCE_TYPE

SUBRESOURCE_ID

TIME_REPORTER_ID

DATE_FROM

DATE_TO

START_TIME_TRUNC

STOP_TIME_TRUNC

DATE_FROM_TRUNC

DATE_TO_TRUNC

ORDER_ENTERED

TCSMR_SET_ID

TCSMR_CONFIG_SET_ID

DATA_SET_ID

LATEST_VERSION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

TM_REC_GRP_USAGES_ID

TM_REC_GRP_ID

TM_REC_GRP_VERSION

PARENT_TM_REC_GRP_ID

PARENT_TM_REC_GRP_VERSION

GRP_TYPE_NAME

Query

SQL_Statement

SELECT rec.TM_REC_ID ,

rec.ORIG_TM_REC_ID ,

rec.ORIG_TM_REC_VERSION ,

rec.TM_REC_VERSION ,

rec.OBJECT_VERSION_NUMBER ,

rec.ENTERPRISE_ID ,

rec.TM_REC_TYPE ,

rec.ACTIVITY_TYPE ,

rec.ACTIVITY_EVENT_TIME ,

rec.MEASURE ,

rec.UNIT_OF_MEASURE ,

rec.START_TIME ,

rec.STOP_TIME ,

rec.USER_STATUS ,

rec.DELETE_FLAG ,

rec.LAYER_CODE ,

rec.COMMENT_TEXT ,

rec.RESOURCE_ID ,

rec.RESOURCE_TYPE ,

rec.SUBRESOURCE_ID ,

rec.TIME_REPORTER_ID ,

rec.DATE_FROM ,

rec.DATE_TO ,

trunc(rec.START_TIME) START_TIME_TRUNC,

trunc(rec.STOP_TIME) STOP_TIME_TRUNC,

trunc(rec.DATE_FROM) DATE_FROM_TRUNC,

trunc(rec.DATE_TO) DATE_TO_TRUNC,

rec.ORDER_ENTERED ,

rec.TCSMR_SET_ID ,

rec.TCSMR_CONFIG_SET_ID ,

rec.DATA_SET_ID ,

rec.LATEST_VERSION ,

rec.CREATED_BY ,

rec.CREATION_DATE ,

rec.LAST_UPDATED_BY ,

rec.LAST_UPDATE_DATE ,

rec.LAST_UPDATE_LOGIN ,

usg.TM_REC_GRP_USAGES_ID ,

usg.TM_REC_GRP_ID ,

usg.TM_REC_GRP_VERSION ,

hdv. PARENT_TM_REC_GRP_ID ,

hdv. PARENT_TM_REC_GRP_VERSION ,

hgt.NAME AS GRP_TYPE_NAME

FROM HWM_TM_REC rec,

HWM_TM_REC_GRP_USAGES usg ,

HWM_TM_REC_GRP hdv ,

hwm_grp_type hgt

WHERE REC.TM_REC_ID = USG.TM_REC_ID

AND REC.TM_REC_VERSION = USG.TM_REC_VERSION

AND usg.TM_REC_GRP_ID = hdv.TM_REC_GRP_ID

AND usg.TM_REC_GRP_VERSION = hdv.TM_REC_GRP_VERSION

AND hdv.grp_type_id = hgt.grp_type_id

AND NVL(REC.DELETE_FLAG, 'N') <> 'Y'

AND USG.LATEST_VERSION = 'Y'