HWM_TM_REP_S_ABS_HP_ATRBS_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

ANC_TIME_REPOS_ATRB_ID

ANC_ATTRIBUTE_CATEGORY

ANC_ABSENCE_ENTRY_ID

ANC_END_OF_BREAKDOWN

USAGES_SOURCE_ID

USAGES_SOURCE_VERSION

Query

SQL_Statement

select TimeAttribute.tm_rep_atrb_id Anc_Time_Repos_Atrb_id,

TimeAttribute.attribute_category Anc_Attribute_Category,

TimeAttribute.attribute_number3 Anc_Absence_Entry_Id,

TimeAttribute.attribute_timestamp1 Anc_End_Of_Breakdown,

TimeAttributeUsages.usages_source_id,

TimeAttributeUsages.usages_source_version

from HWM_TM_REC_GRP TimeCard,

HWM_TM_REC_GRP_USAGES TimeRecordGroupUsages,

HWM_TM_REC TimeEntry,

HWM_TM_REP_ATRBS TimeAttribute,

HWM_TM_REP_ATRB_USAGES TimeAttributeUsages

where TimeCard.TM_REC_GRP_ID = TimeRecordGroupUsages.TM_REC_GRP_ID

and TimeCard.TM_REC_GRP_VERSION = TimeRecordGroupUsages.TM_REC_GRP_VERSION

and TimeEntry.TM_REC_ID = TimeRecordGroupUsages.TM_REC_ID

and TimeEntry.TM_REC_VERSION = TimeRecordGroupUsages.TM_REC_VERSION

and TimeEntry.TM_REC_ID = TimeAttributeUsages.USAGES_SOURCE_ID

and TimeEntry.TM_REC_VERSION = TimeAttributeUsages.USAGES_SOURCE_VERSION

and TimeAttribute.TM_REP_ATRB_ID = TimeAttributeUsages.TM_REP_ATRB_ID

and TimeCard.GRP_TYPE_ID = 105

and TimeAttribute.attribute_category = 'AbsenceHeaderParams'