PAY_VALUE_DEFINITIONS

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
VALUE_DEFN_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE BASE_NAME VALUE_GROUP_ID CALC_TYPE_ID DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID OVERRIDDEN_DB_ITEM_ID BASE_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID DATE_MODE SOURCE_ID SOURCE_TYPE DIR_OVERRIDE_USAGE_ID ENTERPRISE_ID LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID MODULE_ID CURRENCY_CODE UOM PERIODICITY PERIODICITY_TYPE DEFAULT_CALC_TYPE_ID EXPRESSION SEQUENCE DEFAULT_FLAG VALUE_IDENTIFIER GEOGRAPHY_TYPE_ID VALUE_SET_CODE1 VALUE_SET_CODE2 VALUE_SET_CODE3 VO_NAME1 VO_NAME2 VO_NAME3 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY SEED_STATUS SGUID

Name

VALUE_DEFN_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

BASE_NAME

VALUE_GROUP_ID

CALC_TYPE_ID

DATABASE_ITEM_ID

RANGE_DATABASE_ITEM_ID

OVERRIDDEN_DB_ITEM_ID

BASE_VALUE_DEFN_ID

PARENT_VALUE_DEFN_ID

DATE_MODE

SOURCE_ID

SOURCE_TYPE

DIR_OVERRIDE_USAGE_ID

ENTERPRISE_ID

LEGISLATION_CODE

LEGISLATIVE_DATA_GROUP_ID

MODULE_ID

CURRENCY_CODE

UOM

PERIODICITY

PERIODICITY_TYPE

DEFAULT_CALC_TYPE_ID

EXPRESSION

SEQUENCE

DEFAULT_FLAG

VALUE_IDENTIFIER

GEOGRAPHY_TYPE_ID

VALUE_SET_CODE1

VALUE_SET_CODE2

VALUE_SET_CODE3

VO_NAME1

VO_NAME2

VO_NAME3

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

SEED_STATUS

SGUID

Query

