[Home] [Help] [Dependency Information]
Object Name: | QPR_TIME_ALLHIER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_SR_LEVEL_PK | NUMBER | Identifies the members of the 'All Years' level | ||
ALL_DESC | VARCHAR2 | (4000) | Description of the members in 'All Years' level | |
ALL_YEAR_SPAN | NUMBER | Time span of the members at 'All Years' level | ||
ALL_YEAR_END_DATE | DATE | End date of the members at 'All Years' level | ||
YEAR | VARCHAR2 | (15) | ||
YEAR_END_DATE | DATE | |||
YEAR_SPAN | NUMBER | |||
YEAR_DESCRIPTION | VARCHAR2 | (80) | ||
FISCAL_YEAR | VARCHAR2 | (15) | ||
FISCAL_YEAR_END_DATE | DATE | |||
FISCAL_YEAR_SPAN | NUMBER | |||
FISCAL_YEAR_DESCRIPTION | VARCHAR2 | (80) | ||
QUARTER | VARCHAR2 | (15) | ||
QUARTER_END_DATE | DATE | |||
QUARTER_SPAN | NUMBER | |||
QUARTER_DESCRIPTION | VARCHAR2 | (80) | ||
FISCAL_QUARTER | VARCHAR2 | (15) | ||
FISCAL_QUARTER_END_DATE | DATE | |||
FISCAL_QUARTER_SPAN | NUMBER | |||
FISCAL_QUARTER_DESCRIPTION | VARCHAR2 | (80) | ||
MONTH | VARCHAR2 | (15) | ||
MONTH_END_DATE | DATE | |||
MONTH_SPAN | NUMBER | |||
MONTH_DESCRIPTION | VARCHAR2 | (80) | ||
FISCAL_MONTH | VARCHAR2 | (15) | ||
FISCAL_MONTH_END_DATE | DATE | |||
FISCAL_MONTH_SPAN | NUMBER | |||
FISCAL_MONTH_DESCRIPTION | VARCHAR2 | (80) | ||
WEEK | VARCHAR2 | (80) | ||
WEEK_END_DATE | DATE | |||
WEEK_SPAN | NUMBER | |||
WEEK_DESCRIPTION | VARCHAR2 | (80) | ||
FISCAL_WEEK | VARCHAR2 | (80) | ||
FISCAL_WEEK_END_DATE | DATE | |||
FISCAL_WEEK_SPAN | NUMBER | |||
FISCAL_WEEK_DESCRIPTION | VARCHAR2 | (80) | ||
DAY | DATE | |||
DAY_SPAN | NUMBER | |||
DAY_DESCRIPTION | VARCHAR2 | (80) | ||
INSTANCE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_SR_LEVEL_PK
, ALL_DESC
, ALL_YEAR_SPAN
, ALL_YEAR_END_DATE
, YEAR
, YEAR_END_DATE
, YEAR_SPAN
, YEAR_DESCRIPTION
, FISCAL_YEAR
, FISCAL_YEAR_END_DATE
, FISCAL_YEAR_SPAN
, FISCAL_YEAR_DESCRIPTION
, QUARTER
, QUARTER_END_DATE
, QUARTER_SPAN
, QUARTER_DESCRIPTION
, FISCAL_QUARTER
, FISCAL_QUARTER_END_DATE
, FISCAL_QUARTER_SPAN
, FISCAL_QUARTER_DESCRIPTION
, MONTH
, MONTH_END_DATE
, MONTH_SPAN
, MONTH_DESCRIPTION
, FISCAL_MONTH
, FISCAL_MONTH_END_DATE
, FISCAL_MONTH_SPAN
, FISCAL_MONTH_DESCRIPTION
, WEEK
, WEEK_END_DATE
, WEEK_SPAN
, WEEK_DESCRIPTION
, FISCAL_WEEK
, FISCAL_WEEK_END_DATE
, FISCAL_WEEK_SPAN
, FISCAL_WEEK_DESCRIPTION
, DAY
, DAY_SPAN
, DAY_DESCRIPTION
, INSTANCE_ID
FROM APPS.QPR_TIME_ALLHIER_V;
|
|
|