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

Object Details

Object Name:	FAFV_ACCT_PRDS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FAFV_ACCT_PRDS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows information about each accounting period.

[View Source]

Columns

Name	Datatype	Length	Mandatory
PERIOD_NAME	VARCHAR2	(15)	Yes
PERIOD_COUNTER	NUMBER	(15)	Yes
FISCAL_YEAR	NUMBER	(4)	Yes
PERIOD_NUMBER	NUMBER	(3)	Yes
PERIOD_OPEN_DATE	DATE		Yes
PERIOD_CLOSE_DATE	DATE
CALENDAR_PERIOD_OPEN_DATE	DATE
CALENDAR_PERIOD_CLOSE_DATE	DATE
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes

Query Text

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


SELECT PERIOD_NAME
,      PERIOD_COUNTER
,      FISCAL_YEAR
,      PERIOD_NUMBER
,      PERIOD_OPEN_DATE
,      PERIOD_CLOSE_DATE
,      CALENDAR_PERIOD_OPEN_DATE
,      CALENDAR_PERIOD_CLOSE_DATE
,      BOOK_TYPE_CODE
FROM APPS.FAFV_ACCT_PRDS;

Dependencies

[top of page]

APPS.FAFV_ACCT_PRDS references the following:

APPS: FA_DEPRN_PERIODS

APPS.FAFV_ACCT_PRDS is not referenced by any database object