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]

TABLE: FV.FV_GTAS_ATTRIBUTES

Object Details

Object Name:	FV_GTAS_ATTRIBUTES
Object Type:	TABLE
Owner:	FV
Subobject Name:
Status:	VALID

Stores the USSGL accounts required for the GTAS report generation and all corresponding attributes related to them

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_GTAS_ATTRIBUTES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GTAS_ACCT_NUMBER SET_OF_BOOKS_ID
FV_GTAS_ATTRIBUTES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SGL_ATTRIBUTES_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Ledger ID
SGL_ATTRIBUTES_ID	NUMBER	(15)	Yes	Unique system generated identifier
GTAS_ACCT_NUMBER	VARCHAR2	(30)	Yes	GTAS Account Number
USSGL_ACCT_NUMBER	VARCHAR2	(30)		USSGL Account Number
BALANCE_TYPE	VARCHAR2	(2)	Yes	Balance Type: Valid values are B (Beginning), E (Ending) and BE (Both)
FED_NON_FED1	VARCHAR2	(1)		First Federal/Non-Federal Code Attribute
FED_NON_FED2	VARCHAR2	(1)		Second Federal/Non-Federal Code Attribute
FED_NON_FED3	VARCHAR2	(1)		Third Federal/Non-Federal Code Attribute
EXCH_NON_EXCH1	VARCHAR2	(1)		First Exchange/Non-Exchance Code Attribute
EXCH_NON_EXCH2	VARCHAR2	(1)		Second Exchange/Non-Exchange Code Attribute
EXCH_NON_EXCH3	VARCHAR2	(1)		Third Exchange/Non-Exchange Code Attribute
CUST_NON_CUST1	VARCHAR2	(1)		First Custodial/Non-Custodial Code Attribute
CUST_NON_CUST2	VARCHAR2	(1)		Second Custodial/Non-Custodial Code Attribute
AUTHORITY_TYPE1	VARCHAR2	(1)		First Authority Type Code
AUTHORITY_TYPE2	VARCHAR2	(1)		Second Authority Type Code
AUTHORITY_TYPE3	VARCHAR2	(1)		Third Authority Type Code
AUTHORITY_TYPE4	VARCHAR2	(1)		Fourth Authority Type Code
AUTHORITY_TYPE5	VARCHAR2	(1)		Fifth Authority Type Code
AUTHORITY_TYPE6	VARCHAR2	(1)		Sixth Authority Type Code
APPORTIONMENT_CATEGORY1	VARCHAR2	(1)		First Apportionment Category Code
APPORTIONMENT_CATEGORY2	VARCHAR2	(1)		Second Apportionment Category Code
APPORTIONMENT_CATEGORY3	VARCHAR2	(1)		Third Apportionment Category Code
NEW_BAL_CODE1	VARCHAR2	(3)		First New/Balance Code
NEW_BAL_CODE2	VARCHAR2	(3)		Second New/Balance Code
CUR_SUB_CODE1	VARCHAR2	(1)		First Current/Subsequent Code Attribute
CUR_SUB_CODE2	VARCHAR2	(1)		Second Current/Subsequent Code Attribute
BEA_CATEGORY1	VARCHAR2	(1)		First BEA Category Code
BEA_CATEGORY2	VARCHAR2	(1)		Second BEA Category Code
BEA_CATEGORY_ACCT_TYPE	VARCHAR2	(1)		BEA Category Account Type
BORROWING_SOURCE1	VARCHAR2	(1)		First Borrowing Source Code
BORROWING_SOURCE2	VARCHAR2	(1)		Second Borrowing Source Code
BORROWING_SOURCE3	VARCHAR2	(1)		Third Borrowing Source Code
PYA_CODE1	VARCHAR2	(1)		First Prior Year Adjustment Code
PYA_CODE2	VARCHAR2	(1)		Second Prior Year Adjustment Code
PYA_CODE3	VARCHAR2	(1)		Third Prior Year Adjustment Code
DIR_REIMB_CODE1	VARCHAR2	(1)		Second Direct or Reimbursable Code
DIR_REIMB_CODE2	VARCHAR2	(1)		Second Direct or Reimbursable Code
BUD_IMPACT_IND1	VARCHAR2	(1)		First Budget Impact Indicator Code
BUD_IMPACT_IND2	VARCHAR2	(1)		Second Budget Impact Indicator Code
PROG_COST_IND1	VARCHAR2	(1)		First Program Cost Indicator Code
PROG_COST_IND2	VARCHAR2	(1)		Second Program Cost Indicator Code
CREATION_DATE	DATE		Yes	Creation Date
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex Field structure definition column
DIRECT_OR_REIMB_FLAG	VARCHAR2	(1)		Direct Or Reimb Flag
APPOR_CAT_B_PROG_FLAG	VARCHAR2	(1)		Appor Cat B Prog Flag
PROG_REP_CAT_FLAG	VARCHAR2	(1)		Prog Rep Cat Flag
BEA_CATEGORY_FLAG	VARCHAR2	(1)		Bea Category Flag
BORROWING_SOURCE_FLAG	VARCHAR2	(1)		Borrowing Source Flag
PROGRAM_COST_IND_FLAG	VARCHAR2	(1)		Program Cost Ind Flag
NEW_OR_BAL_FLAG	VARCHAR2	(1)		New Or Bal Flag
TRADING_PARTNER_FLAG	VARCHAR2	(1)		Trading Partner Flag

