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

Object Details

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

View Type

A Business Intelligence System view

This is the base view for the entity Calendar Period Event Type Pairs which describes combination of date aliases into pairs.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	Name of an event.
RELATED_DATE_ALIAS	VARCHAR2	(10)	Yes	Name of the date alias that is paired with the context date alias. The pairing of two date aliases enables the definition of a period of time inclusive of the two date aliases.
DATE_ALIAS_DESCRIPTION	VARCHAR2	(60)	Yes	Description of date.
RELATED_DATE_ALIAS_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the related date.
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 DATE_ALIAS
,      RELATED_DATE_ALIAS
,      DATE_ALIAS_DESCRIPTION
,      RELATED_DATE_ALIAS_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_CAL_PRD_EVNT_TYPE_PAIRS;

Dependencies

[top of page]

APPS.IGSBV_CAL_PRD_EVNT_TYPE_PAIRS references the following:

APPS: IGS_CA_DA; IGS_CA_DA_PAIR

APPS.IGSBV_CAL_PRD_EVNT_TYPE_PAIRS is not referenced by any database object