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

Object Details

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

View Type

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

List of payments with their associated bank details.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes	Assignment Action ID
PAYMENT_METHOD	VARCHAR2	(30)		Payment Method
BANK	VARCHAR2	(40)		Bank
BRANCH_CODE	VARCHAR2	(150)		Branch Code
ACCOUNT_NO	VARCHAR2	(150)		Account Number
PAYMENT_AMOUNT	NUMBER		Yes	Payment Amount
PAYMENT_DATE	DATE			Payment Date

Query Text

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


SELECT ROW_ID
,      ASSIGNMENT_ACTION_ID
,      PAYMENT_METHOD
,      BANK
,      BRANCH_CODE
,      ACCOUNT_NO
,      PAYMENT_AMOUNT
,      PAYMENT_DATE
FROM APPS.PAY_ZA_EXTERNAL_ACCOUNTS_V;

Dependencies

[top of page]

APPS.PAY_ZA_EXTERNAL_ACCOUNTS_V references the following:

APPS: PAY_ASSIGNMENT_ACTIONS; PAY_EXTERNAL_ACCOUNTS; PAY_ORG_PAYMENT_METHODS_F; PAY_PAYROLL_ACTIONS; PAY_PERSONAL_PAYMENT_METHODS_F; PAY_PRE_PAYMENTS; PAY_ZA_BRANCH_CDV_DETAILS

APPS.PAY_ZA_EXTERNAL_ACCOUNTS_V is referenced by following:

PUBLIC: PAY_ZA_EXTERNAL_ACCOUNTS_V