[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_FISCAL_TIME_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Fiscal calendar time view
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 | Start date | |
YEAR_END_DATE | DATE | Yes | 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.QPR_SR_FISCAL_TIME_V;
APPS.QPR_SR_FISCAL_TIME_V is not referenced by any database object
|
|
|