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.IGS_FI_GL_PERIODS_V

Object Details

Object Name:	IGS_FI_GL_PERIODS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_FI_GL_PERIODS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		The Row Identifier.
APPLICATION_ID	NUMBER	(15)	Yes	The Application Defining column.
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	No Longer Used
PERIOD_NAME	VARCHAR2	(15)	Yes	The Accounting period name.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column.
CLOSING_STATUS	VARCHAR2	(1)	Yes	The Accounting Period status.
CLOSING_STATUS_MEANING	VARCHAR2	(80)	Yes	The Accounting Period status description.
START_DATE	DATE		Yes	The Date on which the accounting period begins.
END_DATE	DATE		Yes	The Date on which the accounting period ends.
YEAR_START_DATE	DATE		Yes	The Date on which the year containing this accounting period starts.
QUARTER_NUM	NUMBER	(15)	Yes	The Quarter Number.
QUARTER_START_DATE	DATE		Yes	The Date on which the quarter containing this accounting period starts.
PERIOD_TYPE	VARCHAR2	(15)	Yes	The Accounting Period Type.
PERIOD_YEAR	NUMBER	(15)	Yes	The Accounting Period Year.
EFFECTIVE_PERIOD_NUM	NUMBER	(15)	Yes	The Denormalized period number (period_year*10000 + period_num).
PERIOD_NUM	NUMBER	(15)	Yes	The Accounting Period Number.
ADJUSTMENT_PERIOD_FLAG	VARCHAR2	(1)	Yes	The Calendar Adjustment period flag.
CREATION_DATE	DATE			Standard WHO Column.
CREATED_BY	NUMBER	(15)		Standard WHO Column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column.
ELIMINATION_CONFIRMED_FLAG	VARCHAR2	(1)		The Elimination Confirmed flag.
ATTRIBUTE1	VARCHAR2	(150)		The Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		The Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		The Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		The Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		The Descriptive flexfield segment.
CONTEXT	VARCHAR2	(150)		The Descriptive flexfield context.

Query Text

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


SELECT ROW_ID
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CLOSING_STATUS
,      CLOSING_STATUS_MEANING
,      START_DATE
,      END_DATE
,      YEAR_START_DATE
,      QUARTER_NUM
,      QUARTER_START_DATE
,      PERIOD_TYPE
,      PERIOD_YEAR
,      EFFECTIVE_PERIOD_NUM
,      PERIOD_NUM
,      ADJUSTMENT_PERIOD_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ELIMINATION_CONFIRMED_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CONTEXT
FROM APPS.IGS_FI_GL_PERIODS_V;

Dependencies

[top of page]

APPS.IGS_FI_GL_PERIODS_V references the following:

APPS: GL_PERIOD_STATUSES; IGS_LOOKUP_VALUES

APPS.IGS_FI_GL_PERIODS_V is referenced by following:

APPS: IGS_FI_GEN_004 - show dependent code; IGS_FI_GEN_GL - show dependent code; IGS_FI_PRC_SP_FEES - show dependent code; IGS_FI_PRC_STDNT_DPSTS - show dependent code; IGS_FI_PRC_WAIVERS - show dependent code