eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.GLFV_GL_PERIODS

Object Details

Object Name:	GLFV_GL_PERIODS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GLFV_GL_PERIODS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

General Ledger periods are intervals of time that are grouped together to form the basis for fiscal years and accounting calendars.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNTING_CALENDAR	VARCHAR2	(15)	Yes	Accounting calendar name
PERIOD_NAME	VARCHAR2	(15)	Yes	System generated accounting period name
PERIOD_TYPE	VARCHAR2	(15)	Yes	Accounting period type
PERIOD_NUMBER	NUMBER	(15)	Yes	Accounting period number
QUARTER_NUMBER	NUMBER	(15)	Yes	Quarter number of accounting period
PERIOD_YEAR	NUMBER	(15)	Yes	Accounting period year
PERIOD_START_DATE	DATE		Yes	Date on which accounting period begins
PERIOD_END_DATE	DATE		Yes	Date on which accounting period ends
DESCRIPTION	VARCHAR2	(240)		Accounting period description
_LA:ADJUSTING_PERIOD_FLAG	CHAR	(62)
_DF	CHAR	(30)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCOUNTING_CALENDAR
,      PERIOD_NAME
,      PERIOD_TYPE
,      PERIOD_NUMBER
,      QUARTER_NUMBER
,      PERIOD_YEAR
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      DESCRIPTION
,      _LA:ADJUSTING_PERIOD_FLAG
,      _DF
FROM APPS.GLFV_GL_PERIODS;

Dependencies

[top of page]

APPS.GLFV_GL_PERIODS references the following:

APPS: GL_PERIODS

APPS.GLFV_GL_PERIODS is not referenced by any database object