[Home] [Help] [Dependency Information]
Object Name: | IGSBV_CALENDAR_PERIOD_EVENTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_CALENDAR_PERIOD_EVENTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is the base view for the entity Calendar Period Event that describes an instance of a date alias in a calendar instance.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATE_ALIAS | VARCHAR2 | (10) | Yes | Name of an event. |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | System-generated number that is used to identify the date alias instance. |
CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Type of calendar used within the organization. |
CAL_INST_SEQ_NUM | NUMBER | (6) | Yes | System-generated number that is used to identify the calendar instance, the date alias instance occurs. |
ABSOLUTE_VALUE | DATE | The actual date value allocated to an instance of a date alias. | ||
DERIVED_VALUE | DATE | The derived date value allocated to an instance of a date alias. | ||
ALIAS_VALUE | DATE | The alias date value allocated to an instance of a date alias. | ||
DATE_ALIAS_DESCRIPTION | VARCHAR2 | (60) | Yes | Description of an event. |
START_DATE | DATE | Yes | Start Date when a calendar instance becomes effective. | |
END_DATE | DATE | Yes | End Date when the calendar instance is no longer effective. | |
ALTERNATE_CODE | VARCHAR2 | (10) | Alternate short reference code for identifying a calendar instance. | |
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
, SEQUENCE_NUMBER
, CALENDAR_TYPE
, CAL_INST_SEQ_NUM
, ABSOLUTE_VALUE
, DERIVED_VALUE
, ALIAS_VALUE
, DATE_ALIAS_DESCRIPTION
, START_DATE
, END_DATE
, ALTERNATE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_CALENDAR_PERIOD_EVENTS;
APPS.IGSBV_CALENDAR_PERIOD_EVENTS is not referenced by any database object
|
|
|