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]

TABLE: IGS.IGS_CA_DA_OFFCNT

Object Details

Object Name:	IGS_CA_DA_OFFCNT
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_CA_DA_OFFCNT
Subobject Name:
Status:	VALID

Describes the set of constraints to be applied when applying an offset to generate a date alias value from another date alias.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_CA_DA_OFFCNT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DT_ALIAS OFFSET_DT_ALIAS S_DT_OFFSET_CONSTRAINT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
DT_ALIAS	VARCHAR2	(10)	Yes	The name of the context date alias instance. A date alias is an institution-defined name of an event, not an actual date value.
OFFSET_DT_ALIAS	VARCHAR2	(10)	Yes	Name of the offset date alias instance. A date alias is the name of an event, not an actual date value.
S_DT_OFFSET_CONSTRAINT_TYPE	VARCHAR2	(30)	Yes	The constraint type, in conjunction with a condition, defines the constraint. Constraint types are system-defined. Examples are MONDAY,WEEK DAY and HOLIDAY.
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 resolvingfailed date alias instance offset constraints. Positive or negativevalues can be specified and are used to adjust derived date aliasinstance values when a constraint fails. For example,. an offset constraintspecifies that the derived date must not fall during an institutionalbreak. If it does, the system moves the date forward one day at atime until the derived date does not fall within an institutionalbreak. In this case, the one-day increment is the resolution daysvalue.
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DT_ALIAS
,      OFFSET_DT_ALIAS
,      S_DT_OFFSET_CONSTRAINT_TYPE
,      CONSTRAINT_CONDITION
,      CONSTRAINT_RESOLUTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_CA_DA_OFFCNT;

Dependencies

[top of page]

IGS.IGS_CA_DA_OFFCNT does not reference any database object

IGS.IGS_CA_DA_OFFCNT is referenced by following:

APPS: IGS_CA_DA_OFFCNT