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

TABLE: XTR.XTR_A_PRODUCT_TYPES

Object Details
Object Name: XTR_A_PRODUCT_TYPES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_A_PRODUCT_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_PRODUCT_TYPES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPDATED_ON
Columns
Name Datatype Length Mandatory Comments
AUDIT_DATE_STORED DATE

Date on which this record is audited.
AUDIT_INDICATOR VARCHAR2 (1)
CALC_BASIS VARCHAR2 (8)
CLIENT_ADVICE VARCHAR2 (1)
Indicates if confirmation advice letter is required for the client. Valid values are: Y (requried) or N (not requried).
CPARTY_ADVICE VARCHAR2 (1)
DEAL_TYPE VARCHAR2 (7) Yes Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
PRODUCT_AUTH VARCHAR2 (1) Yes
PRODUCT_DESC VARCHAR2 (80) Yes
PRODUCT_TYPE VARCHAR2 (10) Yes Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
REVAL_CROSS_REF VARCHAR2 (20)
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
,      CALC_BASIS
,      CLIENT_ADVICE
,      CPARTY_ADVICE
,      DEAL_TYPE
,      PRODUCT_AUTH
,      PRODUCT_DESC
,      PRODUCT_TYPE
,      REVAL_CROSS_REF
,      UPDATED_BY
,      UPDATED_ON
,      CREATED_BY
,      CREATED_ON
FROM XTR.XTR_A_PRODUCT_TYPES;

Dependencies

[top of page]

XTR.XTR_A_PRODUCT_TYPES does not reference any database object

XTR.XTR_A_PRODUCT_TYPES is referenced by following:

SchemaAPPS
SynonymXTR_A_PRODUCT_TYPES