[Home] [Help]
[Dependency Information]
Object Name: | XTR_HOLIDAYS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
XTR_HOLIDAYS contains the holiday information for currencies. Each row corresponds to a holiday date for a currency. A currency can have many holiday dates.
This table corresponds to the Currency Holiday Dates window.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_HOLIDAYS_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
XTR_HOLIDAYS_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMMENTS | VARCHAR2 | (80) | Holiday description | |
CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
DAY_DESC | DATE | Day of the holiday | ||
HOLIDAY_DATE | DATE | Yes | Date of the holiday | |
HOL_SEQ | NUMBER | Yes | Holiday rule identifier (used to determine which dates corresponds to which rule) |
Cut, paste (and edit) the following text to query this object:
SELECT COMMENTS
, CURRENCY
, DAY_DESC
, HOLIDAY_DATE
, HOL_SEQ
FROM XTR.XTR_HOLIDAYS;
XTR.XTR_HOLIDAYS does not reference any database object
XTR.XTR_HOLIDAYS is referenced by following:
|
|
|