[Home] [Help] [Dependency Information]
Object Name: | IGSFV_CAL_PRD_EVNT_PAIRS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_CAL_PRD_EVNT_PAIRS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is the full view for the entity Calendar Period Event Pairs that stores the pairing of two date alias instances and enables the definition of a period of time inclusive of the two date aliases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATE_ALIAS | VARCHAR2 | (10) | Yes | Name of an event. |
DATE_ALIAS_INST_SEQ_NUM | NUMBER | (6) | Yes | System-generated number that is used to identify the date alias instance which the offset is being defined. |
CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar type of calendar instance which the context date alias instance occurs. |
CAL_INST_SEQ_NUM | NUMBER | (6) | Yes | System-generated number that is used to identify the calendar instance which the date alias instance occurs. |
RELATED_DATE_ALIAS | VARCHAR2 | (10) | Yes | Name of the date alias that is paried with the context date alias instance. The pairing of two date alias instances enables the definition of a period of time inclusive of the two instances. |
RELATE_DATE_ALIAS_INST_SEQ_NUM | NUMBER | (6) | Yes | System-generated number that is used to identify the related date alias instance. |
RELATED_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Name of the calendar type containing the paired or related date alias. |
RELATED_CAL_INST_SEQ_NUM | NUMBER | (6) | Yes | System-generated number that is used to identify the calendar instance which the related date alias instance occurs. |
DATE_ALIAS_INST_ABSOLUTE_VALUE | DATE | The actual date value allocated to an instance of a date alias. | ||
DATE_ALIAS_INST_ALIAS_VALUE | DATE | The Alias value for an instance of the date alias. | ||
DATE_ALIAS_INST_DERIVED_VALUE | DATE | The derived value for an instance of the date alias. | ||
REL_DATE_ALIAS_INST_ABSOLT_VAL | DATE | The actual date value allocated to an instance of a related date alias. | ||
REL_DATE_ALIAS_INST_ALIAS_VAL | DATE | The Alias value for an instance of the related date alias. | ||
REL_DATE_ALIAS_INST_DERVD_VAL | DATE | The Derived value for an instance of the related date alias. | ||
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. |
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
, RELATED_DATE_ALIAS
, RELATE_DATE_ALIAS_INST_SEQ_NUM
, RELATED_CALENDAR_TYPE
, RELATED_CAL_INST_SEQ_NUM
, DATE_ALIAS_INST_ABSOLUTE_VALUE
, DATE_ALIAS_INST_ALIAS_VALUE
, DATE_ALIAS_INST_DERIVED_VALUE
, REL_DATE_ALIAS_INST_ABSOLT_VAL
, REL_DATE_ALIAS_INST_ALIAS_VAL
, REL_DATE_ALIAS_INST_DERVD_VAL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_CAL_PRD_EVNT_PAIRS;
APPS.IGSFV_CAL_PRD_EVNT_PAIRS is not referenced by any database object
|
|
|