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: FV.FV_GTAS1_PERIOD_ATTRIBUTES#

Object Details

Object Name:	FV_GTAS1_PERIOD_ATTRIBUTES#
Object Type:	VIEW
Owner:	FV
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes
ACCOUNT_TYPE	VARCHAR2	(1)
APPOR_CAT_B_CODE	VARCHAR2	(4)
APPOR_CAT_CODE	VARCHAR2	(1)
BALANCE_AMOUNT	NUMBER		Yes
BEA_CAT_CODE	VARCHAR2	(1)
BEGIN_BALANCE	NUMBER	(22)
BORR_SRC_CODE	VARCHAR2	(1)
CCID	NUMBER	(15)	Yes
CREDIT_COHORT_YR	VARCHAR2	(150)
CUR_SUBSEQUENT_CODE	VARCHAR2	(1)
CUST_NON_CUST	VARCHAR2	(1)
DIRECT_OR_REIMB_CODE	VARCHAR2	(1)
END_BAL_IND	VARCHAR2	(1)
EXCH_NON_EXCH	VARCHAR2	(1)
FUND_VALUE	VARCHAR2	(30)
NEW_BAL_CODE	VARCHAR2	(3)
NEW_REC_FLAG	VARCHAR2	(1)
PERIOD_BEGIN_BAL	NUMBER	(22)
PERIOD_CY_CR_BAL	NUMBER	(22)
PERIOD_CY_DR_BAL	NUMBER
PERIOD_NAME	VARCHAR2	(15)	Yes
PERIOD_YEAR	NUMBER	(15)	Yes
PROGRAM_COST_IND	VARCHAR2	(4)
PROGRAM_REPT_CODE	VARCHAR2	(4)
PYA_CODE	VARCHAR2	(1)
REPORTED_GROUP	VARCHAR2	(1)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
TREASURY_SYMBOL_ID	NUMBER	(15)
USSGL_ACCOUNT	VARCHAR2	(6)
PERIOD_NUM	NUMBER	(15)	Yes

Query Text

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


SELECT ACCOUNT_NUMBER
,      ACCOUNT_TYPE
,      APPOR_CAT_B_CODE
,      APPOR_CAT_CODE
,      BALANCE_AMOUNT
,      BEA_CAT_CODE
,      BEGIN_BALANCE
,      BORR_SRC_CODE
,      CCID
,      CREDIT_COHORT_YR
,      CUR_SUBSEQUENT_CODE
,      CUST_NON_CUST
,      DIRECT_OR_REIMB_CODE
,      END_BAL_IND
,      EXCH_NON_EXCH
,      FUND_VALUE
,      NEW_BAL_CODE
,      NEW_REC_FLAG
,      PERIOD_BEGIN_BAL
,      PERIOD_CY_CR_BAL
,      PERIOD_CY_DR_BAL
,      PERIOD_NAME
,      PERIOD_YEAR
,      PROGRAM_COST_IND
,      PROGRAM_REPT_CODE
,      PYA_CODE
,      REPORTED_GROUP
,      SET_OF_BOOKS_ID
,      TREASURY_SYMBOL_ID
,      USSGL_ACCOUNT
,      PERIOD_NUM
FROM FV.FV_GTAS1_PERIOD_ATTRIBUTES#;

Dependencies

[top of page]

FV.FV_GTAS1_PERIOD_ATTRIBUTES# references the following:

FV: FV_GTAS1_PERIOD_ATTRIBUTES

FV.FV_GTAS1_PERIOD_ATTRIBUTES# is referenced by following:

APPS: FV_GTAS1_PERIOD_ATTRIBUTES