Query Text

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


SELECT SET_OF_BOOKS_ID
,      SGL_ATTRIBUTES_ID
,      GTAS_ACCT_NUMBER
,      USSGL_ACCT_NUMBER
,      BALANCE_TYPE
,      FED_NON_FED1
,      FED_NON_FED2
,      FED_NON_FED3
,      EXCH_NON_EXCH1
,      EXCH_NON_EXCH2
,      EXCH_NON_EXCH3
,      CUST_NON_CUST1
,      CUST_NON_CUST2
,      AUTHORITY_TYPE1
,      AUTHORITY_TYPE2
,      AUTHORITY_TYPE3
,      AUTHORITY_TYPE4
,      AUTHORITY_TYPE5
,      AUTHORITY_TYPE6
,      APPORTIONMENT_CATEGORY1
,      APPORTIONMENT_CATEGORY2
,      APPORTIONMENT_CATEGORY3
,      NEW_BAL_CODE1
,      NEW_BAL_CODE2
,      CUR_SUB_CODE1
,      CUR_SUB_CODE2
,      BEA_CATEGORY1
,      BEA_CATEGORY2
,      BEA_CATEGORY_ACCT_TYPE
,      BORROWING_SOURCE1
,      BORROWING_SOURCE2
,      BORROWING_SOURCE3
,      PYA_CODE1
,      PYA_CODE2
,      PYA_CODE3
,      DIR_REIMB_CODE1
,      DIR_REIMB_CODE2
,      BUD_IMPACT_IND1
,      BUD_IMPACT_IND2
,      PROG_COST_IND1
,      PROG_COST_IND2
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      DIRECT_OR_REIMB_FLAG
,      APPOR_CAT_B_PROG_FLAG
,      PROG_REP_CAT_FLAG
,      BEA_CATEGORY_FLAG
,      BORROWING_SOURCE_FLAG
,      PROGRAM_COST_IND_FLAG
,      NEW_OR_BAL_FLAG
,      TRADING_PARTNER_FLAG
FROM FV.FV_GTAS_ATTRIBUTES;

Dependencies

[top of page]

FV.FV_GTAS_ATTRIBUTES does not reference any database object

FV.FV_GTAS_ATTRIBUTES is referenced by following:

FV: FV_GTAS_ATTRIBUTES#