DBA Data[Home] [Help]

VIEW: JTF.JTF_RS_RESOURCE_DENORM#

Source

View Text - Preformatted

select DENORM_RESOURCE_ID DENORM_RESOURCE_ID, RESOURCE_ID RESOURCE_ID, CATEGORY CATEGORY, PARENT_RESOURCE_ID PARENT_RESOURCE_ID, LEVEL_FROM_ROOT LEVEL_FROM_ROOT, TOTAL_COUNT TOTAL_COUNT, DIRECTS_COUNT DIRECTS_COUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID from "JTF"."JTF_RS_RESOURCE_DENORM"
View Text - HTML Formatted

SELECT DENORM_RESOURCE_ID DENORM_RESOURCE_ID
, RESOURCE_ID RESOURCE_ID
, CATEGORY CATEGORY
, PARENT_RESOURCE_ID PARENT_RESOURCE_ID
, LEVEL_FROM_ROOT LEVEL_FROM_ROOT
, TOTAL_COUNT TOTAL_COUNT
, DIRECTS_COUNT DIRECTS_COUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "JTF"."JTF_RS_RESOURCE_DENORM"