[Home] [Help] [Dependency Information]
Object Name: | CE_BU_PAY_EXTERNAL_ACCTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTERNAL_ACCOUNT_ID | NUMBER | (9) | ||
ACCOUNT_NAME | VARCHAR2 | (150) | ||
ACCOUNT_NUMBER | VARCHAR2 | (150) | ||
BANK_NAME | VARCHAR2 | (150) | ||
BRANCH_NAME | VARCHAR2 | (150) | ||
LOCATION | VARCHAR2 | (150) | ||
CURRENCY_CODE | VARCHAR2 | (150) | ||
BANK_NUMBER | VARCHAR2 | (150) | ||
BRANCH_NUMBER | VARCHAR2 | (150) | ||
BANK_ACCOUNT_TYPE | VARCHAR2 | (150) | ||
SECONDARY_ACCOUNT_REFERENCE | VARCHAR2 | (150) | ||
COMM_AGREEMENT_IDENTIFIER | VARCHAR2 | (150) | ||
ACCOUNT_SUFFIX | VARCHAR2 | (150) | ||
DESCRIPTION | VARCHAR2 | (150) | ||
DESCRIPTION_CODE1 | VARCHAR2 | (150) | ||
DESCRIPTION_CODE2 | VARCHAR2 | (150) | ||
EFT_REQUESTER_IDENTIFIER | VARCHAR2 | (150) | ||
BANK_NAME_KANA | VARCHAR2 | (60) | ||
BANK_START_DATE | DATE | |||
BANK_END_DATE | DATE | |||
BRANCH_NAME_KANA | VARCHAR2 | (90) | ||
BRANCH_START_DATE | DATE | |||
BRANCH_END_DATE | DATE | |||
ACCOUNT_START_DATE | DATE | |||
ACCOUNT_END_DATE | DATE | |||
COUNTRY | VARCHAR2 | (80) | ||
COUNTRY_CODE | VARCHAR2 | (2) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT EXTERNAL_ACCOUNT_ID
, ACCOUNT_NAME
, ACCOUNT_NUMBER
, BANK_NAME
, BRANCH_NAME
, LOCATION
, CURRENCY_CODE
, BANK_NUMBER
, BRANCH_NUMBER
, BANK_ACCOUNT_TYPE
, SECONDARY_ACCOUNT_REFERENCE
, COMM_AGREEMENT_IDENTIFIER
, ACCOUNT_SUFFIX
, DESCRIPTION
, DESCRIPTION_CODE1
, DESCRIPTION_CODE2
, EFT_REQUESTER_IDENTIFIER
, BANK_NAME_KANA
, BANK_START_DATE
, BANK_END_DATE
, BRANCH_NAME_KANA
, BRANCH_START_DATE
, BRANCH_END_DATE
, ACCOUNT_START_DATE
, ACCOUNT_END_DATE
, COUNTRY
, COUNTRY_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM APPS.CE_BU_PAY_EXTERNAL_ACCTS_V;
APPS.CE_BU_PAY_EXTERNAL_ACCTS_V is not referenced by any database object
|
|
|