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_OFST_CONS

Object Details

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

View Type

A Business Intelligence System view

This is the full view for the entity Calendar Period Event Offset Constraint whch describes the set of constraints to be applied when applying an offset to generate a date alias instance value from another date alias instance.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	Name of the context date alias.
DATE_ALIAS_INST_SEQ_NUM	NUMBER	(6)	Yes	A system-generated number that is used to identify the date alias instance.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar Type is the Institution-defined name of a type of calendar used within the organization.
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.
OFFSET_DATE_ALIAS_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the offset date alias instance.
OFFSET_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar Type of the calendar instance when the offset date alias instance occurs.
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.
_LA:DATE_ALIAS_OFST_CONS_TYP	CHAR	(86)		The constraint type, in conjunction with a condition, defines the constraint.
CONSTRAINT_CONDITION	VARCHAR2	(10)	Yes	Operator, which acts on the constraint type. The available conditions are MUST and MUST NOT.
CONSTRAINT_RESOLUTION	NUMBER	(1)	Yes	The Offset value in number of days, for the purpose of resolving failed date alias instance offset constraints. Positive or negative values can be specified and are used to adjust derived date alias instance values when a constraint fails.
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.
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
,      _LA:DATE_ALIAS_OFST_CONS_TYP
,      CONSTRAINT_CONDITION
,      CONSTRAINT_RESOLUTION
,      NUMBER_OF_DAY_OFFSET
,      NUMBER_OF_WEEK_OFFSET
,      NUMBER_OF_MONTH_OFFSET
,      NUMBER_OF_YEAR_OFFSET
,      OFST_OVERRIDE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CAL_PRD_EVNT_OFST_CONS;

Dependencies

[top of page]

APPS.IGSFV_CAL_PRD_EVNT_OFST_CONS references the following:

APPS: IGS_CA_DA_INST_OFCNT; IGS_CA_DA_INST_OFST

APPS.IGSFV_CAL_PRD_EVNT_OFST_CONS is not referenced by any database object