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: HR.HR_REPORT_LOOKUPS

Object Details

Object Name:	HR_REPORT_LOOKUPS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.HR_REPORT_LOOKUPS
Subobject Name:
Status:	VALID

HR_REPORT_LOOKUPS stores the Select and Sort Parameters that are
input by the user using the SRS definition screen.
Each row includes an the Report Name, the Report Type i.e. whether
it is a Sort Parameter Code or a Select Parameter Code, the QuickCode.
Each row also contains additional information
such as whether the QuickCode is enabled, and the dates when the
QuickCode becomes active and inactive. This information is used
by Oracle Application Object Library for the SRS screen. The Lookup
Code has a foreign key with fnd_common_lookup(lookup_code). the
meaning of the lookup code is stored here.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_NAME	VARCHAR2	(30)	Yes	Name of report using the lookup
REPORT_LOOKUP_TYPE	VARCHAR2	(30)	Yes	Sort or Select parameter
LOOKUP_CODE	VARCHAR2	(30)	Yes	Foreign key for lookup to use
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates if the lookup enabled
CREATED_BY	NUMBER	(15)	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	(15)	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	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT REPORT_NAME
,      REPORT_LOOKUP_TYPE
,      LOOKUP_CODE
,      ENABLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.HR_REPORT_LOOKUPS;

Dependencies

[top of page]

HR.HR_REPORT_LOOKUPS does not reference any database object

HR.HR_REPORT_LOOKUPS is referenced by following:

APPS: HR_REPORT_LOOKUPS; HR_REPORT_LOOKUPS_WHO
PUBLIC: HR_REPORT_LOOKUPS