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.HRICV_HR_DAY

Object Details

Object Name:	HRICV_HR_DAY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.HRICV_HR_DAY
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

HRICV_HR_DAY

[View Source]

Columns

Name	Datatype	Length	Comments
ID	VARCHAR2	(10)	ID
VALUE	DATE		Value
PERIOD_SET_NAME	CHAR	(6)	Period Set Name
PERIOD_NAME	VARCHAR2	(10)	Period Name
START_DATE	DATE		Start Date
END_DATE	DATE		End Date
PERIOD_NO_IN_YEAR	NUMBER		Period Number in Year
PERIOD_YEAR	DATE		Period Year
ORGANIZATION_ID	VARCHAR2	(0)	comment
ORGANIZATION_TYPE	VARCHAR2	(0)	Organization Type

Query Text

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


SELECT ID
,      VALUE
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      PERIOD_NO_IN_YEAR
,      PERIOD_YEAR
,      ORGANIZATION_ID
,      ORGANIZATION_TYPE
FROM APPS.HRICV_HR_DAY;

Dependencies

[top of page]

APPS.HRICV_HR_DAY references the following:

APPS: FND_NEW_MESSAGES

APPS.HRICV_HR_DAY is referenced by following:

PUBLIC: HRICV_HR_DAY