[Home] [Help] [Dependency Information]
Object Name: | PA_ADW_PERIODS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_ADW_PERIODS_V |
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 |
---|---|---|---|---|
PA_PERIOD_KEY | VARCHAR2 | (56) | ||
PA_PERIOD | VARCHAR2 | (15) | Yes | |
PA_PERIOD_START_DATE | DATE | Yes | ||
PA_PERIOD_END_DATE | DATE | Yes | ||
GL_PERIOD | VARCHAR2 | (15) | Yes | |
GL_PERIOD_START_DATE | DATE | Yes | ||
GL_PERIOD_END_DATE | DATE | Yes | ||
FINANCIAL_QUARTER | VARCHAR2 | (82) | ||
FINANCIAL_YEAR | NUMBER | (15) | Yes | |
ALL_FINANCIAL_YEARS | VARCHAR2 | (80) | Yes | |
USER_COL1 | VARCHAR2 | (0) | ||
USER_COL2 | VARCHAR2 | (0) | ||
USER_COL3 | VARCHAR2 | (0) | ||
USER_COL4 | VARCHAR2 | (0) | ||
USER_COL5 | VARCHAR2 | (0) | ||
USER_COL6 | VARCHAR2 | (0) | ||
USER_COL7 | VARCHAR2 | (0) | ||
USER_COL8 | VARCHAR2 | (0) | ||
USER_COL9 | VARCHAR2 | (0) | ||
USER_COL10 | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT PA_PERIOD_KEY
, PA_PERIOD
, PA_PERIOD_START_DATE
, PA_PERIOD_END_DATE
, GL_PERIOD
, GL_PERIOD_START_DATE
, GL_PERIOD_END_DATE
, FINANCIAL_QUARTER
, FINANCIAL_YEAR
, ALL_FINANCIAL_YEARS
, USER_COL1
, USER_COL2
, USER_COL3
, USER_COL4
, USER_COL5
, USER_COL6
, USER_COL7
, USER_COL8
, USER_COL9
, USER_COL10
FROM APPS.PA_ADW_PERIODS_V;
|
|
|