DBA Data[Home] [Help]

VIEW: HR.HR_S_FORMULA_RESULT_RULES_F#

Source

View Text - Preformatted

select FORMULA_RESULT_RULE_ID FORMULA_RESULT_RULE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, STATUS_PROCESSING_RULE_ID STATUS_PROCESSING_RULE_ID, RESULT_NAME RESULT_NAME, RESULT_RULE_TYPE RESULT_RULE_TYPE, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP, SEVERITY_LEVEL SEVERITY_LEVEL, INPUT_VALUE_ID INPUT_VALUE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."HR_S_FORMULA_RESULT_RULES_F"
View Text - HTML Formatted

SELECT FORMULA_RESULT_RULE_ID FORMULA_RESULT_RULE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, STATUS_PROCESSING_RULE_ID STATUS_PROCESSING_RULE_ID
, RESULT_NAME RESULT_NAME
, RESULT_RULE_TYPE RESULT_RULE_TYPE
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
, SEVERITY_LEVEL SEVERITY_LEVEL
, INPUT_VALUE_ID INPUT_VALUE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."HR_S_FORMULA_RESULT_RULES_F"