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_ACCT_ADDR_REL

Object Details

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

This table stores the assignment (or usage) of supplier bank accounts to supplier addresses. A bank account can be assigned to all addresses of the supplier, or only to some specific addresses. If the value in the column RELATIONSHIP_TYPE is SUPPLIER, it indicates that the account is assigned to all addresses of the supplier; if the value is ADDRESS, it indicates that the account is assigned to the specific address indentified by the value in column ADDRESS_ID. Column ADDRESS_ID stores the PARTY_SITE_ID for the supplier address.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POS_ACCT_ADDR_REL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
POS_ACCT_ADDR_REL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE BANK_ACCOUNT_NUMBER
POS_ACCT_ADDR_REL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
POS_ACCT_ADDR_REL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_BRANCH_ID
POS_ACCT_ADDR_REL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_TYPE
POS_ACCT_ADDR_REL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS_ID
POS_ACCT_ADDR_REL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TYPE
POS_ACCT_ADDR_REL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIMARY_FLAG
POS_ACCT_ADDR_REL_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RELATIONSHIP_ID	NUMBER		Yes	Relationship ID
RELATIONSHIP_TYPE	VARCHAR2	(20)	Yes	Relationship Type
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 ID
STATUS	VARCHAR2	(20)	Yes	Status
PARENT_TYPE	VARCHAR2	(20)	Yes	Parent Type
END_ACTIVE_DATE	DATE			End active date
START_ACTIVE_DATE	DATE			Start active date
BANK_BRANCH_ID	NUMBER			Bank Branch ID
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Bank Account Number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
PRIMARY_FLAG	VARCHAR2	(1)	Yes	Primary Flag
REQUEST_ID	NUMBER			Request ID
ADDRESS_ID	NUMBER			Address ID

Query Text

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


SELECT RELATIONSHIP_ID
,      RELATIONSHIP_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      VENDOR_ID
,      STATUS
,      PARENT_TYPE
,      END_ACTIVE_DATE
,      START_ACTIVE_DATE
,      BANK_BRANCH_ID
,      BANK_ACCOUNT_NUMBER
,      CURRENCY_CODE
,      PRIMARY_FLAG
,      REQUEST_ID
,      ADDRESS_ID
FROM POS.POS_ACCT_ADDR_REL;

Dependencies

[top of page]

POS.POS_ACCT_ADDR_REL does not reference any database object

POS.POS_ACCT_ADDR_REL is referenced by following:

POS: POS_ACCT_ADDR_REL#