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: POS.POS_SUP_BANK_ACCOUNT_REQUESTS

Object Details

Object Name:	POS_SUP_BANK_ACCOUNT_REQUESTS
Object Type:	TABLE
Owner:	POS
FND Design Data:	POS.POS_SUP_BANK_ACCOUNT_REQUESTS
Subobject Name:
Status:	VALID

This tables stores supplier bank account requests in release 11.5.10. It is no longer used in release 12.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POS_SUP_BANK_ACCOUNT_REQ_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_ID
POS_SUP_BANK_ACCOUNT_REQ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
POS_SUP_BANK_ACCOUNT_REQ_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE BANK_ACCOUNT_NUMBER
POS_SUP_BANK_ACCOUNT_REQ_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_STATUS
POS_SUP_BANK_ACCOUNT_REQ_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_BRANCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Request identifier
REQUEST_STATUS	VARCHAR2	(20)	Yes	Request status
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
VENDOR_ID	NUMBER		Yes	Vendor identifier
BANK_BRANCH_ID	NUMBER			Bank branch identifier
BANK_NAME	VARCHAR2	(60)	Yes	Bank name
BANK_BRANCH_NAME	VARCHAR2	(60)	Yes	Bank branch name
BANK_NUMBER	VARCHAR2	(30)		Bank number
BANK_BRANCH_NUMBER	VARCHAR2	(25)		Bank number
BRANCH_DESCRIPTION	VARCHAR2	(240)		Branch description
ADDRESS_LINE1	VARCHAR2	(35)		Address line 1 of the bank branch
ADDRESS_LINE2	VARCHAR2	(35)		Address line 2 of the bank branch
ADDRESS_LINE3	VARCHAR2	(35)		Address line 3 of the bank branch
ADDRESS_LINE4	VARCHAR2	(35)		Address line 4 of the bank branch
CITY	VARCHAR2	(25)		City of the bank branch
COUNTY	VARCHAR2	(25)		County of the bank branch
STATE	VARCHAR2	(25)		State of the bank branch
ZIP	VARCHAR2	(20)		Zip code of the bank branch
PROVINCE	VARCHAR2	(25)		Province of the bank branch
COUNTRY	VARCHAR2	(25)	Yes	Country of the bank branch
BANK_BRANCH_TYPE	VARCHAR2	(25)		Bank branch type (e.g. ABA)
EFT_SWIFT_CODE	VARCHAR2	(12)		EFT Swift Code
INACTIVE_DATE	DATE			Inactive date of the bank account
BANK_ACCOUNT_NAME	VARCHAR2	(80)	Yes	Bank account name
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Bank account number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
ACCOUNT_DESCRIPTION	VARCHAR2	(240)		Description of the account
CONTACT_FIRST_NAME	VARCHAR2	(15)		First name of the contact person for the account
CONTACT_MIDDLE_NAME	VARCHAR2	(15)		Middle name of the contact person for the account
CONTACT_LAST_NAME	VARCHAR2	(20)		Last name of the contact person for the account
CONTACT_PREFIX	VARCHAR2	(5)		Prefix of the contact person for the account
CONTACT_TITLE	VARCHAR2	(30)		Title of the contact person for the account
CONTACT_AREA_CODE	VARCHAR2	(10)		Area code for the phone number of the contact person
CONTACT_PHONE	VARCHAR2	(15)		Phone number of the contact person for the account
ACCOUNT_TYPE	VARCHAR2	(25)		Account type
CHECK_DIGITS	VARCHAR2	(30)		Check Digits
ACCOUNT_HOLDER_NAME	VARCHAR2	(80)		Name of the account holder
NOTES_FROM_SUPPLIER	VARCHAR2	(2000)		Notes from supplier
NOTES_FROM_BUYER	VARCHAR2	(2000)		Notes to supplier

Query Text

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


SELECT REQUEST_ID
,      REQUEST_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      VENDOR_ID
,      BANK_BRANCH_ID
,      BANK_NAME
,      BANK_BRANCH_NAME
,      BANK_NUMBER
,      BANK_BRANCH_NUMBER
,      BRANCH_DESCRIPTION
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      COUNTY
,      STATE
,      ZIP
,      PROVINCE
,      COUNTRY
,      BANK_BRANCH_TYPE
,      EFT_SWIFT_CODE
,      INACTIVE_DATE
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUMBER
,      CURRENCY_CODE
,      ACCOUNT_DESCRIPTION
,      CONTACT_FIRST_NAME
,      CONTACT_MIDDLE_NAME
,      CONTACT_LAST_NAME
,      CONTACT_PREFIX
,      CONTACT_TITLE
,      CONTACT_AREA_CODE
,      CONTACT_PHONE
,      ACCOUNT_TYPE
,      CHECK_DIGITS
,      ACCOUNT_HOLDER_NAME
,      NOTES_FROM_SUPPLIER
,      NOTES_FROM_BUYER
FROM POS.POS_SUP_BANK_ACCOUNT_REQUESTS;

Dependencies

[top of page]

POS.POS_SUP_BANK_ACCOUNT_REQUESTS does not reference any database object

POS.POS_SUP_BANK_ACCOUNT_REQUESTS is referenced by following:

POS: POS_SUP_BANK_ACCOUNT_REQUESTS#