VIEW: JTF.JTF_RS_ROLE_RELATE_AUD#

Source

View Text - Preformatted

select ROLE_RELATE_AUDIT_ID ROLE_RELATE_AUDIT_ID, ROLE_RELATE_ID ROLE_RELATE_ID, NEW_ROLE_ID NEW_ROLE_ID, OLD_ROLE_ID OLD_ROLE_ID, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE, 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, NEW_ROLE_RESOURCE_TYPE NEW_ROLE_RESOURCE_TYPE, OLD_ROLE_RESOURCE_TYPE OLD_ROLE_RESOURCE_TYPE, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER, NEW_ROLE_RESOURCE_ID NEW_ROLE_RESOURCE_ID, OLD_ROLE_RESOURCE_ID OLD_ROLE_RESOURCE_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "JTF"."JTF_RS_ROLE_RELATE_AUD"

View Text - HTML Formatted

SELECT ROLE_RELATE_AUDIT_ID ROLE_RELATE_AUDIT_ID
, ROLE_RELATE_ID ROLE_RELATE_ID
, NEW_ROLE_ID NEW_ROLE_ID
, OLD_ROLE_ID OLD_ROLE_ID
, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE
, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE
, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE
, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE
, 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
, NEW_ROLE_RESOURCE_TYPE NEW_ROLE_RESOURCE_TYPE
, OLD_ROLE_RESOURCE_TYPE OLD_ROLE_RESOURCE_TYPE
, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER
, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER
, NEW_ROLE_RESOURCE_ID NEW_ROLE_RESOURCE_ID
, OLD_ROLE_RESOURCE_ID OLD_ROLE_RESOURCE_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "JTF"."JTF_RS_ROLE_RELATE_AUD"