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

Object Details

Object Name:	FV_FACTS1_PERIOD_BALANCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_FACTS1_PERIOD_BALANCES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains records for FACTS I reporting.

[View Source]

Columns

Name	Datatype	Length	Comments
CCID	NUMBER	(15)	Code combination identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Set of books identifier
PERIOD_YEAR	NUMBER	(15)	Period year
PERIOD_NUM	NUMBER	(15)	Period number
PERIOD_NAME	VARCHAR2	(15)	Period name
FUND_GROUP	NUMBER	(4)	Fund group of the fund
ACCOUNT_NUMBER	VARCHAR2	(30)	Account number
FUND_VALUE	VARCHAR2	(30)	Balancing segment value
DEPT_ID	VARCHAR2	(3)	Department identifier
BUREAU_ID	VARCHAR2	(2)	Bureau identifier
ELIMINATIONS_DEPT	VARCHAR2	(7)	Eliminations department
G_NG_INDICATOR	VARCHAR2	(1)	Govt Non-Govt indicator
END_BAL_IND	VARCHAR2	(1)	Ending balance indicator
REPORTED_STATUS	CHAR	(1)	Reported status
USSGL_ACCOUNT	VARCHAR2	(4)	USSGL account number
EXCH_NON_EXCH	VARCHAR2	(1)	Exchange or Non-Exchange
CUST_NON_CUST	VARCHAR2	(1)	Custodial or non-custodial
BUDGET_SUBFUNCTION	VARCHAR2	(3)	Budget sub-function
ACCOUNT_TYPE	VARCHAR2	(1)	Account type
AMOUNT	NUMBER		Transaction amount
BEGINNING_BALANCE	NUMBER		Beginning balance amount
PERIOD_DR	NUMBER		Period debit amount
PERIOD_CR	NUMBER		Period credit amount
PERIOD_BEGIN_BAL	NUMBER		Beginning balance for the period
D_C_INDICATOR	VARCHAR2	(1)	Debit or Credit indicator
BALANCE_TYPE	VARCHAR2	(1)	Balance type
RECIPIENT_NAME	VARCHAR2	(360)	Recipient name

Query Text

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


SELECT CCID
,      SET_OF_BOOKS_ID
,      PERIOD_YEAR
,      PERIOD_NUM
,      PERIOD_NAME
,      FUND_GROUP
,      ACCOUNT_NUMBER
,      FUND_VALUE
,      DEPT_ID
,      BUREAU_ID
,      ELIMINATIONS_DEPT
,      G_NG_INDICATOR
,      END_BAL_IND
,      REPORTED_STATUS
,      USSGL_ACCOUNT
,      EXCH_NON_EXCH
,      CUST_NON_CUST
,      BUDGET_SUBFUNCTION
,      ACCOUNT_TYPE
,      AMOUNT
,      BEGINNING_BALANCE
,      PERIOD_DR
,      PERIOD_CR
,      PERIOD_BEGIN_BAL
,      D_C_INDICATOR
,      BALANCE_TYPE
,      RECIPIENT_NAME
FROM APPS.FV_FACTS1_PERIOD_BALANCES_V;

Dependencies

[top of page]

APPS.FV_FACTS1_PERIOD_BALANCES_V references the following:

APPS: FV_FACTS1_DIFF_BALANCES; FV_FACTS1_LINE_BALANCES; FV_FACTS1_PERIOD_ATTRIBUTES; FV_FACTS_ENDING_BALANCES

APPS.FV_FACTS1_PERIOD_BALANCES_V is referenced by following:

APPS: FV_FACTS1_PKG - show dependent code; FV_YE_CLOSE - show dependent code