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_XLA_AR_REF_V

Object Details

Object Name:	FV_XLA_AR_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_XLA_AR_REF_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is used as receivables federal accounting source in subledger accounting (XLA)

[View Source]

Columns

Name	Datatype	Length	Comments
FEDERAL_EVENT_ID	NUMBER	(15)	Event identifier
FEDERAL_LINE_NUMBER	NUMBER	(15)	Line number
FEDERAL_FUND_TIME_FRAME	VARCHAR2	(25)	Fund time frame
FEDERAL_FUND_EXPIRED_STATUS	VARCHAR2	(15)	Fund expired status
FEDERAL_APPORTIONMENT_CATEGORY	VARCHAR2	(1)	Apportionment category
FEDERAL_FUND_CATEGORY	VARCHAR2	(1)	Fund category
FEDERAL_PRIOR_YEAR_FLAG	VARCHAR2	(1)	Flag to denote prior year transaction
FEDERAL_ACCOUNT_VALID_FLAG	VARCHAR2	(1)	Flag denotes whether the account is valid for that transaction
FEDERAL_ACCOUNT_RULE	VARCHAR2	(50)	Account rule
FED_RECEIVABLE_WITH_ADVANCE	VARCHAR2	(1)	Receivable with Advance
FED_AR_TRANSACTION_CATEGORY	VARCHAR2	(50)	AR Transaction Category
FEDERAL_FUND_TYPE	VARCHAR2	(2)	Federal Fund Type
FEDERAL_NON_FEDERAL_IND	VARCHAR2	(1)	Federal Non Federal Indicator

Query Text

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


SELECT FEDERAL_EVENT_ID
,      FEDERAL_LINE_NUMBER
,      FEDERAL_FUND_TIME_FRAME
,      FEDERAL_FUND_EXPIRED_STATUS
,      FEDERAL_APPORTIONMENT_CATEGORY
,      FEDERAL_FUND_CATEGORY
,      FEDERAL_PRIOR_YEAR_FLAG
,      FEDERAL_ACCOUNT_VALID_FLAG
,      FEDERAL_ACCOUNT_RULE
,      FED_RECEIVABLE_WITH_ADVANCE
,      FED_AR_TRANSACTION_CATEGORY
,      FEDERAL_FUND_TYPE
,      FEDERAL_NON_FEDERAL_IND
FROM APPS.FV_XLA_AR_REF_V;

Dependencies

[top of page]

APPS.FV_XLA_AR_REF_V references the following:

APPS: FV_EXTRACT_DETAIL_GT

APPS.FV_XLA_AR_REF_V is referenced by following:

APPS: XLA_00222_AAD_S_000005_PKG - show dependent code; XLA_00222_AAD_S_000006_PKG - show dependent code; XLA_00222_AAD_S_000009_PKG - show dependent code