[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_FISCAL_TIME_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_SR_FISCAL_TIME_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the Source View for Fiscal Calendar. This view would be applied to an Oracle Applications 11i instance from which the Fiscal Calendar information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_CODE | VARCHAR2 | (15) | Yes | Calendar Code |
YEAR | VARCHAR2 | (15) | Yes | Year |
YEAR_DESCRIPTION | VARCHAR2 | (15) | Yes | Year Description |
YEAR_START_DATE | DATE | Yes | Year Start Date | |
YEAR_END_DATE | DATE | Yes | Year End Date | |
QUARTER | VARCHAR2 | (15) | Yes | Quarter |
QUARTER_DESCRIPTION | VARCHAR2 | (15) | Yes | Quarter Description |
QUARTER_START_DATE | DATE | Yes | Quarter Start Date | |
QUARTER_END_DATE | DATE | Yes | Quarter End Date | |
MONTH | VARCHAR2 | (15) | Yes | Month |
MONTH_DESCRIPTION | VARCHAR2 | (15) | Yes | Month Description |
MONTH_START_DATE | DATE | Yes | Month Start Date | |
MONTH_END_DATE | DATE | Yes | Month End Date |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_CODE
, YEAR
, YEAR_DESCRIPTION
, YEAR_START_DATE
, YEAR_END_DATE
, QUARTER
, QUARTER_DESCRIPTION
, QUARTER_START_DATE
, QUARTER_END_DATE
, MONTH
, MONTH_DESCRIPTION
, MONTH_START_DATE
, MONTH_END_DATE
FROM APPS.MSD_SR_FISCAL_TIME_V;
APPS.MSD_SR_FISCAL_TIME_V is not referenced by any database object
|
|
|