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_BANK_ADDRESS_V

Object Details

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

View Type

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

PAY_ZA_BANK_ADDRESS_V is a view based on Bank / Branch details and CDV weighting factors.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BANK_NAME	VARCHAR2	(40)		Bank Name
BRANCH_CODE	VARCHAR2	(6)	Yes	Branch Code
ACCOUNT_TYPE	NUMBER	(1)	Yes	Type of Account
STREAM_CODE	NUMBER	(2)	Yes	Stream Code
BRANCH_NAME	VARCHAR2	(30)	Yes	Branch Name
STREET_ADDRESS_LINE_1	VARCHAR2	(48)		Address Details
STREET_ADDRESS_LINE_2	VARCHAR2	(48)		Address Details
PO_BOX_NUMBER	VARCHAR2	(35)		Address Details
PO_BOX_POST_OFFICE	VARCHAR2	(20)		Address Details
POSTAL_CODE	NUMBER	(6)		Address Details
MODULUS	NUMBER	(2)		Modulus factor
FUDGE_FACTOR	NUMBER	(2)		Factor added to check sum calculation
CDV_WEIGHTING1	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING2	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING3	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING4	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING5	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING6	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING7	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING8	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING9	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING10	NUMBER	(2)		Validation Weighting
CDV_WEIGHTING11	NUMBER	(2)		Validation Weighting
EXCEPTION_CODE	VARCHAR2	(2)		Additional Validation
ACCOUNT_INDICATOR	VARCHAR2	(1)		Account Indicator
TELEPHONE_NUMBER	VARCHAR2	(14)		Contact Details
DIALING_CODE	VARCHAR2	(20)		Contact Details
TELEX1	VARCHAR2	(20)		Contact Details
TELEX2	VARCHAR2	(20)		Contact Details

Query Text

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


SELECT BANK_NAME
,      BRANCH_CODE
,      ACCOUNT_TYPE
,      STREAM_CODE
,      BRANCH_NAME
,      STREET_ADDRESS_LINE_1
,      STREET_ADDRESS_LINE_2
,      PO_BOX_NUMBER
,      PO_BOX_POST_OFFICE
,      POSTAL_CODE
,      MODULUS
,      FUDGE_FACTOR
,      CDV_WEIGHTING1
,      CDV_WEIGHTING2
,      CDV_WEIGHTING3
,      CDV_WEIGHTING4
,      CDV_WEIGHTING5
,      CDV_WEIGHTING6
,      CDV_WEIGHTING7
,      CDV_WEIGHTING8
,      CDV_WEIGHTING9
,      CDV_WEIGHTING10
,      CDV_WEIGHTING11
,      EXCEPTION_CODE
,      ACCOUNT_INDICATOR
,      TELEPHONE_NUMBER
,      DIALING_CODE
,      TELEX1
,      TELEX2
FROM APPS.PAY_ZA_BANK_ADDRESS_V;

Dependencies

[top of page]

APPS.PAY_ZA_BANK_ADDRESS_V references the following:

APPS: PAY_ZA_BRANCH_CDV_DETAILS; PAY_ZA_CDV_PARAMETERS

APPS.PAY_ZA_BANK_ADDRESS_V is referenced by following:

APPS: PY_ZA_CDV - show dependent code
PUBLIC: PAY_ZA_BANK_ADDRESS_V