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

Object Details

Object Name:	IGSFV_CALENDAR_PERIODS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_CALENDAR_PERIODS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This is the full view for the entity Calendar Periods that describes an instance of a calendar type.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Name of a type of calendar used within the organization.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the calendar instance.
START_DATE	DATE		Yes	Start Date when the calendar instance becomes effective.
END_DATE	DATE		Yes	End Date when the calendar instance is no longer effective.
CALENDAR_STATUS	VARCHAR2	(10)	Yes	Status of the calendar instance, that indicates the level of activity of the calendar.
ALTERNATE_CODE	VARCHAR2	(10)		Alternate short reference code for identifying a calendar instance. Alternate codes are mandatory for academic, admission progression, and teaching calendars.
SELF_SERVICE_DISPLAYED	VARCHAR2	(1)		Indicates whether the load calendar is displayed to self-service users.
IVR_ENABLED	VARCHAR2	(1)		To indicate if the calendar is to be listed in IVR
SUPERIOR_CAL_STAT_DIFF_INDICAT	VARCHAR2	(1)	Yes	System-set indicator that specifies if the status of a calendar instance differs from the status of any of its superior calendar instances.
DESCRIPTION	VARCHAR2	(30)		Description for the Calendar Instance.
PRIOR_CAL_INST_SEQ_NUM	NUMBER	(6)		Unique identifier for a prior calendar instance. Set when calendar instance is the result of a rolled over calendar.
PRIOR_ALTERNATE_CODE	VARCHAR2	(10)		Alternate short reference code for identifying a calendar instance.
PRIOR_START_DATE	DATE			Start Date when the prior calendar instance becomes effective.
PRIOR_END_DATE	DATE			End Date when the prior calendar instance becomes no longer effective.
CALENDAR_DESCRIPTION	VARCHAR2	(60)	Yes	Description of a calendar type used within the institution.
CALENDAR_STATUS_DESCRIPTION	VARCHAR2	(60)	Yes	Description of a calendar status assigned to a calendar.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column.
CREATION_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.

Query Text

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


SELECT CALENDAR_TYPE
,      SEQUENCE_NUMBER
,      START_DATE
,      END_DATE
,      CALENDAR_STATUS
,      ALTERNATE_CODE
,      SELF_SERVICE_DISPLAYED
,      IVR_ENABLED
,      SUPERIOR_CAL_STAT_DIFF_INDICAT
,      DESCRIPTION
,      PRIOR_CAL_INST_SEQ_NUM
,      PRIOR_ALTERNATE_CODE
,      PRIOR_START_DATE
,      PRIOR_END_DATE
,      CALENDAR_DESCRIPTION
,      CALENDAR_STATUS_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CALENDAR_PERIODS;

Dependencies

[top of page]

APPS.IGSFV_CALENDAR_PERIODS references the following:

APPS: IGS_CA_INST_ALL; IGS_CA_STAT; IGS_CA_TYPE

APPS.IGSFV_CALENDAR_PERIODS is not referenced by any database object