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_TEMPLATE_LINE

Object Details

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

XTR_LAYOUT_TEMPLATE_LINE contains the text for each line of your confirmation letter templates. Each row corresponds to one row of text in a confirmation letter template and includes any common variables that appear in that row. Once you complete the confirmation letter template details and select make a template, Treasury takes the rows for that template from this table and combines them with the SQL select statement for the same template (from the XTR_LAYOUT_WHERE_CLAUSE table) to create the template view.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CODED_TEXT	VARCHAR2	(2000)		Template line text in SQL coded format
FIELD_FORMAT	VARCHAR2	(25)		Not currently used
FIELD_NAME	VARCHAR2	(50)	Yes	Name of the template line
FIELD_SIZE	NUMBER			Not currently used
FIELD_TITLE	VARCHAR2	(50)		Not currently used
FIELD_TYPE	VARCHAR2	(15)		Not currently used
GRP_MARK	VARCHAR2	(1)		Not currently used
ORDER_NO	NUMBER	(3)	Yes	Number that determines the order of the template line
PREVIEW_TEXT	VARCHAR2	(255)		No currently used
PRT_MARK	VARCHAR2	(1)		Not currently used
SUM_MARK	VARCHAR2	(1)		Not currently used
TEMPLATE_NAME	VARCHAR2	(24)	Yes	Not currently used
USER_TEXT	VARCHAR2	(255)		Template line text

Query Text

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


SELECT CODED_TEXT
,      FIELD_FORMAT
,      FIELD_NAME
,      FIELD_SIZE
,      FIELD_TITLE
,      FIELD_TYPE
,      GRP_MARK
,      ORDER_NO
,      PREVIEW_TEXT
,      PRT_MARK
,      SUM_MARK
,      TEMPLATE_NAME
,      USER_TEXT
FROM XTR.XTR_LAYOUT_TEMPLATE_LINE;

Dependencies

[top of page]

XTR.XTR_LAYOUT_TEMPLATE_LINE does not reference any database object

XTR.XTR_LAYOUT_TEMPLATE_LINE is referenced by following:

APPS: XTR_LAYOUT_TEMPLATE_LINE