DBA Data[Home] [Help] [Dependency Information]

VIEW: POS.POS_BANK_ACCNT_OWNERS_INT#

Object Details
Object Name: POS_BANK_ACCNT_OWNERS_INT#
Object Type: VIEW
Owner: POS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BANK_ACCT_OWNER_INTERFACE_ID NUMBER
Yes
BATCH_ID NUMBER

SOURCE_SYSTEM VARCHAR2 (40)
SOURCE_SYSTEM_REFERENCE VARCHAR2 (255)
ACCOUNT_OWNER_PARTY_ID NUMBER

BANK_ACCOUNT_INTERFACE_ID NUMBER

ACCOUNT_OWNER_NAME VARCHAR2 (100)
BANK_ID NUMBER

BANK_NAME VARCHAR2 (100)
BANK_NUMBER VARCHAR2 (100)
BANK_COUNTRY_CODE VARCHAR2 (100)
BRANCH_ID NUMBER

BRANCH_NAME VARCHAR2 (100)
BRANCH_NUMBER VARCHAR2 (100)
ACCOUNT_ID NUMBER

ACCOUNT_NUMBER VARCHAR2 (100)
PRIMARY_FLAG VARCHAR2 (1)
END_DATE DATE

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

INTERFACE_STATUS VARCHAR2 (50)
PARTY_ID NUMBER

Query Text

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


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

Dependencies

[top of page]

POS.POS_BANK_ACCNT_OWNERS_INT# references the following:

SchemaPOS
TablePOS_BANK_ACCNT_OWNERS_INT
POS.POS_BANK_ACCNT_OWNERS_INT# is referenced by following:

SchemaAPPS
SynonymPOS_BANK_ACCNT_OWNERS_INT