eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IBY.IBY_TEMP_EXT_BANK_ACCTS

Object Details

Object Name:	IBY_TEMP_EXT_BANK_ACCTS
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_TEMP_EXT_BANK_ACCTS
Subobject Name:
Status:	VALID

IBY_TEMP_EXT_BANK_ACCTS defines the temporary records for external bank accounts.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_TEMP_EXT_BANK_ACCTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMP_EXT_BANK_ACCT_ID
IBY_TEMP_EXT_BANK_ACCTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXT_BANK_ACCOUNT_ID
IBY_TEMP_EXT_BANK_ACCTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNT_OWNER_PARTY_ID
IBY_TEMP_EXT_BANK_ACCTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_ID BRANCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMP_EXT_BANK_ACCT_ID	NUMBER	(15)	Yes	Primary key of this table
EXT_BANK_ACCOUNT_ID	NUMBER	(15)		Bank account Identifier of the table IBY_EXT_BANK_ACCOUNTS_B
COUNTRY_CODE	VARCHAR2	(2)	Yes	Country code of the bank account
BRANCH_ID	NUMBER	(15)		Identifier of the bank branch to which this bank account belongs. This column is used if the bank has been created in the system already.
BANK_ID	NUMBER	(15)		Identifier of the bank to which this bank branch belongs. This column is used if the branch has been created in the system already.
BANK_NAME	VARCHAR2	(80)		Bank name
BANK_NUMBER	VARCHAR2	(30)		Bank number
BANK_NAME_ALT	VARCHAR2	(80)		Alternative bank name
BANK_INSTITUTION_TYPE	VARCHAR2	(80)		Bank institution type
BANK_ADDRESS_ID	NUMBER	(15)		Bank location
BRANCH_NUMBER	VARCHAR2	(30)		Branch number
BRANCH_TYPE	VARCHAR2	(30)		Branch type
BRANCH_NAME	VARCHAR2	(80)		Branch name
BRANCH_NAME_ALT	VARCHAR2	(80)		Alternative branch name
BIC	VARCHAR2	(30)		BIC
RFC_IDENTIFIER	VARCHAR2	(30)		Branch RFC Identifier
BANK_CODE	VARCHAR2	(100)		Bank code
BRANCH_ADDRESS_ID	NUMBER	(15)		Branch location
ACCOUNT_OWNER_PARTY_ID	NUMBER	(15)		Owner party Identifier
OWNER_PRIMARY_FLAG	VARCHAR2	(1)		Primary flag for the owner
BANK_ACCOUNT_NAME	VARCHAR2	(80)		Bank account name
BANK_ACCOUNT_NUM	VARCHAR2	(100)		Account number
CURRENCY_CODE	VARCHAR2	(15)		Currency code
IBAN	VARCHAR2	(50)		IBAN
CHECK_DIGITS	VARCHAR2	(30)		Check digits
BANK_ACCOUNT_NAME_ALT	VARCHAR2	(320)		Alternate account name
BANK_ACCOUNT_TYPE	VARCHAR2	(25)		Bank account type, that is, SAVINGS, or CHECKING
ACCOUNT_SUFFIX	VARCHAR2	(30)		Account suffix
DESCRIPTION	VARCHAR2	(240)		Description
AGENCY_LOCATION_CODE	VARCHAR2	(30)		Agency location code
PAYMENT_FACTOR_FLAG	VARCHAR2	(1)		Indicates whether this is a payment factor bank account
FOREIGN_PAYMENT_USE_FLAG	VARCHAR2	(1)		Flag that indicates whether to use this bank account for foreign payment
EXCHANGE_RATE_AGREEMENT_NUM	VARCHAR2	(80)		Exchange rate agreement number
EXCHANGE_RATE_AGREEMENT_TYPE	VARCHAR2	(80)		Exchange rate agreement type
EXCHANGE_RATE	NUMBER			Exchange rate
START_DATE	DATE			Start date
END_DATE	DATE			End date
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield structure defining column
NOTE	VARCHAR2	(240)		Note
NOTE_ALT	VARCHAR2	(240)		Alternative note
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
STATUS	VARCHAR2	(30)		Status of the bank account approval process
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Current Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Current Who column
PROGRAM_ID	NUMBER	(15)		Current Who column
PROGRAM_UPDATE_DATE	DATE			Current Who column
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object version number
CALLING_APP_UNIQUE_REF1	VARCHAR2	(100)		First unique identifier of the owner in the source product
CALLING_APP_UNIQUE_REF2	VARCHAR2	(100)		Second unique identifier of the owner in the source product
EXT_PAYEE_ID	NUMBER	(15)		Payee to whom the bank account should be assigned
CONTACT_NAME	VARCHAR2	(60)		Contact name
CONTACT_PHONE	VARCHAR2	(30)		Contact phone number
CONTACT_FAX	VARCHAR2	(30)		Contact fax number
CONTACT_EMAIL	VARCHAR2	(80)		Contact Email address

Query Text

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


SELECT TEMP_EXT_BANK_ACCT_ID
,      EXT_BANK_ACCOUNT_ID
,      COUNTRY_CODE
,      BRANCH_ID
,      BANK_ID
,      BANK_NAME
,      BANK_NUMBER
,      BANK_NAME_ALT
,      BANK_INSTITUTION_TYPE
,      BANK_ADDRESS_ID
,      BRANCH_NUMBER
,      BRANCH_TYPE
,      BRANCH_NAME
,      BRANCH_NAME_ALT
,      BIC
,      RFC_IDENTIFIER
,      BANK_CODE
,      BRANCH_ADDRESS_ID
,      ACCOUNT_OWNER_PARTY_ID
,      OWNER_PRIMARY_FLAG
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      CURRENCY_CODE
,      IBAN
,      CHECK_DIGITS
,      BANK_ACCOUNT_NAME_ALT
,      BANK_ACCOUNT_TYPE
,      ACCOUNT_SUFFIX
,      DESCRIPTION
,      AGENCY_LOCATION_CODE
,      PAYMENT_FACTOR_FLAG
,      FOREIGN_PAYMENT_USE_FLAG
,      EXCHANGE_RATE_AGREEMENT_NUM
,      EXCHANGE_RATE_AGREEMENT_TYPE
,      EXCHANGE_RATE
,      START_DATE
,      END_DATE
,      ATTRIBUTE_CATEGORY
,      NOTE
,      NOTE_ALT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      CALLING_APP_UNIQUE_REF1
,      CALLING_APP_UNIQUE_REF2
,      EXT_PAYEE_ID
,      CONTACT_NAME
,      CONTACT_PHONE
,      CONTACT_FAX
,      CONTACT_EMAIL
FROM IBY.IBY_TEMP_EXT_BANK_ACCTS;

Dependencies

[top of page]

IBY.IBY_TEMP_EXT_BANK_ACCTS does not reference any database object

IBY.IBY_TEMP_EXT_BANK_ACCTS is referenced by following:

IBY: IBY_TEMP_EXT_BANK_ACCTS#