[Home] [Help] [Dependency Information]
Object Name: | XTR_HOLIDAYS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_HOLIDAYS |
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: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_HOLIDAYS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
HOLIDAY_DATE
CURRENCY |
XTR_HOLIDAYS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENCY |
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:
|
|
|