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_EVNTYP_OFST_CONS

Object Details

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

View Type

A Business Intelligence System view

This is the base view for the entity Calendar Per Event Type Offset Constraint which describes the set of constraints to be applied when applying an offset to generate a date alias value from another date alias.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	The name of the context date alias instance.
OFFSET_DATE_ALIAS	VARCHAR2	(10)	Yes	Name of the offset date alias instance.
_LA:DATE_ALIAS_OFST_CONS_TYP	CHAR	(86)		The constraint type, in conjunction with a condition, defines the constraint. Constraint types are system-defined.
CONSTRAINT_CONDITION	VARCHAR2	(10)	Yes	The 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 by the context date alias is offset from the related date alias. Values may be positive or negative. It can be 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. It 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. It 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. It can be used in conjunction iwth DAY,WEEK and or MONTH offset values.
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
,      _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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_CAL_PRD_EVNTYP_OFST_CONS;

Dependencies

[top of page]

APPS.IGSBV_CAL_PRD_EVNTYP_OFST_CONS references the following:

APPS: IGS_CA_DA_OFFCNT; IGS_CA_DA_OFST

APPS.IGSBV_CAL_PRD_EVNTYP_OFST_CONS is not referenced by any database object