PAY_OLD_VALUE_DEFNS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

VALUE_DEFN_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE BASE_NAME NAME BASE_VALUE_DEFN_ID VALUE_GROUP_ID CALC_TYPE_ID DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID PARENT_VALUE_DEFN_ID SOURCE_ID SOURCE_TYPE DIR_OVERRIDE_USAGE_ID ENTERPRISE_ID LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID MODULE_ID CURRENCY_CODE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY VO_NAME1 VO_NAME2 VO_NAME3 DATE_MODE UOM PERIODICITY SEED_STATUS SGUID OVERRIDDEN_DB_ITEM_ID PERIODICITY_TYPE GEOGRAPHY_TYPE_ID

Query

SQL_Statement

SELECT pvd.VALUE_DEFN_ID VALUE_DEFN_ID, pvd.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, pvd.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, pvd.BASE_NAME BASE_NAME, pvdtl.NAME NAME, pvd.BASE_VALUE_DEFN_ID BASE_VALUE_DEFN_ID, pvd.VALUE_GROUP_ID VALUE_GROUP_ID, pvd.CALC_TYPE_ID CALC_TYPE_ID, pvd.DATABASE_ITEM_ID DATABASE_ITEM_ID, pvd.RANGE_DATABASE_ITEM_ID RANGE_DATABASE_ITEM_ID, pvd.PARENT_VALUE_DEFN_ID PARENT_VALUE_DEFN_ID, pvd.SOURCE_ID SOURCE_ID, pvd.SOURCE_TYPE SOURCE_TYPE, pvd.DIR_OVERRIDE_USAGE_ID DIR_OVERRIDE_USAGE_ID, pvd.ENTERPRISE_ID ENTERPRISE_ID, pvd.LEGISLATION_CODE LEGISLATION_CODE, pvd.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pvd.MODULE_ID MODULE_ID, pvd.CURRENCY_CODE CURRENCY_CODE, pvd.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pvd.CREATED_BY CREATED_BY, pvd.CREATION_DATE CREATION_DATE, pvd.LAST_UPDATE_DATE LAST_UPDATE_DATE, pvd.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pvd.LAST_UPDATED_BY LAST_UPDATED_BY, pvd.VO_NAME1 VO_NAME1, pvd.VO_NAME2 VO_NAME2, pvd.VO_NAME3 VO_NAME3, pvd.DATE_MODE, pvd.UOM UOM, pvd.PERIODICITY PERIODICITY, pvd.SEED_STATUS SEED_STATUS, pvd.SGUID SGUID, pvd.OVERRIDDEN_DB_ITEM_ID, pvd.PERIODICITY_TYPE, pvd.GEOGRAPHY_TYPE_ID FROM PAY_OLD_VALUE_DEFNS_F pvd, PAY_OLD_VALUE_DEFNS_TL pvdtl WHERE pvd.VALUE_DEFN_ID = pvdtl.VALUE_DEFN_ID AND pvdtl.LANGUAGE = USERENV('LANG')