DBA Data[Home] [Help]

VIEW: JTF.JTF_RS_GROUPS_AUD_B#

Source

View Text - Preformatted

select GROUP_AUDIT_ID GROUP_AUDIT_ID, GROUP_ID GROUP_ID, NEW_GROUP_NUMBER NEW_GROUP_NUMBER, OLD_GROUP_NUMBER OLD_GROUP_NUMBER, NEW_EXCLUSIVE_FLAG NEW_EXCLUSIVE_FLAG, OLD_EXCLUSIVE_FLAG OLD_EXCLUSIVE_FLAG, 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_ACCOUNTING_CODE NEW_ACCOUNTING_CODE, OLD_ACCOUNTING_CODE OLD_ACCOUNTING_CODE, 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_EMAIL_ADDRESS NEW_EMAIL_ADDRESS, OLD_EMAIL_ADDRESS OLD_EMAIL_ADDRESS, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, NEW_TIME_ZONE NEW_TIME_ZONE, OLD_TIME_ZONE OLD_TIME_ZONE from "JTF"."JTF_RS_GROUPS_AUD_B"
View Text - HTML Formatted

SELECT GROUP_AUDIT_ID GROUP_AUDIT_ID
, GROUP_ID GROUP_ID
, NEW_GROUP_NUMBER NEW_GROUP_NUMBER
, OLD_GROUP_NUMBER OLD_GROUP_NUMBER
, NEW_EXCLUSIVE_FLAG NEW_EXCLUSIVE_FLAG
, OLD_EXCLUSIVE_FLAG OLD_EXCLUSIVE_FLAG
, 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_ACCOUNTING_CODE NEW_ACCOUNTING_CODE
, OLD_ACCOUNTING_CODE OLD_ACCOUNTING_CODE
, 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_EMAIL_ADDRESS NEW_EMAIL_ADDRESS
, OLD_EMAIL_ADDRESS OLD_EMAIL_ADDRESS
, NEW_OBJECT_VERSION_NUMBER NEW_OBJECT_VERSION_NUMBER
, OLD_OBJECT_VERSION_NUMBER OLD_OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, NEW_TIME_ZONE NEW_TIME_ZONE
, OLD_TIME_ZONE OLD_TIME_ZONE
FROM "JTF"."JTF_RS_GROUPS_AUD_B"