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

VIEW: APPS.GLBV_GL_PERIODS

Object Details
Object Name: GLBV_GL_PERIODS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GLBV_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)
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
FROM APPS.GLBV_GL_PERIODS;

Dependencies

[top of page]

APPS.GLBV_GL_PERIODS references the following:

SchemaAPPS
SynonymGL_PERIODS

APPS.GLBV_GL_PERIODS is not referenced by any database object