Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_TIME_ENTRY_RULES_V |
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