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

TABLE: XTR.XTR_PRINTED_FILE_DETAILS

Object Details
Object Name: XTR_PRINTED_FILE_DETAILS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_PRINTED_FILE_DETAILS
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
FILE_NAME VARCHAR2 (100) Yes
DEAL_NO NUMBER

Deal identifier. Foreign key to XTR_DEALS.
DEAL_TYPE VARCHAR2 (7)
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.
TRANSACTION_NO NUMBER

CPARTY_CODE VARCHAR2 (7)
Counterparty identifier. Foreign key to XTR_PARTIES_V.
USER_CODE VARCHAR2 (20)
CREATED_ON DATE

Date on which this record is created.
REPORT_GROUP VARCHAR2 (20)
REPORT_NOS VARCHAR2 (8)
VERSION_NUM NUMBER

CONFO_YN VARCHAR2 (1)
REPORT_STATUS VARCHAR2 (20)
REPORT_STARTED DATE

REPORT_FINISHED DATE

PARAMETER_VALUES VARCHAR2 (2000)
TEMPLATE_TYPE VARCHAR2 (50)
Query Text

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


SELECT FILE_NAME
,      DEAL_NO
,      DEAL_TYPE
,      TRANSACTION_NO
,      CPARTY_CODE
,      USER_CODE
,      CREATED_ON
,      REPORT_GROUP
,      REPORT_NOS
,      VERSION_NUM
,      CONFO_YN
,      REPORT_STATUS
,      REPORT_STARTED
,      REPORT_FINISHED
,      PARAMETER_VALUES
,      TEMPLATE_TYPE
FROM XTR.XTR_PRINTED_FILE_DETAILS;

Dependencies

[top of page]

XTR.XTR_PRINTED_FILE_DETAILS does not reference any database object

XTR.XTR_PRINTED_FILE_DETAILS is referenced by following:

SchemaXTR
ViewXTR_PRINTED_FILE_DETAILS#