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_OFST

Object Details

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

IGS_CA_DA_OFST describes the relationship between one date alias and another. It holds offset
values which can be used to derive the date alias value from the related date alias value.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_CA_DA_OFST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DT_ALIAS OFFSET_DT_ALIAS
IGS_CA_DA_OFST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFSET_DT_ALIAS

Columns

Name	Datatype	Length	Mandatory	Comments
DT_ALIAS	VARCHAR2	(10)	Yes	Name of an event, not an actual date value. Each date alias is assigned a date alias category and may be assigned a calendar category.
OFFSET_DT_ALIAS	VARCHAR2	(10)	Yes	Date alias against that the context date alias is offset. 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.
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 or YEAR offset values. For example, date alias instance A may be offset from date alias instance B by 3 weeks and 2 days.
WEEK_OFFSET	NUMBER	(2)		Number of weeks by that 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 or YEAR offset values. For example, date alias instance A may be offset from date alias instance B by 3 weeks and 2 days.
MONTH_OFFSET	NUMBER	(2)		Number of months by that 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 or YEAR offset values. For example, date alias instance A may be offset from date alias instance B by 6 months and 1 week.
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 with DAY, WEEK and or or MONTH offset values. For example, date alias instance A may be offset from date alias instance B by 1 year and 2 weeks.
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
,      DAY_OFFSET
,      WEEK_OFFSET
,      MONTH_OFFSET
,      YEAR_OFFSET
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_CA_DA_OFST;

Dependencies

[top of page]

IGS.IGS_CA_DA_OFST does not reference any database object

IGS.IGS_CA_DA_OFST is referenced by following:

APPS: IGS_CA_DA_OFST