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_TYPE_OFSTS

Object Details

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

View Type

A Business Intelligence System view

This is the full view for the entity Calendar Period Event Type Offsets that describes the offset relationship between two date aliases. Offset values are used to derive the date alias value from the related date alias value.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	Name of an event.
OFFSET_DATE_ALIAS	VARCHAR2	(10)	Yes	Date alias used to offset from the context date alias. Creation of such offsets enables the system to automatically derive a value for a date alias instance based on its relationship to another date alias.
NUMBER_OF_DAY_OFFSET	NUMBER	(3)		Number of days by the context date alias is offset from the related date alias. Values may be positive or negative and used in conjunction with WEEK, ,MONTH and or YEAR offset values.
NUMBER_OF_WEEK_OFFSET	NUMBER	(2)		Number of weeks by the context date alias is offset from the related date alias. Values may be positive or negative and can be used in conjunction with DAY, MONTH, and or YEAR offset values.
NUMBER_OF_MONTH_OFFSET	NUMBER	(2)		Number of months by the context date alias is offset from the related date alias. Values may be positive or negative and can be used in conjunction with DAY, WEEK, and or YEAR offset values.
NUMBER_OF_YEAR_OFFSET	NUMBER	(1)		Number of years the context date alias is offset from the related date alias. Values may be positive or negative and can be used in conjunction with DAY, WEEK and or MONTH offset values.
DATE_ALIAS_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the date alias.
OFFSET_DATE_ALIAS_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the offset 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
,      OFFSET_DATE_ALIAS
,      NUMBER_OF_DAY_OFFSET
,      NUMBER_OF_WEEK_OFFSET
,      NUMBER_OF_MONTH_OFFSET
,      NUMBER_OF_YEAR_OFFSET
,      DATE_ALIAS_DESCRIPTION
,      OFFSET_DATE_ALIAS_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CAL_PRD_EVNT_TYPE_OFSTS;

Dependencies

[top of page]

APPS.IGSFV_CAL_PRD_EVNT_TYPE_OFSTS references the following:

APPS: IGS_CA_DA; IGS_CA_DA_OFST

APPS.IGSFV_CAL_PRD_EVNT_TYPE_OFSTS is not referenced by any database object