[Home] [Help] [Dependency Information]
Object Name: | AMW_GL_PERIODS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMW.AMW_GL_PERIODS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Stores Information of General Ledger Periods
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period Name |
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | Period Set Name |
START_DATE | DATE | Yes | Start Date | |
END_DATE | DATE | Yes | End Date | |
PERIOD_TYPE | VARCHAR2 | (15) | Yes | Period Type |
USER_PERIOD_TYPE | VARCHAR2 | (15) | Yes | User Period Type |
PERIOD_YEAR | NUMBER | (15) | Yes | Period Year |
PERIOD_NUM | NUMBER | (15) | Yes | Period Number |
QUARTER_NUM | NUMBER | (15) | Yes | Quarter Number |
ENTERED_PERIOD_NAME | VARCHAR2 | (15) | Yes | Entered Period Name |
ADJUSTMENT_PERIOD_FLAG | VARCHAR2 | (1) | Yes | Adjustment Period Flag |
NUMBER_PER_FISCAL_YEAR | NUMBER | (15) | Yes | Number Per Fiscal Year |
DESCRIPTION | VARCHAR2 | (240) | Description |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_NAME
, PERIOD_SET_NAME
, START_DATE
, END_DATE
, PERIOD_TYPE
, USER_PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, ENTERED_PERIOD_NAME
, ADJUSTMENT_PERIOD_FLAG
, NUMBER_PER_FISCAL_YEAR
, DESCRIPTION
FROM APPS.AMW_GL_PERIODS_V;
|
|
|