[Home] [Help] [Dependency Information]
Object Name: | IGSFV_CAL_PRD_EVNTYP_OFST_CONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_CAL_PRD_EVNTYP_OFST_CONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is the full view for the entity Calendar Per Evnt 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.
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. | |
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 MONTH 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_UPDATED_DATE | DATE | Yes | Standard Who Column. |
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_UPDATED_DATE
FROM APPS.IGSFV_CAL_PRD_EVNTYP_OFST_CONS;
APPS.IGSFV_CAL_PRD_EVNTYP_OFST_CONS is not referenced by any database object
|
|
|