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_GTAS_PERIOD_BALANCES_TB_V

Object Details

Object Name:	FV_GTAS_PERIOD_BALANCES_TB_V
Object Type:	VIEW
Owner:	APPS
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 GTAS Trial Balance

[View Source]

Columns

Name	Datatype	Length	Comments
CCID	NUMBER	(15)	Ccid
SET_OF_BOOKS_ID	NUMBER	(15)	Set Of Books Id
PERIOD_YEAR	NUMBER	(15)	Period Year
PERIOD_NUM	NUMBER	(15)	Period Num
PERIOD_NAME	VARCHAR2	(15)	Period Name
ACCOUNT_NUMBER	VARCHAR2	(30)	Account Number
FUND_VALUE	VARCHAR2	(30)	Fund Value
REPORTED_STATUS	CHAR	(1)	Reported Status
USSGL_ACCOUNT	VARCHAR2	(6)	Ussgl Account
EXCH_NON_EXCH	VARCHAR2	(1)	Exch Non Exch
CUST_NON_CUST	VARCHAR2	(1)	Cust Non Cust
ACCOUNT_TYPE	VARCHAR2	(1)	Account Type
PERIOD_BEGIN_BAL	NUMBER		Beginning Balance
PERIOD_DR	NUMBER		Period Dr
PERIOD_CR	NUMBER		Period Cr
D_C_INDICATOR	VARCHAR2	(1)	D C Indicator
BALANCE_TYPE	CHAR	(1)	Balance Type
DIRECT_OR_REIMB_CODE	VARCHAR2	(1)	Direct Or Reimb Code
APPOR_CAT_CODE	VARCHAR2	(1)	Appor Cat Code
APPOR_CAT_B_CODE	VARCHAR2	(4)	Appor Cat B Code
PROGRAM_REPT_CODE	VARCHAR2	(4)	Program Rept Code
BEA_CAT_CODE	VARCHAR2	(1)	Bea Cat Code
BORR_SRC_CODE	VARCHAR2	(1)	Borr Src Code
NEW_BAL_CODE	VARCHAR2	(3)	New Bal Code
CUR_SUBSEQUENT_CODE	VARCHAR2	(1)	Cur Subsequent Code
PYA_CODE	VARCHAR2	(1)	Pya Code
CREDIT_COHORT_YR	VARCHAR2	(150)	Credit Cohort Yr
PROGRAM_COST_IND	VARCHAR2	(4)	Program Cost Ind
TREASURY_SYMBOL_ID	NUMBER	(15)	Treasury Symbol Id
BUDGET_IMPACT_IND	VARCHAR2	(1)	Budget Impact Ind
AUTHORITY_TYPE_CODE	VARCHAR2	(1)	Authority Type Code
FED_NON_FED	VARCHAR2	(1)	Fed Non Fed
TRADING_PARTNER_AGENCY_ID	VARCHAR2	(3)	Trading Partner Agency Id
TRADING_PARTNER_MAIN_ACCOUNT	VARCHAR2	(4)	Trading Partner Main Account
END_BAL_IND	VARCHAR2	(1)	End Bal Ind
BEGIN_END	CHAR	(1)	Begin End

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
,      ACCOUNT_NUMBER
,      FUND_VALUE
,      REPORTED_STATUS
,      USSGL_ACCOUNT
,      EXCH_NON_EXCH
,      CUST_NON_CUST
,      ACCOUNT_TYPE
,      PERIOD_BEGIN_BAL
,      PERIOD_DR
,      PERIOD_CR
,      D_C_INDICATOR
,      BALANCE_TYPE
,      DIRECT_OR_REIMB_CODE
,      APPOR_CAT_CODE
,      APPOR_CAT_B_CODE
,      PROGRAM_REPT_CODE
,      BEA_CAT_CODE
,      BORR_SRC_CODE
,      NEW_BAL_CODE
,      CUR_SUBSEQUENT_CODE
,      PYA_CODE
,      CREDIT_COHORT_YR
,      PROGRAM_COST_IND
,      TREASURY_SYMBOL_ID
,      BUDGET_IMPACT_IND
,      AUTHORITY_TYPE_CODE
,      FED_NON_FED
,      TRADING_PARTNER_AGENCY_ID
,      TRADING_PARTNER_MAIN_ACCOUNT
,      END_BAL_IND
,      BEGIN_END
FROM APPS.FV_GTAS_PERIOD_BALANCES_TB_V;

Dependencies

[top of page]

APPS.FV_GTAS_PERIOD_BALANCES_TB_V references the following:

APPS: FV_GTAS1_PERIOD_ATTRIBUTES; FV_GTAS_ACTIVITY_BALANCES; FV_GTAS_ENDING_BALANCES

APPS.FV_GTAS_PERIOD_BALANCES_TB_V is not referenced by any database object