VIEW: APPS.PAY_ZA_BANK_ADDRESS_V

Source

View Text - Preformatted

SELECT bd.BANK_NAME , bd.BRANCH_CODE , cp.ACCOUNT_TYPE , bd.STREAM_CODE , bd.BRANCH_NAME , bd.STREET_ADDRESS_LINE_1 , bd.STREET_ADDRESS_LINE_2 , bd.PO_BOX_NUMBER , bd.PO_BOX_POST_OFFICE , bd.POSTAL_CODE , cp.MODULUS , cp.FUDGE_FACTOR , cp.CDV_WEIGHTING1 , cp.CDV_WEIGHTING2 , cp.CDV_WEIGHTING3 , cp.CDV_WEIGHTING4 , cp.CDV_WEIGHTING5 , cp.CDV_WEIGHTING6 , cp.CDV_WEIGHTING7 , cp.CDV_WEIGHTING8 , cp.CDV_WEIGHTING9 , cp.CDV_WEIGHTING10 , cp.CDV_WEIGHTING11 , cp.EXCEPTION_CODE , cp.ACCOUNT_INDICATOR , bd.TELEPHONE_NUMBER , bd.DIALING_CODE , bd.TELEX1 , bd.TELEX2 From PAY_ZA_BRANCH_CDV_DETAILS bd , PAY_ZA_CDV_PARAMETERS cp WHERE bd.BRANCH_CODE = cp.BRANCH_CODE

View Text - HTML Formatted

SELECT BD.BANK_NAME
, BD.BRANCH_CODE
, CP.ACCOUNT_TYPE
, BD.STREAM_CODE
, BD.BRANCH_NAME
, BD.STREET_ADDRESS_LINE_1
, BD.STREET_ADDRESS_LINE_2
, BD.PO_BOX_NUMBER
, BD.PO_BOX_POST_OFFICE
, BD.POSTAL_CODE
, CP.MODULUS
, CP.FUDGE_FACTOR
, CP.CDV_WEIGHTING1
, CP.CDV_WEIGHTING2
, CP.CDV_WEIGHTING3
, CP.CDV_WEIGHTING4
, CP.CDV_WEIGHTING5
, CP.CDV_WEIGHTING6
, CP.CDV_WEIGHTING7
, CP.CDV_WEIGHTING8
, CP.CDV_WEIGHTING9
, CP.CDV_WEIGHTING10
, CP.CDV_WEIGHTING11
, CP.EXCEPTION_CODE
, CP.ACCOUNT_INDICATOR
, BD.TELEPHONE_NUMBER
, BD.DIALING_CODE
, BD.TELEX1
, BD.TELEX2
FROM PAY_ZA_BRANCH_CDV_DETAILS BD
, PAY_ZA_CDV_PARAMETERS CP
WHERE BD.BRANCH_CODE = CP.BRANCH_CODE