[Home] [Help] [Dependency Information]
Object Name: | POS_BANK_ACCNT_OWNERS_INT# |
---|---|
Object Type: | VIEW |
Owner: | POS |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|