VIEW: APPS.XTR_SWIFT_EFT_V

Source

View Text - Preformatted

SELECT s.settlement_number settlement_number, s.company company, bc.party_code cparty, p.full_name comp_name, pc.full_name cp_name, s.currency currency, s.settlement_amount settlement_amount, s.settlement_date settlement_date, s.company_acct_no company_acct_no, s.cparty_acct_no cparty_acct_no, b.swift_id comp_swift_id, pb.swift_id cp_swift_id, p.address_1 comp_address1, p.address_2 comp_address2, p.address_3 comp_address3, pc.p_address_1 cp_address1, pc.p_address_2 cp_address2, pc.p_address_3 cp_address3, b.bank_code comp_bank_code, bc.bank_code cp_bank_code, b.bank_name comp_bank_name, bc.bank_name cp_bank_name, b.location comp_bank_location, bc.location cp_bank_location, b.street comp_bank_street, bc.street cp_bank_street, bc.sub_account_at cp_corr_bank_name, bc.sub_account_number cp_corr_bank_no, ic.iban cp_iban, s.settlement_summary_id settlement_summary_id from xtr_settlement_summary s, xtr_bank_accounts b, xtr_bank_accounts bc, xtr_bank_accounts ic,xtr_parties_v p, xtr_parties_v pc, xtr_parties_v pb WHERE s.settlement_amount< 0 and bc.bank_code = pb.party_code and b.account_number = s.company_acct_no and b.party_code = s.company and bc.account_number = s.cparty_acct_no AND ic.account_number = s.cparty_acct_no and p.party_code = s.company and b.party_type = 'C' and s.status= 'A' and s.cparty_code = pc.party_code and pc.party_code = bc.party_code and nvl(s.external_source,'N')<> 'ZBA'

View Text - HTML Formatted

SELECT S.SETTLEMENT_NUMBER SETTLEMENT_NUMBER
, S.COMPANY COMPANY
, BC.PARTY_CODE CPARTY
, P.FULL_NAME COMP_NAME
, PC.FULL_NAME CP_NAME
, S.CURRENCY CURRENCY
, S.SETTLEMENT_AMOUNT SETTLEMENT_AMOUNT
, S.SETTLEMENT_DATE SETTLEMENT_DATE
, S.COMPANY_ACCT_NO COMPANY_ACCT_NO
, S.CPARTY_ACCT_NO CPARTY_ACCT_NO
, B.SWIFT_ID COMP_SWIFT_ID
, PB.SWIFT_ID CP_SWIFT_ID
, P.ADDRESS_1 COMP_ADDRESS1
, P.ADDRESS_2 COMP_ADDRESS2
, P.ADDRESS_3 COMP_ADDRESS3
, PC.P_ADDRESS_1 CP_ADDRESS1
, PC.P_ADDRESS_2 CP_ADDRESS2
, PC.P_ADDRESS_3 CP_ADDRESS3
, B.BANK_CODE COMP_BANK_CODE
, BC.BANK_CODE CP_BANK_CODE
, B.BANK_NAME COMP_BANK_NAME
, BC.BANK_NAME CP_BANK_NAME
, B.LOCATION COMP_BANK_LOCATION
, BC.LOCATION CP_BANK_LOCATION
, B.STREET COMP_BANK_STREET
, BC.STREET CP_BANK_STREET
, BC.SUB_ACCOUNT_AT CP_CORR_BANK_NAME
, BC.SUB_ACCOUNT_NUMBER CP_CORR_BANK_NO
, IC.IBAN CP_IBAN
, S.SETTLEMENT_SUMMARY_ID SETTLEMENT_SUMMARY_ID
FROM XTR_SETTLEMENT_SUMMARY S
, XTR_BANK_ACCOUNTS B
, XTR_BANK_ACCOUNTS BC
, XTR_BANK_ACCOUNTS IC
, XTR_PARTIES_V P
, XTR_PARTIES_V PC
, XTR_PARTIES_V PB
WHERE S.SETTLEMENT_AMOUNT< 0
AND BC.BANK_CODE = PB.PARTY_CODE
AND B.ACCOUNT_NUMBER = S.COMPANY_ACCT_NO
AND B.PARTY_CODE = S.COMPANY
AND BC.ACCOUNT_NUMBER = S.CPARTY_ACCT_NO
AND IC.ACCOUNT_NUMBER = S.CPARTY_ACCT_NO
AND P.PARTY_CODE = S.COMPANY
AND B.PARTY_TYPE = 'C'
AND S.STATUS= 'A'
AND S.CPARTY_CODE = PC.PARTY_CODE
AND PC.PARTY_CODE = BC.PARTY_CODE
AND NVL(S.EXTERNAL_SOURCE
, 'N')<> 'ZBA'