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

Object Details

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

FUN_INTER_ACCOUNTS_V view retrieves all tne intercompany receivables and payables accounts used for balancing.

[View Source]

Columns

Name	Datatype	Length	Comments
FROM_LE_ID	NUMBER	(15)	Transacting or Initiating Legal Entity identifier
LEDGER_ID	NUMBER	(15)	Transacting or Originating Ledger identifier
TO_LE_ID	NUMBER	(15)	Trading or Receiving Legal Entity identifier
CCID	NUMBER	(15)	Code combination of account
TYPE	VARCHAR2	(30)	Type of account. Valid values are - R (Intercompany Receivables) and P (Intercompany Payables)
TRANS_BSV	VARCHAR2	(150)	Transaction or Initiating balancing segment value
TP_BSV	VARCHAR2	(150)	Trading or receiving balancing segment value

Query Text

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


SELECT FROM_LE_ID
,      LEDGER_ID
,      TO_LE_ID
,      CCID
,      TYPE
,      TRANS_BSV
,      TP_BSV
FROM APPS.FUN_INTER_ACCOUNTS_V;

Dependencies

[top of page]

APPS.FUN_INTER_ACCOUNTS_V references the following:

APPS: FUN_INTER_ACCOUNTS; FUN_INTER_ACCOUNTS_ADDL

APPS.FUN_INTER_ACCOUNTS_V is referenced by following:

APPS: FUN_BAL_PKG - show dependent code; FUN_BAL_UTILS_GRP - show dependent code; FUN_RECIPIENT_WF - show dependent code; FUN_RECON_RPT_PKG - show dependent code