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

Object Details

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

View Type

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

PSA_MF_CRM_DIST_V is used by Multi-Fund Accounts Receivables to view the Revenue and Receivable Accounts that are reversed by applying to a multi-fund transaction.
This View joins PSA_MF_TRX_DIST_ALL and PSA_MF_RCT_DIST_ALL tables.
This View is used for reporting purposes only.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Oracle database row identifier
RECEIVABLE_APPLICATION_ID	NUMBER	(15)	Yes	Identifies the receivable application
CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)	Yes	Revenue distribution identifier
MF_RECEIVABLES_CCID	NUMBER	(15)		Multi-fund transaction distribution receivable account identifier
MF_CASH_CCID	NUMBER	(15)		Multi-fund transaction distribution revenue account identifier
AMOUNT	NUMBER			Amount credited against the distribution
PERCENT	NUMBER			Percent of amount credited
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
DISCOUNT_CCID	NUMBER	(15)		General Ledger Code Combination for the earned discount distribution
UE_DISCOUNT_CCID	NUMBER	(15)		General Ledger Code Combination for the unearned discount distribution
DISCOUNT_AMOUNT	NUMBER			Amount of earned discount taken towards the application
UE_DISCOUNT_AMOUNT	NUMBER			Amount of unearned discount taken towards the application
COMMENTS	VARCHAR2	(2000)		Comments
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT ROW_ID
,      RECEIVABLE_APPLICATION_ID
,      CUST_TRX_LINE_GL_DIST_ID
,      MF_RECEIVABLES_CCID
,      MF_CASH_CCID
,      AMOUNT
,      PERCENT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DISCOUNT_CCID
,      UE_DISCOUNT_CCID
,      DISCOUNT_AMOUNT
,      UE_DISCOUNT_AMOUNT
,      COMMENTS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.PSA_MF_CRM_DIST_V;

Dependencies

[top of page]

APPS.PSA_MF_CRM_DIST_V references the following:

APPS: PSA_MF_RCT_DIST_ALL; PSA_MF_TRX_DIST_ALL

APPS.PSA_MF_CRM_DIST_V is not referenced by any database object