VIEW: POS.POS_BANK_ACCNT_OWNERS_INT#

Source

View Text - Preformatted

select BANK_ACCT_OWNER_INTERFACE_ID BANK_ACCT_OWNER_INTERFACE_ID, BATCH_ID BATCH_ID, SOURCE_SYSTEM SOURCE_SYSTEM, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID, BANK_ACCOUNT_INTERFACE_ID BANK_ACCOUNT_INTERFACE_ID, ACCOUNT_OWNER_NAME ACCOUNT_OWNER_NAME, BANK_ID BANK_ID, BANK_NAME BANK_NAME, BANK_NUMBER BANK_NUMBER, BANK_COUNTRY_CODE BANK_COUNTRY_CODE, BRANCH_ID BRANCH_ID, BRANCH_NAME BRANCH_NAME, BRANCH_NUMBER BRANCH_NUMBER, ACCOUNT_ID ACCOUNT_ID, ACCOUNT_NUMBER ACCOUNT_NUMBER, PRIMARY_FLAG PRIMARY_FLAG, END_DATE END_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, INTERFACE_STATUS INTERFACE_STATUS, PARTY_ID PARTY_ID from "POS"."POS_BANK_ACCNT_OWNERS_INT"

View Text - HTML Formatted

SELECT BANK_ACCT_OWNER_INTERFACE_ID BANK_ACCT_OWNER_INTERFACE_ID
, BATCH_ID BATCH_ID
, SOURCE_SYSTEM SOURCE_SYSTEM
, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE
, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID
, BANK_ACCOUNT_INTERFACE_ID BANK_ACCOUNT_INTERFACE_ID
, ACCOUNT_OWNER_NAME ACCOUNT_OWNER_NAME
, BANK_ID BANK_ID
, BANK_NAME BANK_NAME
, BANK_NUMBER BANK_NUMBER
, BANK_COUNTRY_CODE BANK_COUNTRY_CODE
, BRANCH_ID BRANCH_ID
, BRANCH_NAME BRANCH_NAME
, BRANCH_NUMBER BRANCH_NUMBER
, ACCOUNT_ID ACCOUNT_ID
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, PRIMARY_FLAG PRIMARY_FLAG
, END_DATE END_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, INTERFACE_STATUS INTERFACE_STATUS
, PARTY_ID PARTY_ID
FROM "POS"."POS_BANK_ACCNT_OWNERS_INT"