eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JTF.JTF_RS_GROUPS_AUD_B

Object Details

Object Name:	JTF_RS_GROUPS_AUD_B
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_RS_GROUPS_AUD_B
Subobject Name:
Status:	VALID

Base Table which stores audit information for a Group.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_GROUPS_AUD_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GROUP_AUDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_AUDIT_ID	NUMBER		Yes	Group Audit Identifier (Primary Key)
GROUP_ID	NUMBER		Yes	Resource group unique identifier
NEW_GROUP_NUMBER	VARCHAR2	(30)		New Resource group number
OLD_GROUP_NUMBER	VARCHAR2	(30)		Old Resource group number
NEW_EXCLUSIVE_FLAG	VARCHAR2	(1)		New Exclusive Flag
OLD_EXCLUSIVE_FLAG	VARCHAR2	(1)		Old Exclusive Flag
NEW_START_DATE_ACTIVE	DATE			New Start date for Group
OLD_START_DATE_ACTIVE	DATE			Old Start date for Group
NEW_END_DATE_ACTIVE	DATE			New End date for Group
OLD_END_DATE_ACTIVE	DATE			Old End date for Group
NEW_ACCOUNTING_CODE	VARCHAR2	(80)		New Accounting Code
OLD_ACCOUNTING_CODE	VARCHAR2	(80)		Old Accounting Code
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NEW_EMAIL_ADDRESS	VARCHAR2	(240)		New Email Address
OLD_EMAIL_ADDRESS	VARCHAR2	(240)		Old Email Address
NEW_OBJECT_VERSION_NUMBER	NUMBER			New Object Version Number
OLD_OBJECT_VERSION_NUMBER	NUMBER			Old Object Version Number
SECURITY_GROUP_ID	NUMBER			Column used for Applications Hosting purposes
NEW_TIME_ZONE	NUMBER			New Time Zone for Group
OLD_TIME_ZONE	NUMBER			Old Time Zone for Group

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 does not reference any database object

JTF.JTF_RS_GROUPS_AUD_B is referenced by following:

JTF: JTF_RS_GROUPS_AUD_B#