eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: XTR.XTR_LAYOUT_WHERE_CLAUSE

Object Details

Object Name:	XTR_LAYOUT_WHERE_CLAUSE
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_LAYOUT_WHERE_CLAUSE
Subobject Name:
Status:	VALID

XTR_LAYOUT_WHERE_CLAUSE contains the SQL select statement and the where clause for each confirmation letter template type. SQL select statements are used to creating the view for the confirmation letter template type. The where clauses are used to filter confirmation letters using deal numbers, transaction numbers, or interest rate swap references.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_LAYOUT_WHERE_CLAUSE_U1	NORMAL	UNIQUE	APPS_TS_SEED	ACTION_TYPE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_TYPE	VARCHAR2	(50)	Yes	Deal action type
CLAUSE_TEXT	VARCHAR2	(2000)		SQL select statement used in creating the view for the template type
CLIENT_OR_CPARTY_LETTER	VARCHAR2	(2)	Yes	Flag to indicate if a confirmation is a client (C) or counterparty letter (CP)
COMMENTS	VARCHAR2	(500)		Not currently used
CONFO_OR_VIEW	VARCHAR2	(1)		Flag to indicate if the confirmation (C) or view (F) template. Treasury currently supports only confirmation templates.
CURRENT_TEMPLATE_DEFAULT	VARCHAR2	(50)		Not currently used
SELECT_CLAUSE_TEXT	VARCHAR2	(2000)		Not currently used
SIGNED_OFF	VARCHAR2	(1)		Not currently used (indicates if this template is authorized)
TEMPLATE_CREATED	VARCHAR2	(1)		Not currently used
TEMPLATE_TYPE	VARCHAR2	(50)	Yes	Template type
VIEW_SUBSECTION	NUMBER			Not currently used
WHERE_CLAUSE_TEXT	VARCHAR2	(2000)		SQL where clause to be used to filter the confirmation letters
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ACTION_TYPE
,      CLAUSE_TEXT
,      CLIENT_OR_CPARTY_LETTER
,      COMMENTS
,      CONFO_OR_VIEW
,      CURRENT_TEMPLATE_DEFAULT
,      SELECT_CLAUSE_TEXT
,      SIGNED_OFF
,      TEMPLATE_CREATED
,      TEMPLATE_TYPE
,      VIEW_SUBSECTION
,      WHERE_CLAUSE_TEXT
,      ZD_EDITION_NAME
FROM XTR.XTR_LAYOUT_WHERE_CLAUSE;

Dependencies

[top of page]

XTR.XTR_LAYOUT_WHERE_CLAUSE does not reference any database object

XTR.XTR_LAYOUT_WHERE_CLAUSE is referenced by following:

XTR: XTR_LAYOUT_WHERE_CLAUSE#