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

TABLE: XTR.XTR_LAYOUT_VALUES

Object Details
Object Name: XTR_LAYOUT_VALUES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_LAYOUT_VALUES
Subobject Name:
Status: VALID


XTR_LAYOUT_VALUES contains the common variables (or columns from which the values will derive from) for your confirmation letter templates. Each row corresponds to a variable (column) of a template type, and includes the column name, description, data type, and length.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_LAYOUT_VALUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTEMPLATE_TYPE
ColumnFIELD_NAME
XTR_LAYOUT_VALUES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTEMPLATE_TYPE
ColumnDESCRIPTION
Columns
Name Datatype Length Mandatory Comments
COL_VALUE VARCHAR2 (200) Yes Column (common variable) name in SQL text format
DESCRIPTION VARCHAR2 (100) Yes Column (common variable) description
FIELD_FORMAT VARCHAR2 (25)
Format mask for the column (common variable)
FIELD_NAME VARCHAR2 (50) Yes Column (common variable) name
FIELD_TYPE VARCHAR2 (15)
Column (common variable) data type
LENGTH NUMBER
Yes Data length of the column (common variable)
TEMPLATE_TYPE VARCHAR2 (50) Yes Template type
VIEW_SUBSECTION NUMBER

Not currently used
Query Text

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


SELECT COL_VALUE
,      DESCRIPTION
,      FIELD_FORMAT
,      FIELD_NAME
,      FIELD_TYPE
,      LENGTH
,      TEMPLATE_TYPE
,      VIEW_SUBSECTION
FROM XTR.XTR_LAYOUT_VALUES;

Dependencies

[top of page]

XTR.XTR_LAYOUT_VALUES does not reference any database object

XTR.XTR_LAYOUT_VALUES is referenced by following:

SchemaAPPS
SynonymXTR_LAYOUT_VALUES