VIEW: APPS.HXC_TIME_ENTRY_RULES_V

Source

View Text - Preformatted

SELECT ter.rowid ROW_ID, ter.TIME_ENTRY_RULE_ID, ter.NAME, ter.RULE_USAGE, ter.business_group_id, ter.legislation_code, (select usage.meaning from hxc_lookups usage where usage.lookup_code=ter.rule_usage AND usage.lookup_type='HXC_APPROVAL_RULE_USAGE') RULE_USAGE_NAME, ter.MAPPING_ID, map.name MAPPING_NAME, ter.FORMULA_ID, ff.FORMULA_NAME, ff.description ff_description, ter.DESCRIPTION, ter.START_DATE, ter.END_DATE, ter.OBJECT_VERSION_NUMBER, ter.CREATED_BY, ter.CREATION_DATE, ter.LAST_UPDATED_BY, ter.LAST_UPDATE_DATE, ter.LAST_UPDATE_LOGIN, ter.ATTRIBUTE_CATEGORY, ter.ATTRIBUTE1, ter.ATTRIBUTE2, ter.ATTRIBUTE3, ter.ATTRIBUTE4, ter.ATTRIBUTE5, ter.ATTRIBUTE6, ter.ATTRIBUTE7, ter.ATTRIBUTE8, ter.ATTRIBUTE9, ter.ATTRIBUTE10, ter.ATTRIBUTE11, ter.ATTRIBUTE12, ter.ATTRIBUTE13, ter.ATTRIBUTE14, ter.ATTRIBUTE15, ter.ATTRIBUTE16, ter.ATTRIBUTE17, ter.ATTRIBUTE18, ter.ATTRIBUTE19, ter.ATTRIBUTE20, ter.ATTRIBUTE21, ter.ATTRIBUTE22, ter.ATTRIBUTE23, ter.ATTRIBUTE24, ter.ATTRIBUTE25, ter.ATTRIBUTE26, ter.ATTRIBUTE27, ter.ATTRIBUTE28, ter.ATTRIBUTE29, ter.ATTRIBUTE30 FROM hxc_mappings map, ff_formulas_f ff, hxc_time_entry_rules ter WHERE ff.formula_id(+) = ter.formula_id AND ter.start_date BETWEEN ff.effective_start_date(+) AND ff.effective_end_date(+) AND map.mapping_id(+) = ter.mapping_id

View Text - HTML Formatted

SELECT TER.ROWID ROW_ID
, TER.TIME_ENTRY_RULE_ID
, TER.NAME
, TER.RULE_USAGE
, TER.BUSINESS_GROUP_ID
, TER.LEGISLATION_CODE
, (SELECT USAGE.MEANING
FROM HXC_LOOKUPS USAGE
WHERE USAGE.LOOKUP_CODE=TER.RULE_USAGE
AND USAGE.LOOKUP_TYPE='HXC_APPROVAL_RULE_USAGE') RULE_USAGE_NAME
, TER.MAPPING_ID
, MAP.NAME MAPPING_NAME
, TER.FORMULA_ID
, FF.FORMULA_NAME
, FF.DESCRIPTION FF_DESCRIPTION
, TER.DESCRIPTION
, TER.START_DATE
, TER.END_DATE
, TER.OBJECT_VERSION_NUMBER
, TER.CREATED_BY
, TER.CREATION_DATE
, TER.LAST_UPDATED_BY
, TER.LAST_UPDATE_DATE
, TER.LAST_UPDATE_LOGIN
, TER.ATTRIBUTE_CATEGORY
, TER.ATTRIBUTE1
, TER.ATTRIBUTE2
, TER.ATTRIBUTE3
, TER.ATTRIBUTE4
, TER.ATTRIBUTE5
, TER.ATTRIBUTE6
, TER.ATTRIBUTE7
, TER.ATTRIBUTE8
, TER.ATTRIBUTE9
, TER.ATTRIBUTE10
, TER.ATTRIBUTE11
, TER.ATTRIBUTE12
, TER.ATTRIBUTE13
, TER.ATTRIBUTE14
, TER.ATTRIBUTE15
, TER.ATTRIBUTE16
, TER.ATTRIBUTE17
, TER.ATTRIBUTE18
, TER.ATTRIBUTE19
, TER.ATTRIBUTE20
, TER.ATTRIBUTE21
, TER.ATTRIBUTE22
, TER.ATTRIBUTE23
, TER.ATTRIBUTE24
, TER.ATTRIBUTE25
, TER.ATTRIBUTE26
, TER.ATTRIBUTE27
, TER.ATTRIBUTE28
, TER.ATTRIBUTE29
, TER.ATTRIBUTE30
FROM HXC_MAPPINGS MAP
, FF_FORMULAS_F FF
, HXC_TIME_ENTRY_RULES TER
WHERE FF.FORMULA_ID(+) = TER.FORMULA_ID
AND TER.START_DATE BETWEEN FF.EFFECTIVE_START_DATE(+)
AND FF.EFFECTIVE_END_DATE(+)
AND MAP.MAPPING_ID(+) = TER.MAPPING_ID