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_CAL_PRD_EVNT_OFSTS

Object Details

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

View Type

A Business Intelligence System view

This is the full view for the entity Calendar Period Event Offset that describes the relationship between two date alias instances.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	Name of the context date alias instance.
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 for the context date alias instance.
CAL_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the calendar instance when the date alias instance occurs.
OFFSET_DATE_ALIAS	VARCHAR2	(10)	Yes	Name of the offset date alias instance date value.
OFFSET_DATE_ALIAS_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the offset date.
OFFSET_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar Type of the calendar instance for the offset date alias instance.
OFFSET_CAL_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the calendar when the offset date alias instance occurs.
NUMBER_OF_DAY_OFFSET	NUMBER	(3)		Number of days for that the context date alias instance is offset from the related date alias instance. Values may be positive or negative. It can be used in conjunction with WEEK, MONTH, and YEAR offset values.
NUMBER_OF_WEEK_OFFSET	NUMBER	(2)		Number of weeks for that the context date alias instance is offset from the related date alias instance. Values may be positive or negative. It can be used in conjunction with DAY, MONTH, and YEAR offset values.
NUMBER_OF_MONTH_OFFSET	NUMBER	(2)		Number of months for that the context date alias instance is offset from the related date alias instance. Values may be positive or negative. It can be used in conjunction with DAY, WEEK, and YEAR offset values.
NUMBER_OF_YEAR_OFFSET	NUMBER	(1)		Number of years for that the context date alias instance is offset from the related date alias instance. Values may be positive or negative. It can be used in conjunction with DAY,WEEK, and MONTH offset values.
OFST_OVERRIDE	VARCHAR2	(1)	Yes	Flag to indicate if the offset relationship is to be overridden.
ABSOLUTE_VALUE	DATE			The actual date value allocated to an instance of a date alias.
DERIVED_VALUE	DATE			The derived date value allocated to an instance of a date alias.
ALIAS_VALUE	DATE			The alias date value allocated to an instance of a date alias.
OFFSET_ABSOLUTE_VALUE	DATE			The offset actual date value allocated to an instance of a date alias.
OFFSET_DERIVED_VALUE	DATE			The offset derived date value allocated to an instance of a date alias.
OFFSET_ALIAS_VALUE	DATE			The offset alias date value allocated to an instance of a 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
,      OFFSET_DATE_ALIAS
,      OFFSET_DATE_ALIAS_INST_SEQ_NUM
,      OFFSET_CALENDAR_TYPE
,      OFFSET_CAL_INST_SEQ_NUM
,      NUMBER_OF_DAY_OFFSET
,      NUMBER_OF_WEEK_OFFSET
,      NUMBER_OF_MONTH_OFFSET
,      NUMBER_OF_YEAR_OFFSET
,      OFST_OVERRIDE
,      ABSOLUTE_VALUE
,      DERIVED_VALUE
,      ALIAS_VALUE
,      OFFSET_ABSOLUTE_VALUE
,      OFFSET_DERIVED_VALUE
,      OFFSET_ALIAS_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CAL_PRD_EVNT_OFSTS;

Dependencies

[top of page]

APPS.IGSFV_CAL_PRD_EVNT_OFSTS references the following:

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

APPS.IGSFV_CAL_PRD_EVNT_OFSTS is not referenced by any database object