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_GTAS_TRX_REG_TEMP#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes
TREASURY_SYMBOL_ID	NUMBER	(15)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
USSGL_ACCOUNT	VARCHAR2	(6)
CODE_COMBINATION_ID	NUMBER	(15)
EXCH_NON_EXCH	VARCHAR2	(1)
CUST_NON_CUST	VARCHAR2	(1)
FUND_VALUE	VARCHAR2	(30)	Yes
DIRECT_OR_REIMB_CODE	VARCHAR2	(1)
APPOR_CAT_CODE	VARCHAR2	(1)
APPOR_CAT_B_CODE	VARCHAR2	(4)
PROGRAM_REPT_CODE	VARCHAR2	(4)
BEA_CAT_CODE	VARCHAR2	(1)
BORR_SRC_CODE	VARCHAR2	(1)
NEW_BAL_CODE	VARCHAR2	(3)
CUR_SUBSEQUENT_CODE	VARCHAR2	(3)
PYA_CODE	VARCHAR2	(1)
CREDIT_COHORT_YR	VARCHAR2	(150)
PROGRAM_COST_IND	VARCHAR2	(4)
BUDGET_IMPACT_IND	VARCHAR2	(1)
AUTHORITY_TYPE_CODE	VARCHAR2	(1)
FED_NON_FED	VARCHAR2	(1)
TRADING_PARTNER_AGENCY_ID	VARCHAR2	(3)
TRADING_PARTNER_MAIN_ACCOUNT	VARCHAR2	(4)
ENTRY_USER	VARCHAR2	(100)
JOURNAL_CREATION_DATE	DATE
JOURNAL_MODIFIED_DATE	DATE
PERIOD_NAME	VARCHAR2	(15)
GL_DATE	DATE
GL_POSTED_DATE	DATE
DOCUMENT_CATEGORY	VARCHAR2	(80)
REVERSAL_FLAG	VARCHAR2	(1)
SLA_HDR_EVENT_ID	NUMBER
SLA_HDR_CREATION_DATE	DATE
SLA_ENTITY_ID	NUMBER
DOCUMENT_NUMBER	VARCHAR2	(240)
DOCUMENT_DATE	DATE
DOCUMENT_SOURCE	VARCHAR2	(80)
TRANSACTION_DATE	DATE
CREATION_DATE_TIME	DATE
ADVANCE_FLAG	VARCHAR2	(1)
TRANSFER_DEPT_ID	VARCHAR2	(3)
TRANSFER_MAIN_ACCT	VARCHAR2	(4)
YEAR_BUDGET_AUTH	VARCHAR2	(3)
PERIOD_ACTIVITY	NUMBER
DEF_LIQUID_FLAG	VARCHAR2	(1)
DEFICIENCY_FLAG	VARCHAR2	(1)
AVAILABILITY_FLAG	VARCHAR2	(1)
LEGISLATION_FLAG	VARCHAR2	(1)
DEBIT	NUMBER
CREDIT	NUMBER
BEGIN_END	VARCHAR2	(1)
INDEF_DEF_FLAG	VARCHAR2	(1)
AUTHORITY_TYPE	VARCHAR2	(1)
TRANSACTION_PARTNER	VARCHAR2	(1)
REIMBURSEABLE_FLAG	VARCHAR2	(1)

Query Text

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


SELECT ACCOUNT_NUMBER
,      TREASURY_SYMBOL_ID
,      SET_OF_BOOKS_ID
,      USSGL_ACCOUNT
,      CODE_COMBINATION_ID
,      EXCH_NON_EXCH
,      CUST_NON_CUST
,      FUND_VALUE
,      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
,      BUDGET_IMPACT_IND
,      AUTHORITY_TYPE_CODE
,      FED_NON_FED
,      TRADING_PARTNER_AGENCY_ID
,      TRADING_PARTNER_MAIN_ACCOUNT
,      ENTRY_USER
,      JOURNAL_CREATION_DATE
,      JOURNAL_MODIFIED_DATE
,      PERIOD_NAME
,      GL_DATE
,      GL_POSTED_DATE
,      DOCUMENT_CATEGORY
,      REVERSAL_FLAG
,      SLA_HDR_EVENT_ID
,      SLA_HDR_CREATION_DATE
,      SLA_ENTITY_ID
,      DOCUMENT_NUMBER
,      DOCUMENT_DATE
,      DOCUMENT_SOURCE
,      TRANSACTION_DATE
,      CREATION_DATE_TIME
,      ADVANCE_FLAG
,      TRANSFER_DEPT_ID
,      TRANSFER_MAIN_ACCT
,      YEAR_BUDGET_AUTH
,      PERIOD_ACTIVITY
,      DEF_LIQUID_FLAG
,      DEFICIENCY_FLAG
,      AVAILABILITY_FLAG
,      LEGISLATION_FLAG
,      DEBIT
,      CREDIT
,      BEGIN_END
,      INDEF_DEF_FLAG
,      AUTHORITY_TYPE
,      TRANSACTION_PARTNER
,      REIMBURSEABLE_FLAG
FROM FV.FV_GTAS_TRX_REG_TEMP#;

Dependencies

[top of page]

FV.FV_GTAS_TRX_REG_TEMP# references the following:

FV: FV_GTAS_TRX_REG_TEMP

FV.FV_GTAS_TRX_REG_TEMP# is referenced by following:

APPS: FV_GTAS_TRX_REG_TEMP