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

TABLE: XTR.XTR_A_EXPOSURE_TYPES

Object Details
Object Name: XTR_A_EXPOSURE_TYPES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_A_EXPOSURE_TYPES
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:
Indexes
Index Type Uniqueness Tablespace Column
XTR_A_EXPOSURE_TYPES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPDATED_ON
XTR_A_EXPOSURE_TYPES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXPOSURE_TYPE
Columns
Name Datatype Length Mandatory Comments
AUDIT_DATE_STORED DATE

Date on which this record is audited.
AUDIT_INDICATOR VARCHAR2 (1)
BALANCE_SHEET_EXPOSURE VARCHAR2 (1)
COMPANY_CODE VARCHAR2 (7) Yes Company identifier. Foreign key to XTR_PARTIES_V.
EXPOSURE_TYPE VARCHAR2 (10) Yes
FREQUENCY NUMBER

CODE_COMBINATION_ID NUMBER (15)
LAST_DOWNLOAD_DATE DATE

NAME VARCHAR2 (80) Yes
TAX_BROKERAGE_TYPE VARCHAR2 (1)
TAX_OR_BROKERAGE VARCHAR2 (1)
UPDATED_BY VARCHAR2 (30)
Last updated user.
UPDATED_ON DATE

Last updated date.
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
Query Text

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


SELECT AUDIT_DATE_STORED
,      AUDIT_INDICATOR
,      BALANCE_SHEET_EXPOSURE
,      COMPANY_CODE
,      EXPOSURE_TYPE
,      FREQUENCY
,      CODE_COMBINATION_ID
,      LAST_DOWNLOAD_DATE
,      NAME
,      TAX_BROKERAGE_TYPE
,      TAX_OR_BROKERAGE
,      UPDATED_BY
,      UPDATED_ON
,      CREATED_BY
,      CREATED_ON
FROM XTR.XTR_A_EXPOSURE_TYPES;

Dependencies

[top of page]

XTR.XTR_A_EXPOSURE_TYPES does not reference any database object

XTR.XTR_A_EXPOSURE_TYPES is referenced by following:

SchemaXTR
ViewXTR_A_EXPOSURE_TYPES#