VIEW: JTF.JTF_RS_GRP_RELATE_AUD#

Source

View Text - Preformatted

select GROUP_RELATE_AUDIT_ID GROUP_RELATE_AUDIT_ID, GROUP_RELATE_ID GROUP_RELATE_ID, NEW_GROUP_ID NEW_GROUP_ID, OLD_GROUP_ID OLD_GROUP_ID, NEW_RELATED_GROUP_ID NEW_RELATED_GROUP_ID, OLD_RELATED_GROUP_ID OLD_RELATED_GROUP_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, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER, 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_RELATION_TYPE NEW_RELATION_TYPE, OLD_RELATION_TYPE OLD_RELATION_TYPE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "JTF"."JTF_RS_GRP_RELATE_AUD"

View Text - HTML Formatted

SELECT GROUP_RELATE_AUDIT_ID GROUP_RELATE_AUDIT_ID
, GROUP_RELATE_ID GROUP_RELATE_ID
, NEW_GROUP_ID NEW_GROUP_ID
, OLD_GROUP_ID OLD_GROUP_ID
, NEW_RELATED_GROUP_ID NEW_RELATED_GROUP_ID
, OLD_RELATED_GROUP_ID OLD_RELATED_GROUP_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
, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER
, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER
, 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_RELATION_TYPE NEW_RELATION_TYPE
, OLD_RELATION_TYPE OLD_RELATION_TYPE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "JTF"."JTF_RS_GRP_RELATE_AUD"