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: ViewPAY.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:

SchemaAPPS
SynonymPAY_ZA_BRANCH_CDV_DETAILS
SynonymPAY_ZA_CDV_PARAMETERS
APPS.PAY_ZA_BANK_ADDRESS_V is referenced by following:

SchemaAPPS
Package BodyPY_ZA_CDV - show dependent code