DBA Data[Home] [Help] [Dependency Information]

VIEW: JTF.JTF_RS_GROUPS_AUD_B#

Object Details
Object Name: JTF_RS_GROUPS_AUD_B#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_AUDIT_ID NUMBER
Yes
GROUP_ID NUMBER
Yes
NEW_GROUP_NUMBER VARCHAR2 (30)
OLD_GROUP_NUMBER VARCHAR2 (30)
NEW_EXCLUSIVE_FLAG VARCHAR2 (1)
OLD_EXCLUSIVE_FLAG VARCHAR2 (1)
NEW_START_DATE_ACTIVE DATE

OLD_START_DATE_ACTIVE DATE

NEW_END_DATE_ACTIVE DATE

OLD_END_DATE_ACTIVE DATE

NEW_ACCOUNTING_CODE VARCHAR2 (80)
OLD_ACCOUNTING_CODE VARCHAR2 (80)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

NEW_EMAIL_ADDRESS VARCHAR2 (240)
OLD_EMAIL_ADDRESS VARCHAR2 (240)
NEW_OBJECT_VERSION_NUMBER NUMBER

OLD_OBJECT_VERSION_NUMBER NUMBER

SECURITY_GROUP_ID NUMBER

NEW_TIME_ZONE NUMBER

OLD_TIME_ZONE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GROUP_AUDIT_ID
,      GROUP_ID
,      NEW_GROUP_NUMBER
,      OLD_GROUP_NUMBER
,      NEW_EXCLUSIVE_FLAG
,      OLD_EXCLUSIVE_FLAG
,      NEW_START_DATE_ACTIVE
,      OLD_START_DATE_ACTIVE
,      NEW_END_DATE_ACTIVE
,      OLD_END_DATE_ACTIVE
,      NEW_ACCOUNTING_CODE
,      OLD_ACCOUNTING_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NEW_EMAIL_ADDRESS
,      OLD_EMAIL_ADDRESS
,      NEW_OBJECT_VERSION_NUMBER
,      OLD_OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      NEW_TIME_ZONE
,      OLD_TIME_ZONE
FROM JTF.JTF_RS_GROUPS_AUD_B#;

Dependencies

[top of page]

JTF.JTF_RS_GROUPS_AUD_B# references the following:

SchemaJTF
TableJTF_RS_GROUPS_AUD_B
JTF.JTF_RS_GROUPS_AUD_B# is referenced by following:

SchemaAPPS
SynonymJTF_RS_GROUPS_AUD_B