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

TABLE: XTR.XTR_SETTLEMENT_CONTACTS

Object Details
Object Name: XTR_SETTLEMENT_CONTACTS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_SETTLEMENT_CONTACTS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_NUMBER VARCHAR2 (20)
Settlement account number.
ADDRESS_1 VARCHAR2 (50)
Address line 1.
ADDRESS_2 VARCHAR2 (50)
Address line 2.
ADDRESS_3 VARCHAR2 (50)
Address line 3.
ADDRESS_4 VARCHAR2 (50)
Address line 4.
ADDRESS_5 VARCHAR2 (50)
Address line 5.
ADDRESS_6 VARCHAR2 (50)
Address line 6.
CONTACT_NAME VARCHAR2 (50) Yes
CURRENCY VARCHAR2 (15) Yes
EMAIL_ADDRESS VARCHAR2 (40)
FAX_NUMBER VARCHAR2 (15)
PARTY_CODE VARCHAR2 (7) Yes
PHONE_NUMBER VARCHAR2 (15)
TELEX_NUMBER VARCHAR2 (15)
TITLE_DESCRIPTION VARCHAR2 (15)
BANK_ACCT_USE_ID NUMBER (15)
Query Text

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


SELECT ACCOUNT_NUMBER
,      ADDRESS_1
,      ADDRESS_2
,      ADDRESS_3
,      ADDRESS_4
,      ADDRESS_5
,      ADDRESS_6
,      CONTACT_NAME
,      CURRENCY
,      EMAIL_ADDRESS
,      FAX_NUMBER
,      PARTY_CODE
,      PHONE_NUMBER
,      TELEX_NUMBER
,      TITLE_DESCRIPTION
,      BANK_ACCT_USE_ID
FROM XTR.XTR_SETTLEMENT_CONTACTS;

Dependencies

[top of page]

XTR.XTR_SETTLEMENT_CONTACTS does not reference any database object

XTR.XTR_SETTLEMENT_CONTACTS is referenced by following:

SchemaXTR
ViewXTR_SETTLEMENT_CONTACTS#