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_PAIRS

Object Details

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

View Type

A Business Intelligence System view

This is the base view for the entity Calendar Period Event Pairs that stores the pairing of two date alias instances and enables the definition of a period of time inclusive of the two date aliases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	Name of an event.
DATE_ALIAS_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the date alias instance which the offset is being defined.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar type of the calendar instance which the context date alias instance occurs.
CAL_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the calendar instance which the date alias instance occurs.
RELATED_DATE_ALIAS	VARCHAR2	(10)	Yes	Name of the date alias that is paired with the context date alias instance. The pairing of two date alias instances enables the definition of a period of time inclusive of the two instances.
RELATE_DATE_ALIAS_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the related date alias instance.
RELATED_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Name of the calendar type containing the paired or related date alias.
RELATED_CAL_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the calendar instance which the related date alias instance occurs.
DATE_ALIAS_INST_ABSOLUTE_VALUE	DATE			The actual date value allocated to an instance of a date alias.
DATE_ALIAS_INST_ALIAS_VALUE	DATE			The Alias value for an instance of the date alias.
DATE_ALIAS_INST_DERIVED_VALUE	DATE			The derived value for an instance of the date alias.
REL_DATE_ALIAS_INST_ABSOLT_VAL	DATE			The actual date value allocated to an instance of a related date alias.
REL_DATE_ALIAS_INST_ALIAS_VAL	DATE			The Alias value for an instance of the related date alias.
REL_DATE_ALIAS_INST_DERVD_VAL	DATE			The Derived value for an instance of the related date alias.
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
,      DATE_ALIAS_INST_SEQ_NUM
,      CALENDAR_TYPE
,      CAL_INST_SEQ_NUM
,      RELATED_DATE_ALIAS
,      RELATE_DATE_ALIAS_INST_SEQ_NUM
,      RELATED_CALENDAR_TYPE
,      RELATED_CAL_INST_SEQ_NUM
,      DATE_ALIAS_INST_ABSOLUTE_VALUE
,      DATE_ALIAS_INST_ALIAS_VALUE
,      DATE_ALIAS_INST_DERIVED_VALUE
,      REL_DATE_ALIAS_INST_ABSOLT_VAL
,      REL_DATE_ALIAS_INST_ALIAS_VAL
,      REL_DATE_ALIAS_INST_DERVD_VAL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_CAL_PRD_EVNT_PAIRS;

Dependencies

[top of page]

APPS.IGSBV_CAL_PRD_EVNT_PAIRS references the following:

APPS: IGS_CA_DA_INST; IGS_CA_DA_INST_PAIR; IGS_CA_GEN_001 - show dependent code; IGS_CA_GEN_002 - show dependent code

APPS.IGSBV_CAL_PRD_EVNT_PAIRS is not referenced by any database object