DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PSA_MF_BALANCES_VIEW

Object Details
Object Name: PSA_MF_BALANCES_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSA.PSA_MF_BALANCES_VIEW
Subobject Name:
Status: VALID

View Type

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


PSA_MF_BALANCES_VIEW shows the balances per transaction distribution.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes Customer transaction identifier
CUST_TRX_LINE_GL_DIST_ID NUMBER (15) Yes Customer transaction line GL distribution Identifier
CUSTOMER_TRX_LINE_ID NUMBER (15) Yes Customer transaction line identifier
LINE_NUMBER NUMBER
Yes Line number
AMOUNT_DUE_ORIGINAL NUMBER

Amount due original
AMOUNT_APPLIED NUMBER

Amount applied
AMOUNT_ADJUSTED NUMBER

Amount adjusted
AMOUNT_CREDITED NUMBER

Amount credited
AMOUNT_DISCOUNTED NUMBER

Amount discounted
AMOUNT_DUE_REMAINING NUMBER

Amount due remaining
Query Text

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


SELECT CUSTOMER_TRX_ID
,      CUST_TRX_LINE_GL_DIST_ID
,      CUSTOMER_TRX_LINE_ID
,      LINE_NUMBER
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_APPLIED
,      AMOUNT_ADJUSTED
,      AMOUNT_CREDITED
,      AMOUNT_DISCOUNTED
,      AMOUNT_DUE_REMAINING
FROM APPS.PSA_MF_BALANCES_VIEW;

Dependencies

[top of page]

APPS.PSA_MF_BALANCES_VIEW references the following:

SchemaAPPS
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymPSA_MF_ADJ_DIST_ALL
SynonymPSA_MF_RCT_DIST_ALL
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymRA_CUST_TRX_LINE_GL_DIST_ALL
APPS.PSA_MF_BALANCES_VIEW is referenced by following:

SchemaAPPS
Package BodyARP_DET_DIST_PKG - show dependent code
PL/SQL PackagePSA_MFAR_ADJUSTMENTS - show dependent code
Package BodyPSA_MFAR_ADJUSTMENTS - show dependent code
Package BodyPSA_MFAR_RECEIPTS - show dependent code
ViewPSA_MF_PAYMENT_SCHEDULES_V