VIEW: APPS.HXC_TIME_ENTRY_RULE_COMPS_V

Source

View Text - Preformatted

SELECT egc.ROWID ROW_ID ,egc.ENTITY_GROUP_COMP_ID time_entry_group_comp_id ,egc.ENTITY_GROUP_ID time_entry_rule_group_id ,egc.ENTITY_ID time_entry_rule_id ,ter.name time_entry_rule_name ,egc.attribute1 rule_outcome ,lk.meaning rule_outcome_name ,ter.RULE_USAGE ,ter.RULE_USAGE_NAME ,ter.MAPPING_ID ,ter.MAPPING_NAME ,ter.FORMULA_ID ,ter.ff_description FORMULA_NAME ,ter.DESCRIPTION ,ter.START_DATE ,DECODE( ter.END_DATE, hr_general.end_of_time, null, ter.end_Date) end_date ,egc.ATTRIBUTE_CATEGORY ,egc.ATTRIBUTE1 ,egc.ATTRIBUTE2 ,egc.ATTRIBUTE3 ,egc.ATTRIBUTE4 ,egc.ATTRIBUTE5 ,egc.ATTRIBUTE6 ,egc.ATTRIBUTE7 ,egc.ATTRIBUTE8 ,egc.ATTRIBUTE9 ,egc.ATTRIBUTE10 ,egc.ATTRIBUTE11 ,egc.ATTRIBUTE12 ,egc.ATTRIBUTE13 ,egc.ATTRIBUTE14 ,egc.ATTRIBUTE15 ,egc.ATTRIBUTE16 ,egc.ATTRIBUTE17 ,egc.ATTRIBUTE18 ,egc.ATTRIBUTE19 ,egc.ATTRIBUTE20 ,egc.ATTRIBUTE21 ,egc.ATTRIBUTE22 ,egc.ATTRIBUTE23 ,egc.ATTRIBUTE24 ,egc.ATTRIBUTE25 ,egc.ATTRIBUTE26 ,egc.ATTRIBUTE27 ,egc.ATTRIBUTE28 ,egc.ATTRIBUTE29 ,egc.ATTRIBUTE30 ,egc.OBJECT_VERSION_NUMBER ,egc.CREATED_BY ,egc.CREATION_DATE ,egc.LAST_UPDATED_BY ,egc.LAST_UPDATE_DATE ,egc.LAST_UPDATE_LOGIN FROM hr_lookups lk , hxc_time_entry_rules_v ter , hxc_entity_group_comps egc WHERE egc.entity_type = 'TIME_ENTRY_RULES' AND ter.time_entry_rule_id = egc.entity_id AND lk.lookup_type = 'HXC_TIME_ENTRY_RULE_OUTCOME' AND lk.lookup_code = egc.attribute1

View Text - HTML Formatted

SELECT EGC.ROWID ROW_ID
, EGC.ENTITY_GROUP_COMP_ID TIME_ENTRY_GROUP_COMP_ID
, EGC.ENTITY_GROUP_ID TIME_ENTRY_RULE_GROUP_ID
, EGC.ENTITY_ID TIME_ENTRY_RULE_ID
, TER.NAME TIME_ENTRY_RULE_NAME
, EGC.ATTRIBUTE1 RULE_OUTCOME
, LK.MEANING RULE_OUTCOME_NAME
, TER.RULE_USAGE
, TER.RULE_USAGE_NAME
, TER.MAPPING_ID
, TER.MAPPING_NAME
, TER.FORMULA_ID
, TER.FF_DESCRIPTION FORMULA_NAME
, TER.DESCRIPTION
, TER.START_DATE
, DECODE( TER.END_DATE
, HR_GENERAL.END_OF_TIME
, NULL
, TER.END_DATE) END_DATE
, EGC.ATTRIBUTE_CATEGORY
, EGC.ATTRIBUTE1
, EGC.ATTRIBUTE2
, EGC.ATTRIBUTE3
, EGC.ATTRIBUTE4
, EGC.ATTRIBUTE5
, EGC.ATTRIBUTE6
, EGC.ATTRIBUTE7
, EGC.ATTRIBUTE8
, EGC.ATTRIBUTE9
, EGC.ATTRIBUTE10
, EGC.ATTRIBUTE11
, EGC.ATTRIBUTE12
, EGC.ATTRIBUTE13
, EGC.ATTRIBUTE14
, EGC.ATTRIBUTE15
, EGC.ATTRIBUTE16
, EGC.ATTRIBUTE17
, EGC.ATTRIBUTE18
, EGC.ATTRIBUTE19
, EGC.ATTRIBUTE20
, EGC.ATTRIBUTE21
, EGC.ATTRIBUTE22
, EGC.ATTRIBUTE23
, EGC.ATTRIBUTE24
, EGC.ATTRIBUTE25
, EGC.ATTRIBUTE26
, EGC.ATTRIBUTE27
, EGC.ATTRIBUTE28
, EGC.ATTRIBUTE29
, EGC.ATTRIBUTE30
, EGC.OBJECT_VERSION_NUMBER
, EGC.CREATED_BY
, EGC.CREATION_DATE
, EGC.LAST_UPDATED_BY
, EGC.LAST_UPDATE_DATE
, EGC.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS LK
, HXC_TIME_ENTRY_RULES_V TER
, HXC_ENTITY_GROUP_COMPS EGC
WHERE EGC.ENTITY_TYPE = 'TIME_ENTRY_RULES'
AND TER.TIME_ENTRY_RULE_ID = EGC.ENTITY_ID
AND LK.LOOKUP_TYPE = 'HXC_TIME_ENTRY_RULE_OUTCOME'
AND LK.LOOKUP_CODE = EGC.ATTRIBUTE1