SQL_Statement
SELECT pay_value_defs_v.VALUE_DEFN_ID VALUE_DEFN_ID, pay_value_defs_v.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, pay_value_defs_v.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, pay_value_defs_v.BASE_NAME BASE_NAME, pay_value_defs_v.VALUE_GROUP_ID VALUE_GROUP_ID, pay_value_defs_v.CALC_TYPE_ID CALC_TYPE_ID, pay_value_defs_v.DATABASE_ITEM_ID DATABASE_ITEM_ID, pay_value_defs_v.RANGE_DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID, pay_value_defs_v.OVERRIDDEN_DB_ITEM_ID OVERRIDDEN_DB_ITEM_ID, pay_value_defs_v.BASE_VALUE_DEFN_ID BASE_VALUE_DEFN_ID, pay_value_defs_v.PARENT_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID, pay_value_defs_v.DATE_MODE DATE_MODE, null SOURCE_ID, null SOURCE_TYPE, null DIR_OVERRIDE_USAGE_ID, pay_value_defs_v.ENTERPRISE_ID ENTERPRISE_ID, pay_value_defs_v.LEGISLATION_CODE LEGISLATION_CODE, pay_value_defs_v.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pay_value_defs_v.MODULE_ID MODULE_ID, pay_value_defs_v.CURRENCY_CODE CURRENCY_CODE, pay_value_defs_v.UOM UOM, pay_value_defs_v.PERIODICITY PERIODICITY, pay_value_defs_v.PERIODICITY_TYPE PERIODICITY_TYPE, pay_value_defs_v.DEFAULT_CALC_TYPE_ID DEFAULT_CALC_TYPE_ID, pay_value_defs_v.EXPRESSION EXPRESSION, pay_value_defs_v.SEQUENCE SEQUENCE, pay_value_defs_v.DEFAULT_FLAG DEFAULT_FLAG, pay_value_defs_v.VALUE_IDENTIFIER VALUE_IDENTIFIER, pay_value_defs_v.GEOGRAPHY_TYPE_ID GEOGRAPHY_TYPE_ID, pay_value_defs_v.VALUE_SET_CODE1 VALUE_SET_CODE1, pay_value_defs_v.VALUE_SET_CODE2 VALUE_SET_CODE2, pay_value_defs_v.VALUE_SET_CODE3 VALUE_SET_CODE3, pay_value_defs_v.VO_NAME1 VO_NAME1, pay_value_defs_v.VO_NAME2 VO_NAME2, pay_value_defs_v.VO_NAME3 VO_NAME3, pay_value_defs_v.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pay_value_defs_v.CREATED_BY CREATED_BY, pay_value_defs_v.CREATION_DATE CREATION_DATE, pay_value_defs_v.LAST_UPDATE_DATE LAST_UPDATE_DATE, pay_value_defs_v.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pay_value_defs_v.LAST_UPDATED_BY LAST_UPDATED_BY, pay_value_defs_v.SEED_STATUS SEED_STATUS, pay_value_defs_v.SGUID SGUID FROM pay_value_defs_v union all select pay_value_instances.VALUE_DEFN_ID VALUE_DEFN_ID, pay_value_instances.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, pay_value_instances.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, pay_value_instances.BASE_NAME BASE_NAME, pay_value_instances.VALUE_GROUP_ID VALUE_GROUP_ID, pay_value_instances.CALC_TYPE_ID CALC_TYPE_ID, null DATABASE_ITEM_ID, null RANGE_DATABASE_ITEM_ID, null OVERRIDDEN_DB_ITEM_ID, null BASE_VALUE_DEFN_ID, pay_value_instances.PARENT_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID, pay_value_instances.DATE_MODE DATE_MODE, pay_value_instances.SOURCE_ID SOURCE_ID, pay_value_instances.SOURCE_TYPE SOURCE_TYPE, pay_value_instances.DIR_OVERRIDE_USAGE_ID DIR_OVERRIDE_USAGE_ID, pay_value_instances.ENTERPRISE_ID ENTERPRISE_ID, pay_value_instances.LEGISLATION_CODE LEGISLATION_CODE, pay_value_instances.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, null MODULE_ID, pay_value_instances.CURRENCY_CODE CURRENCY_CODE, pay_value_instances.UOM UOM, pay_value_instances.PERIODICITY PERIODICITY, pay_value_instances.PERIODICITY_TYPE PERIODICITY_TYPE, null DEFAULT_CALC_TYPE_ID, null EXPRESSION, null SEQUENCE, null DEFAULT_FLAG, null VALUE_IDENTIFIER, null GEOGRAPHY_TYPE_ID, null VALUE_SET_CODE1, null VALUE_SET_CODE2, null VALUE_SET_CODE3, null VO_NAME1, null VO_NAME2, null VO_NAME3, pay_value_instances.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pay_value_instances.CREATED_BY CREATED_BY, pay_value_instances.CREATION_DATE CREATION_DATE, pay_value_instances.LAST_UPDATE_DATE LAST_UPDATE_DATE, pay_value_instances.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pay_value_instances.LAST_UPDATED_BY LAST_UPDATED_BY, null SEED_STATUS, null SGUID from pay_value_instances_v pay_value_instances

SQL_Statement

SELECT

pay_value_defs_v.VALUE_DEFN_ID VALUE_DEFN_ID,

pay_value_defs_v.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

pay_value_defs_v.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

pay_value_defs_v.BASE_NAME BASE_NAME,

pay_value_defs_v.VALUE_GROUP_ID VALUE_GROUP_ID,

pay_value_defs_v.CALC_TYPE_ID CALC_TYPE_ID,

pay_value_defs_v.DATABASE_ITEM_ID DATABASE_ITEM_ID,

pay_value_defs_v.RANGE_DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID,

pay_value_defs_v.OVERRIDDEN_DB_ITEM_ID OVERRIDDEN_DB_ITEM_ID,

pay_value_defs_v.BASE_VALUE_DEFN_ID BASE_VALUE_DEFN_ID,

pay_value_defs_v.PARENT_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID,

pay_value_defs_v.DATE_MODE DATE_MODE,

null SOURCE_ID,

null SOURCE_TYPE,

null DIR_OVERRIDE_USAGE_ID,

pay_value_defs_v.ENTERPRISE_ID ENTERPRISE_ID,

