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

Object Details

Object Name:	GMP_RSRC_CAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMP.GMP_RSRC_CAL_V
Subobject Name:
Status:	VALID

View Type

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

Resource calendar view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAL_ID	NUMBER	(10)	Yes	Calendar ID
CDATE	DATE		Yes	Date in the calendar
SHIFT_NO	NUMBER	(5)	Yes	Shift Number
FTIME	DATE			Start time
TTIME	DATE			End time

Query Text

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


SELECT CAL_ID
,      CDATE
,      SHIFT_NO
,      FTIME
,      TTIME
FROM APPS.GMP_RSRC_CAL_V;

Dependencies

[top of page]

APPS.GMP_RSRC_CAL_V references the following:

APPS: MR_SHCL_DTL; MR_SHDY_DTL; MR_SHDY_HDR

APPS.GMP_RSRC_CAL_V is not referenced by any database object