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

TABLE: XTR.XTR_DEALER_CODES

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


XTR_DEALER_CODES contains basic dealer information such as the dealer code and name. Each dealer is associated with one unique Oracle user. Dealers are linked to authorities for creating deals, accessing companies, and handling specific deal types, deal subtypes, and product types.
This table corresponds to the Treasury User Details region in the User Access Details window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_DEALDER_CODES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEALER_CODE
XTR_DEALER_CODES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
Columns
Name Datatype Length Mandatory Comments
DEALER_CODE VARCHAR2 (10) Yes Code for Treasury users
DEALER_USER_NAME VARCHAR2 (240)
Name for Treasury users
USER_ID NUMBER
Yes Treasury user identifier
UPDATED_BY NUMBER

User who last updated this record
UPDATED_ON DATE

Date this record was last updated
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
CREATED_BY VARCHAR2 (30) Yes User who created this record
CREATED_ON DATE
Yes Date this record was created
ALLOW_OVERRIDE VARCHAR2 (1)
Not currently used
Query Text

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


SELECT DEALER_CODE
,      DEALER_USER_NAME
,      USER_ID
,      UPDATED_BY
,      UPDATED_ON
,      AUDIT_INDICATOR
,      CREATED_BY
,      CREATED_ON
,      ALLOW_OVERRIDE
FROM XTR.XTR_DEALER_CODES;

Dependencies

[top of page]

XTR.XTR_DEALER_CODES does not reference any database object

XTR.XTR_DEALER_CODES is referenced by following:

SchemaAPPS
TriggerXTR_AU_DEALER_CODES_T
SynonymXTR_DEALER_CODES