pay_value_defs_v.LEGISLATION_CODE LEGISLATION_CODE,

pay_value_defs_v.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

pay_value_defs_v.MODULE_ID MODULE_ID,

pay_value_defs_v.CURRENCY_CODE CURRENCY_CODE,

pay_value_defs_v.UOM UOM,

pay_value_defs_v.PERIODICITY PERIODICITY,

pay_value_defs_v.PERIODICITY_TYPE PERIODICITY_TYPE,

pay_value_defs_v.DEFAULT_CALC_TYPE_ID DEFAULT_CALC_TYPE_ID,

pay_value_defs_v.EXPRESSION EXPRESSION,

pay_value_defs_v.SEQUENCE SEQUENCE,

pay_value_defs_v.DEFAULT_FLAG DEFAULT_FLAG,

pay_value_defs_v.VALUE_IDENTIFIER VALUE_IDENTIFIER,

pay_value_defs_v.GEOGRAPHY_TYPE_ID GEOGRAPHY_TYPE_ID,

pay_value_defs_v.VALUE_SET_CODE1 VALUE_SET_CODE1,

pay_value_defs_v.VALUE_SET_CODE2 VALUE_SET_CODE2,

pay_value_defs_v.VALUE_SET_CODE3 VALUE_SET_CODE3,

pay_value_defs_v.VO_NAME1 VO_NAME1,

pay_value_defs_v.VO_NAME2 VO_NAME2,

pay_value_defs_v.VO_NAME3 VO_NAME3,

pay_value_defs_v.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pay_value_defs_v.CREATED_BY CREATED_BY,

pay_value_defs_v.CREATION_DATE CREATION_DATE,

pay_value_defs_v.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pay_value_defs_v.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pay_value_defs_v.LAST_UPDATED_BY LAST_UPDATED_BY,

pay_value_defs_v.SEED_STATUS SEED_STATUS,

pay_value_defs_v.SGUID SGUID

FROM

pay_value_defs_v

union all

select pay_value_instances.VALUE_DEFN_ID VALUE_DEFN_ID,

pay_value_instances.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

pay_value_instances.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

pay_value_instances.BASE_NAME BASE_NAME,

pay_value_instances.VALUE_GROUP_ID VALUE_GROUP_ID,

pay_value_instances.CALC_TYPE_ID CALC_TYPE_ID,

null DATABASE_ITEM_ID,

null RANGE_DATABASE_ITEM_ID,

null OVERRIDDEN_DB_ITEM_ID,

null BASE_VALUE_DEFN_ID,

pay_value_instances.PARENT_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID,

pay_value_instances.DATE_MODE DATE_MODE,

pay_value_instances.SOURCE_ID SOURCE_ID,

pay_value_instances.SOURCE_TYPE SOURCE_TYPE,

pay_value_instances.DIR_OVERRIDE_USAGE_ID DIR_OVERRIDE_USAGE_ID,

pay_value_instances.ENTERPRISE_ID ENTERPRISE_ID,

pay_value_instances.LEGISLATION_CODE LEGISLATION_CODE,

pay_value_instances.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

null MODULE_ID,

pay_value_instances.CURRENCY_CODE CURRENCY_CODE,

pay_value_instances.UOM UOM,

pay_value_instances.PERIODICITY PERIODICITY,

pay_value_instances.PERIODICITY_TYPE PERIODICITY_TYPE,

null DEFAULT_CALC_TYPE_ID,

null EXPRESSION,

null SEQUENCE,

null DEFAULT_FLAG,

null VALUE_IDENTIFIER,

null GEOGRAPHY_TYPE_ID,

null VALUE_SET_CODE1,

null VALUE_SET_CODE2,

null VALUE_SET_CODE3,

null VO_NAME1,

null VO_NAME2,

null VO_NAME3,

pay_value_instances.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pay_value_instances.CREATED_BY CREATED_BY,

pay_value_instances.CREATION_DATE CREATION_DATE,

pay_value_instances.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pay_value_instances.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pay_value_instances.LAST_UPDATED_BY LAST_UPDATED_BY,

null SEED_STATUS,

null SGUID

from pay_value_instances_v pay_value_instances