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]

VIEW: APPS.JTF_RS_GROUPS_AUD_VL

Object Details

Object Name:	JTF_RS_GROUPS_AUD_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_RS_GROUPS_AUD_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

MLS View forJTF_RS_GROUPS_AUD_B andJTF_RS_GROUPS_AUD_TL.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Rowid for original row from jtf_rs_group_aud_b table
GROUP_AUDIT_ID	NUMBER		Yes	Group Audit Identifier(PK)
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_EMAIL_ADDRESS	VARCHAR2	(240)		New Email Address
OLD_EMAIL_ADDRESS	VARCHAR2	(240)		Old Email Address
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
NEW_OBJECT_VERSION_NUMBER	NUMBER			New Object Version Number
OLD_OBJECT_VERSION_NUMBER	NUMBER			Old Object Version Number
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_GROUP_NAME	VARCHAR2	(60)		New Group Name
OLD_GROUP_NAME	VARCHAR2	(60)		Old Group Name
NEW_GROUP_DESC	VARCHAR2	(240)		New Group Description
OLD_GROUP_DESC	VARCHAR2	(240)		Old Group Description
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 ROW_ID
,      GROUP_AUDIT_ID
,      GROUP_ID
,      NEW_GROUP_NUMBER
,      OLD_GROUP_NUMBER
,      NEW_EMAIL_ADDRESS
,      OLD_EMAIL_ADDRESS
,      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
,      NEW_OBJECT_VERSION_NUMBER
,      OLD_OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NEW_GROUP_NAME
,      OLD_GROUP_NAME
,      NEW_GROUP_DESC
,      OLD_GROUP_DESC
,      NEW_TIME_ZONE
,      OLD_TIME_ZONE
FROM APPS.JTF_RS_GROUPS_AUD_VL;

Dependencies

[top of page]

APPS.JTF_RS_GROUPS_AUD_VL references the following:

APPS: JTF_RS_GROUPS_AUD_B; JTF_RS_GROUPS_AUD_TL

APPS.JTF_RS_GROUPS_AUD_VL is not referenced by any database object