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.ARFV_APP_DISTS_ALC_V

Object Details

Object Name:	ARFV_APP_DISTS_ALC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.ARFV_APP_DISTS_ALC_V
Subobject Name:
Status:	VALID

View Type

A multiple reporting currency view

This shows Alternate Currencies information about cash receipt applications transferred to the Subledger Accounting.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FUNCTIONAL_DEBIT_AMOUNT	NUMBER			The debit amount converted to functional currency.
FUNCTIONAL_CREDIT_AMOUNT	NUMBER			The credit amount converted to functional currency.
_LA:POSTED_FLAG	CHAR	(77)		Posted flag
LEDGER_NAME	VARCHAR2	(30)	Yes	Ledger Name
RECEIVABLE_APPLICATION_ID	NUMBER	(15)	Yes	Unique Identifier for Receivable Application
_LA:ACCOUNT_TYPE	VARCHAR2	(113)		Account Type
LEDGER_ID	NUMBER	(15)	Yes	Unique Identifier for Ledger
ACCOUNTING_CLASS_CODE	VARCHAR2	(30)	Yes

Query Text

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


SELECT FUNCTIONAL_DEBIT_AMOUNT
,      FUNCTIONAL_CREDIT_AMOUNT
,      _LA:POSTED_FLAG
,      LEDGER_NAME
,      RECEIVABLE_APPLICATION_ID
,      _LA:ACCOUNT_TYPE
,      LEDGER_ID
,      ACCOUNTING_CLASS_CODE
FROM APPS.ARFV_APP_DISTS_ALC_V;

Dependencies

[top of page]

APPS.ARFV_APP_DISTS_ALC_V references the following:

APPS: AR_DISTRIBUTIONS_ALL; FND_CURRENCIES; GL_LEDGERS_PUBLIC_V; XLA_AE_HEADERS; XLA_AE_LINES; XLA_DISTRIBUTION_LINKS

APPS.ARFV_APP_DISTS_ALC_V is not referenced by any database object