DBA Data[Home] [Help]

VIEW: HR.HR_S_USER_TABLES#

Source

View Text - Preformatted

select USER_TABLE_ID USER_TABLE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, RANGE_OR_MATCH RANGE_OR_MATCH, USER_KEY_UNITS USER_KEY_UNITS, USER_TABLE_NAME USER_TABLE_NAME, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP, USER_ROW_TITLE USER_ROW_TITLE, 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_USER_TABLES"
View Text - HTML Formatted

SELECT USER_TABLE_ID USER_TABLE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, RANGE_OR_MATCH RANGE_OR_MATCH
, USER_KEY_UNITS USER_KEY_UNITS
, USER_TABLE_NAME USER_TABLE_NAME
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
, USER_ROW_TITLE USER_ROW_TITLE
, 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_USER_TABLES"