DBA Data[Home] [Help] [Dependency Information]

TABLE: MTH.MTH_445_PERIOD_CALENDAR

Object Details
Object Name: MTH_445_PERIOD_CALENDAR
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_445_PERIOD_CALENDAR
Subobject Name:
Status: VALID


This table stores 445/544 period calendar


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTH_445_PERIOD_CALENDAR_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIMENSION_KEY
Columns
Name Datatype Length Mandatory Comments
DIMENSION_KEY NUMBER
Yes Hierarchy identifier
DAY_START_DATE DATE

Day start date
DAY_OF_FISCAL_YEAR NUMBER

Day of the fiscal year
JULIAN_DATE NUMBER

Unique julian date identifier
DAY_OF_FISCAL_WEEK NUMBER

Day of the fiscal week
DAY_TIME_SPAN NUMBER

Time span for the day
DAY DATE

Report date
DAY_ID NUMBER

Day identifier
DAY_DAY_CODE NUMBER

Day code
DAY_DESCRIPTION VARCHAR2 (2000)
Description for Day
DAY_NAME VARCHAR2 (25)
Day name
DAY_END_DATE DATE

Day end date
DAY_OF_FISCAL_QUARTER NUMBER

Day of the fiscal quarter
DAY_OF_FISCAL_MONTH NUMBER

Day of the fiscal month
FISCAL_WEEK_START_DATE DATE

Fiscal week start date
FISCAL_WEEK_FIS_WEEK_CODE NUMBER

Fiscal week code
FISCAL_WEEK_DESCRIPTION VARCHAR2 (2000)
Description for fiscal week
WEEK_OF_FISCAL_MONTH NUMBER

Week of the fiscal month
FISCAL_WEEK_TIME_SPAN NUMBER

Time span for the fiscal week
WEEK_OF_FISCAL_YEAR NUMBER

Week of the fiscal year
FIS_WEEK_NUMBER NUMBER

Fiscal week number
FISCAL_WEEK_END_DATE DATE

Fiscal week end date
FISCAL_WEEK_ID NUMBER

Fiscal week identifier
FISCAL_WEEK_NAME VARCHAR2 (25)
Fiscal week name
WEEK_OF_FISCAL_QUARTER NUMBER

Week of the fiscal quarter
FISCAL_MONTH_START_DATE DATE

Fiscal month start date
FISCAL_MONTH_FIS_MONTH_CODE NUMBER

Fiscal month code
FISCAL_MONTH_DESCRIPTION VARCHAR2 (2000)
Description of the fiscal month
MONTH_OF_FISCAL_QUARTER NUMBER

Month of the fiscal quarter
FISCAL_MONTH_END_DATE DATE

Fiscal month end date
FISCAL_MONTH_ID NUMBER

Fiscal month identifier
FISCAL_MONTH_NAME VARCHAR2 (25)
Fiscal month name
FIS_MONTH_NUMBER NUMBER

Fiscal month number
FISCAL_MONTH_TIME_SPAN NUMBER

Time span for the fiscal month
MONTH_OF_FISCAL_YEAR NUMBER

Month of the fiscal year
FISCAL_QUARTER_TIME_SPAN NUMBER

Time span for the fiscal quarter
QUARTER_OF_FISCAL_YEAR NUMBER

Quarter of the fiscal year
FISCAL_QUARTER_FIS_QUARTER_CO NUMBER

Fiscal quarter code
FIS_QUARTER_NUMBER NUMBER

Fiscal quarter number
FISCAL_QUARTER_NAME VARCHAR2 (25)
Fiscal quarter number
FISCAL_QUARTER_END_DATE DATE

Fiscal quarter name
FISCAL_QUARTER_ID NUMBER

Fiscal quarter identifier
FISCAL_QUARTER_DESCRIPTION VARCHAR2 (2000)
Description for fiscal quarter
FISCAL_QUARTER_START_DATE DATE

Fiscal quarter start date
FISCAL_YEAR_ID NUMBER

Fiscal year identifier
FISCAL_YEAR_NAME VARCHAR2 (25)
Fiscal year name
FIS_YEAR_NUMBER NUMBER

Fiscal year number
FISCAL_YEAR_START_DATE DATE

Fiscal year start date
FISCAL_YEAR_TIME_SPAN NUMBER

Time span for the fiscal year
FISCAL_YEAR_FIS_YEAR_CODE NUMBER

Fiscal year code
FISCAL_YEAR_DESCRIPTION VARCHAR2 (2000)
Description for fiscal year
FISCAL_YEAR_END_DATE DATE

Fiscal year end date
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DIMENSION_KEY
,      DAY_START_DATE
,      DAY_OF_FISCAL_YEAR
,      JULIAN_DATE
,      DAY_OF_FISCAL_WEEK
,      DAY_TIME_SPAN
,      DAY
,      DAY_ID
,      DAY_DAY_CODE
,      DAY_DESCRIPTION
,      DAY_NAME
,      DAY_END_DATE
,      DAY_OF_FISCAL_QUARTER
,      DAY_OF_FISCAL_MONTH
,      FISCAL_WEEK_START_DATE
,      FISCAL_WEEK_FIS_WEEK_CODE
,      FISCAL_WEEK_DESCRIPTION
,      WEEK_OF_FISCAL_MONTH
,      FISCAL_WEEK_TIME_SPAN
,      WEEK_OF_FISCAL_YEAR
,      FIS_WEEK_NUMBER
,      FISCAL_WEEK_END_DATE
,      FISCAL_WEEK_ID
,      FISCAL_WEEK_NAME
,      WEEK_OF_FISCAL_QUARTER
,      FISCAL_MONTH_START_DATE
,      FISCAL_MONTH_FIS_MONTH_CODE
,      FISCAL_MONTH_DESCRIPTION
,      MONTH_OF_FISCAL_QUARTER
,      FISCAL_MONTH_END_DATE
,      FISCAL_MONTH_ID
,      FISCAL_MONTH_NAME
,      FIS_MONTH_NUMBER
,      FISCAL_MONTH_TIME_SPAN
,      MONTH_OF_FISCAL_YEAR
,      FISCAL_QUARTER_TIME_SPAN
,      QUARTER_OF_FISCAL_YEAR
,      FISCAL_QUARTER_FIS_QUARTER_CO
,      FIS_QUARTER_NUMBER
,      FISCAL_QUARTER_NAME
,      FISCAL_QUARTER_END_DATE
,      FISCAL_QUARTER_ID
,      FISCAL_QUARTER_DESCRIPTION
,      FISCAL_QUARTER_START_DATE
,      FISCAL_YEAR_ID
,      FISCAL_YEAR_NAME
,      FIS_YEAR_NUMBER
,      FISCAL_YEAR_START_DATE
,      FISCAL_YEAR_TIME_SPAN
,      FISCAL_YEAR_FIS_YEAR_CODE
,      FISCAL_YEAR_DESCRIPTION
,      FISCAL_YEAR_END_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM MTH.MTH_445_PERIOD_CALENDAR;

Dependencies

[top of page]

MTH.MTH_445_PERIOD_CALENDAR does not reference any database object

MTH.MTH_445_PERIOD_CALENDAR is referenced by following:

SchemaAPPS
SynonymMTH_445_PERIOD_CALENDAR