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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
TREASURY_SYMBOL_ID	NUMBER	(15)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes
COHORT	VARCHAR2	(2)
BEGIN_END	VARCHAR2	(1)
INDEF_DEF_FLAG	VARCHAR2	(1)
APPOR_CAT_B_DTL	VARCHAR2	(3)
APPOR_CAT_B_TXT	VARCHAR2	(25)
PUBLIC_LAW	VARCHAR2	(7)
APPOR_CAT_CODE	VARCHAR2	(1)
AUTHORITY_TYPE	VARCHAR2	(1)
TRANSACTION_PARTNER	VARCHAR2	(1)
REIMBURSEABLE_FLAG	VARCHAR2	(1)
BEA_CATEGORY	VARCHAR2	(5)
BORROWING_SOURCE	VARCHAR2	(6)
DEF_LIQUID_FLAG	VARCHAR2	(1)
DEFICIENCY_FLAG	VARCHAR2	(1)
AVAILABILITY_FLAG	VARCHAR2	(1)
LEGISLATION_FLAG	VARCHAR2	(1)
DEBIT	NUMBER
CREDIT	NUMBER
FUND_VALUE	VARCHAR2	(25)	Yes
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)
BUDGET_FUNCTION	VARCHAR2	(3)
PERIOD_ACTIVITY	NUMBER
CODE_COMBINATION_ID	NUMBER	(15)
ENTRY_USER	VARCHAR2	(100)
FED_NON_FED	VARCHAR2	(1)
TRADING_PARTNER	VARCHAR2	(6)
EXCH_NON_EXCH	VARCHAR2	(1)
CUST_NON_CUST	VARCHAR2	(1)
BUDGET_SUBFUNCTION	VARCHAR2	(3)
JOURNAL_CREATION_DATE	DATE
JOURNAL_MODIFIED_DATE	DATE
PERIOD_NAME	VARCHAR2	(15)
PROGRAM_RPT_CAT_NUM	VARCHAR2	(3)
PROGRAM_RPT_CAT_TXT	VARCHAR2	(25)
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
PYA_FLAG	VARCHAR2	(1)

Query Text

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


SELECT TREASURY_SYMBOL_ID
,      SET_OF_BOOKS_ID
,      ACCOUNT_NUMBER
,      COHORT
,      BEGIN_END
,      INDEF_DEF_FLAG
,      APPOR_CAT_B_DTL
,      APPOR_CAT_B_TXT
,      PUBLIC_LAW
,      APPOR_CAT_CODE
,      AUTHORITY_TYPE
,      TRANSACTION_PARTNER
,      REIMBURSEABLE_FLAG
,      BEA_CATEGORY
,      BORROWING_SOURCE
,      DEF_LIQUID_FLAG
,      DEFICIENCY_FLAG
,      AVAILABILITY_FLAG
,      LEGISLATION_FLAG
,      DEBIT
,      CREDIT
,      FUND_VALUE
,      DOCUMENT_NUMBER
,      DOCUMENT_DATE
,      DOCUMENT_SOURCE
,      TRANSACTION_DATE
,      CREATION_DATE_TIME
,      ADVANCE_FLAG
,      TRANSFER_DEPT_ID
,      TRANSFER_MAIN_ACCT
,      YEAR_BUDGET_AUTH
,      BUDGET_FUNCTION
,      PERIOD_ACTIVITY
,      CODE_COMBINATION_ID
,      ENTRY_USER
,      FED_NON_FED
,      TRADING_PARTNER
,      EXCH_NON_EXCH
,      CUST_NON_CUST
,      BUDGET_SUBFUNCTION
,      JOURNAL_CREATION_DATE
,      JOURNAL_MODIFIED_DATE
,      PERIOD_NAME
,      PROGRAM_RPT_CAT_NUM
,      PROGRAM_RPT_CAT_TXT
,      GL_DATE
,      GL_POSTED_DATE
,      DOCUMENT_CATEGORY
,      REVERSAL_FLAG
,      SLA_HDR_EVENT_ID
,      SLA_HDR_CREATION_DATE
,      SLA_ENTITY_ID
,      PYA_FLAG
FROM FV.FV_FACTS_TRX_TEMP#;

Dependencies

[top of page]

FV.FV_FACTS_TRX_TEMP# references the following:

FV: FV_FACTS_TRX_TEMP

FV.FV_FACTS_TRX_TEMP# is referenced by following:

APPS: FV_FACTS_TRX_TEMP