Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - XDO Tables and Views

TABLE - XDO.XDO_CONCURRENT_REQUESTS_GT
TABLE - XDO.XDO_CONFIG_KEYS
TABLE - XDO.XDO_CONFIG_PROPERTIES_B
TABLE - XDO.XDO_CONFIG_PROPERTIES_TL
TABLE - XDO.XDO_CONFIG_VALUES
TABLE - XDO.XDO_CURRENCY_FORMATS
TABLE - XDO.XDO_CURRENCY_FORMAT_SETS_B
TABLE - XDO.XDO_CURRENCY_FORMAT_SETS_TL
TABLE - XDO.XDO_DGF_BLOCK_CONTEXTS
TABLE - XDO.XDO_DGF_RPT_CONTEXTS
TABLE - XDO.XDO_DGF_RPT_CONTEXT_PARAMETERS
TABLE - XDO.XDO_DGF_RULE_CATALOG_B
TABLE - XDO.XDO_DGF_RULE_CATALOG_TL
TABLE - XDO.XDO_DGF_TPL_CONTEXTS
TABLE - XDO.XDO_DGF_TPL_RULES
TABLE - XDO.XDO_DS_DEFINITIONS_B
TABLE - XDO.XDO_DS_DEFINITIONS_TL
TABLE - XDO.XDO_EFT_SEQUENCE_NAMES
TABLE - XDO.XDO_FONT_MAPPINGS
TABLE - XDO.XDO_FONT_MAPPING_SETS_B
TABLE - XDO.XDO_FONT_MAPPING_SETS_TL
TABLE - XDO.XDO_LOBS
TABLE - XDO.XDO_TEMPLATES_B
TABLE - XDO.XDO_TEMPLATES_TL
TABLE - XDO.XDO_TEMPLATE_FIELDS
TABLE - XDO.XDO_TRANS_UNITS
TABLE - XDO.XDO_TRANS_UNIT_PROPS
TABLE - XDO.XDO_TRANS_UNIT_VALUES
VIEW - APPS.XDO_CONFIG_PROPERTIES_VL
VIEW - APPS.XDO_CURRENCY_FORMAT_SETS_VL
VIEW - APPS.XDO_DS_DEFINITIONS_VL
VIEW - APPS.XDO_FONT_MAPPING_SETS_VL
VIEW - APPS.XDO_TEMPLATES_VL

Table: XDO_CONCURRENT_REQUESTS_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CONC_REQUEST_ID NUMBER

[top of page]

XDO.XDO_CONCURRENT_REQUESTS_GT does not reference any database object

XDO.XDO_CONCURRENT_REQUESTS_GT is referenced by following:

APPS
SYNONYM - XDO_CONCURRENT_REQUESTS_GT

[top of page]

Table: XDO_CONFIG_KEYS

Description: XDO_CONFIG_KEYS table is used to store the encryption keys for certain values stored in XDO_CONFIG_VALUES.
Primary Key: XDO_CONFIG_KEYS_PK
  1. VALUE_ID
Comments

XDO_CONFIG_KEYS table is used to store the encryption keys for certain values stored in XDO_CONFIG_VALUES.

Columns
Name Datatype Length Mandatory Comments
VALUE_ID NUMBER
Y
VALUE_KEY RAW (20)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_CONFIG_KEYS does not reference any database object

XDO.XDO_CONFIG_KEYS is referenced by following:

XDO
VIEW - XDO_CONFIG_KEYS#

[top of page]

Table: XDO_CONFIG_PROPERTIES_B

Description: XDO_CONFIG_PROPERTIES_B table stores the XML Publisher configuration properties that are accessible from the OA Framework interface.
Primary Key: XDO_CONFIG_PROPERTIES_B_PK
  1. PROPERTY_CODE
Comments

XDO_CONFIG_PROPERTIES_B table stores the XML Publisher configuration properties that are accessible from the OA Framework interface.

Columns
Name Datatype Length Mandatory Comments
PROPERTY_CODE VARCHAR2 (100) Y
CATEGORY VARCHAR2 (50) Y
XDO_CFG_NAME VARCHAR2 (100) Y
LOOKUP_TYPE VARCHAR2 (50)
SORT_ORDER NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_CONFIG_PROPERTIES_B does not reference any database object

XDO.XDO_CONFIG_PROPERTIES_B is referenced by following:

XDO
VIEW - XDO_CONFIG_PROPERTIES_B#

[top of page]

Table: XDO_CONFIG_PROPERTIES_TL

Description:
Primary Key: XDO_CONFIG_PROPERTIES_TL_PK
  1. PROPERTY_CODE
  2. LANGUAGE
Comments

XDO_CONFIG_PROPERTIES_TL is a translation table for XDO_CONFIG_PROPERTIES_B.

Columns
Name Datatype Length Mandatory Comments
PROPERTY_CODE VARCHAR2 (100) Y
LANGUAGE VARCHAR2 (4) Y
PROPERTY_NAME VARCHAR2 (120) Y
SOURCE_LANG VARCHAR2 (4) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_CONFIG_PROPERTIES_TL does not reference any database object

XDO.XDO_CONFIG_PROPERTIES_TL is referenced by following:

XDO
VIEW - XDO_CONFIG_PROPERTIES_TL#

[top of page]

Table: XDO_CONFIG_VALUES

Description: XDO_CONFIG_VALUES stores the values of XML Publisher configuration properties entered from the Oracle Applications interface.
Primary Key: XDO_CONFIG_VALUES_PK
  1. VALUE_ID
Comments

XDO_CONFIG_VALUES stores the values of XML Publisher configuration properties entered from the Oracle Applications interface.

Columns
Name Datatype Length Mandatory Comments
VALUE_ID NUMBER
Y
PROPERTY_CODE VARCHAR2 (50) Y
CONFIG_LEVEL NUMBER
Y
APPLICATION_SHORT_NAME VARCHAR2 (50)
DATA_SOURCE_CODE VARCHAR2 (80)
TEMPLATE_CODE VARCHAR2 (80)
VALUE VARCHAR2 (240)
BVALUE RAW (2000)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_CONFIG_VALUES does not reference any database object

XDO.XDO_CONFIG_VALUES is referenced by following:

XDO
VIEW - XDO_CONFIG_VALUES#

[top of page]

Table: XDO_CURRENCY_FORMATS

Description: XDO_CURRENCY_FORMATS stores the format masks for various currencies. A collection of these formats forms a currency format set.
Primary Key: XDO_CURRENCY_FORMATS_PK
  1. CURRENCY_CODE
  2. FORMAT_SET_CODE
Comments

XDO_CURRENCY_FORMATS stores the format masks for various currencies. A collection of these formats forms a currency format set.

Columns
Name Datatype Length Mandatory Comments
FORMAT_SET_CODE VARCHAR2 (80) Y
CURRENCY_CODE VARCHAR2 (15) Y
FORMAT_MASK VARCHAR2 (40)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_CURRENCY_FORMATS does not reference any database object

XDO.XDO_CURRENCY_FORMATS is referenced by following:

XDO
VIEW - XDO_CURRENCY_FORMATS#

[top of page]

Table: XDO_CURRENCY_FORMAT_SETS_B

Description:
Primary Key: XDO_CURRENCY_FORMAT_SETS_B_PK
  1. FORMAT_SET_CODE
Comments
Columns
Name Datatype Length Mandatory Comments
FORMAT_SET_CODE VARCHAR2 (80) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_CURRENCY_FORMAT_SETS_B does not reference any database object

XDO.XDO_CURRENCY_FORMAT_SETS_B is referenced by following:

XDO
VIEW - XDO_CURRENCY_FORMAT_SETS_B#

[top of page]

Table: XDO_CURRENCY_FORMAT_SETS_TL

Description:
Primary Key: XDO_CURRENCY_FORMAT_SETS_TL_PK
  1. FORMAT_SET_CODE
  2. LANGUAGE
Comments
Columns
Name Datatype Length Mandatory Comments
FORMAT_SET_CODE VARCHAR2 (80) Y
LANGUAGE VARCHAR2 (4) Y
FORMAT_SET_NAME VARCHAR2 (120) Y
SOURCE_LANG VARCHAR2 (4)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_CURRENCY_FORMAT_SETS_TL does not reference any database object

XDO.XDO_CURRENCY_FORMAT_SETS_TL is referenced by following:

XDO
VIEW - XDO_CURRENCY_FORMAT_SETS_TL#

[top of page]

Table: XDO_DGF_BLOCK_CONTEXTS

Description:
Comments
Unique Key: XDO_DGF_BLOCK_CONTEXTS_U1
  1. BLOCK_CONTEXT_ID
Unique Key: XDO_DGF_BLOCK_CONTEXTS_U2
  1. FORM_NAME
  2. BLOCK_NAME
Indexes
Index Type Tablespace Column
XDO_DGF_BLOCK_CONTEXTS_U1 UNIQUE APPS_TS_TX_IDX BLOCK_CONTEXT_ID
XDO_DGF_BLOCK_CONTEXTS_U2 UNIQUE APPS_TS_TX_IDX FORM_NAME
BLOCK_NAME
Columns
Name Datatype Length Mandatory Comments
BLOCK_CONTEXT_ID NUMBER
Y
FORM_NAME VARCHAR2 (256) Y
BLOCK_NAME VARCHAR2 (256) Y
FORM_CODE VARCHAR2 (256) Y
BLOCK_CODE VARCHAR2 (256) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

XDO.XDO_DGF_BLOCK_CONTEXTS does not reference any database object

XDO.XDO_DGF_BLOCK_CONTEXTS is referenced by following:

XDO
VIEW - XDO_DGF_BLOCK_CONTEXTS#

[top of page]

Table: XDO_DGF_RPT_CONTEXTS

Description:
Comments
Unique Key: XDO_DGF_RPT_CONTEXTS_U1
  1. REPORT_CONTEXT_ID
Unique Key: XDO_DGF_RPT_CONTEXTS_U2
  1. BLOCK_CONTEXT_ID
  2. REPORT_CODE
  3. REPORT_APPLICATION
Indexes
Index Type Tablespace Column
XDO_DGF_RPT_CONTEXTS_U1 UNIQUE APPS_TS_TX_IDX REPORT_CONTEXT_ID
XDO_DGF_RPT_CONTEXTS_U2 UNIQUE APPS_TS_TX_IDX BLOCK_CONTEXT_ID
REPORT_CODE
REPORT_APPLICATION
Columns
Name Datatype Length Mandatory Comments
REPORT_CONTEXT_ID NUMBER (10) Y
BLOCK_CONTEXT_ID NUMBER
Y
REPORT_CODE VARCHAR2 (80) Y
REPORT_APPLICATION VARCHAR2 (20) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

XDO.XDO_DGF_RPT_CONTEXTS does not reference any database object

XDO.XDO_DGF_RPT_CONTEXTS is referenced by following:

XDO
VIEW - XDO_DGF_RPT_CONTEXTS#

[top of page]

Table: XDO_DGF_RPT_CONTEXT_PARAMETERS

Description:
Comments
Unique Key: XDO_DGF_RPT_CONTEXT_PARAM_U1
  1. REPORT_CONTEXT_PARAMETER_ID
Indexes
Index Type Tablespace Column
XDO_DGF_RPT_CONTEXT_PARAM_U1 UNIQUE APPS_TS_TX_IDX REPORT_CONTEXT_PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_CONTEXT_PARAMETER_ID NUMBER
Y
REPORT_CONTEXT_ID NUMBER (10) Y
PARAMETER_SEQUENCE NUMBER (30) Y
PARAMETER_TYPE VARCHAR2 (1) Y
PARAMETER_NAME VARCHAR2 (100) Y
PARAMETER_VALUE VARCHAR2 (500) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

XDO.XDO_DGF_RPT_CONTEXT_PARAMETERS does not reference any database object

XDO.XDO_DGF_RPT_CONTEXT_PARAMETERS is referenced by following:

XDO
VIEW - XDO_DGF_RPT_CONTEXT_PARAMETER#

[top of page]

Table: XDO_DGF_RULE_CATALOG_B

Description:
Comments
Unique Key: XDO_DGF_RULE_CATALOG_B_U1
  1. RULE_CATALOG_ID
Indexes
Index Type Tablespace Column
XDO_DGF_RULE_CATALOG_B_U1 UNIQUE APPS_TS_TX_IDX RULE_CATALOG_ID
Columns
Name Datatype Length Mandatory Comments
RULE_CATALOG_ID NUMBER
Y
RULE_SHORT_NAME VARCHAR2 (20) Y
RULE_TYPE VARCHAR2 (1) Y
RULE_VARIABLE VARCHAR2 (500)
RULE_OPERATOR VARCHAR2 (4) Y
RULE_VALUES_DATATYPE VARCHAR2 (1) Y
BLOCK_CONTEXT_ID NUMBER
Y
DB_FUNCTION VARCHAR2 (80)
ARG_NUMBER NUMBER

ARG01 VARCHAR2 (2000)
ARG02 VARCHAR2 (2000)
ARG03 VARCHAR2 (2000)
ARG04 VARCHAR2 (2000)
ARG05 VARCHAR2 (2000)
ARG06 VARCHAR2 (2000)
ARG07 VARCHAR2 (2000)
ARG08 VARCHAR2 (2000)
ARG09 VARCHAR2 (2000)
ARG10 VARCHAR2 (2000)
ARG01_TYPE VARCHAR2 (1)
ARG02_TYPE VARCHAR2 (1)
ARG03_TYPE VARCHAR2 (1)
ARG04_TYPE VARCHAR2 (1)
ARG05_TYPE VARCHAR2 (1)
ARG06_TYPE VARCHAR2 (1)
ARG07_TYPE VARCHAR2 (1)
ARG08_TYPE VARCHAR2 (1)
ARG09_TYPE VARCHAR2 (1)
ARG10_TYPE VARCHAR2 (1)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

XDO.XDO_DGF_RULE_CATALOG_B does not reference any database object

XDO.XDO_DGF_RULE_CATALOG_B is referenced by following:

XDO
VIEW - XDO_DGF_RULE_CATALOG_B#

[top of page]

Table: XDO_DGF_RULE_CATALOG_TL

Description:
Comments
Unique Key: XDO_DGF_RULE_CATALOG_TL_U1
  1. RULE_CATALOG_ID
  2. LANGUAGE
Indexes
Index Type Tablespace Column
XDO_DGF_RULE_CATALOG_TL_U1 UNIQUE APPS_TS_TX_IDX RULE_CATALOG_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
RULE_CATALOG_ID NUMBER
Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4)
RULE_VALUES VARCHAR2 (4000)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
RULE_DESCRIPTION VARCHAR2 (2000)

[top of page]

XDO.XDO_DGF_RULE_CATALOG_TL does not reference any database object

XDO.XDO_DGF_RULE_CATALOG_TL is referenced by following:

XDO
VIEW - XDO_DGF_RULE_CATALOG_TL#

[top of page]

Table: XDO_DGF_TPL_CONTEXTS

Description:
Comments
Unique Key: XDO_DGF_TPL_CONTEXTS_U1
  1. TEMPLATE_CONTEXT_ID
Indexes
Index Type Tablespace Column
XDO_DGF_TPL_CONTEXTS_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_CONTEXT_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_CONTEXT_ID NUMBER
Y
REPORT_CONTEXT_ID NUMBER (10) Y
TEMPLATE_CODE VARCHAR2 (80) Y
PDF_ALLOWED VARCHAR2 (1)
RTF_ALLOWED VARCHAR2 (1)
HTM_ALLOWED VARCHAR2 (1)
XLS_ALLOWED VARCHAR2 (1)
TXT_ALLOWED VARCHAR2 (1)
TEMPLATE_APPLICATION VARCHAR2 (20) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

XDO.XDO_DGF_TPL_CONTEXTS does not reference any database object

XDO.XDO_DGF_TPL_CONTEXTS is referenced by following:

XDO
VIEW - XDO_DGF_TPL_CONTEXTS#

[top of page]

Table: XDO_DGF_TPL_RULES

Description:
Comments
Unique Key: XDO_DGF_TPL_RULES_U1
  1. TEMPLATE_RULE_ID
Indexes
Index Type Tablespace Column
XDO_DGF_TPL_RULES_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_RULE_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_RULE_ID NUMBER
Y
TEMPLATE_CONTEXT_ID NUMBER
Y
RULE_CATALOG_ID NUMBER
Y
TPL_RULE_DESCRIPTION VARCHAR2 (2000)
FORMAT_FILTER_TYPE VARCHAR2 (3)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIUBTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

XDO.XDO_DGF_TPL_RULES does not reference any database object

XDO.XDO_DGF_TPL_RULES is referenced by following:

XDO
VIEW - XDO_DGF_TPL_RULES#

[top of page]

Table: XDO_DS_DEFINITIONS_B

Description: XDO_DS_DEFINITIONS_B table is a table for storing data source definition represented by XML Schema Definition (XSD). Each data source has one or more elements, and these information are stored in XDO_DS_ELEMENTS_B.
Primary Key: XDO_DS_DEFINITIONS_B_PK
  1. APPLICATION_SHORT_NAME
  2. DATA_SOURCE_CODE
Comments

XDO_DS_DEFINITIONS_B table is a table for storing data source definition represented by XML Schema Definition (XSD). Each data source has one or more elements, and these information are stored in XDO_DS_ELEMENTS_B.

Indexes
Index Type Tablespace Column
XDO_DS_DEFINITIONS_B_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
DATA_SOURCE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Foreign key to fnd_application(APPLICATION_SHORT_NAME)
DATA_SOURCE_CODE VARCHAR2 (80) Y Data source code in template manager
DATA_SOURCE_STATUS VARCHAR2 (1) Y Whether data source is enabled
START_DATE DATE
Y Start effective date
END_DATE DATE

End effective date
OBJECT_VERSION_NUMBER NUMBER (9) Y Version number
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_DS_DEFINITIONS_B does not reference any database object

XDO.XDO_DS_DEFINITIONS_B is referenced by following:

XDO
VIEW - XDO_DS_DEFINITIONS_B#

[top of page]

Table: XDO_DS_DEFINITIONS_TL

Description: XDO_DS_DEFINITIONS_TL is a translation table for XDO_DS_DEFINITIONS_B.
Primary Key: XDO_DS_DEFINITIONS_TL_PK
  1. APPLICATION_SHORT_NAME
  2. DATA_SOURCE_CODE
  3. LANGUAGE
Primary Key: XDO_DS_DEFINITIONS_TL_UK1
  1. APPLICATION_SHORT_NAME
  2. DATA_SOURCE_NAME
  3. LANGUAGE
Comments

XDO_DS_DEFINITIONS_TL is a translation table for XDO_DS_DEFINITIONS_B.

Indexes
Index Type Tablespace Column
XDO_DS_DEFINITIONS_TL_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
DATA_SOURCE_CODE
LANGUAGE
ZD_EDITION_NAME
XDO_DS_DEFINITIONS_TL_U2 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
DATA_SOURCE_NAME
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Foreign key to fnd_application(APPLICATION_SHORT_NAME)
DATA_SOURCE_CODE VARCHAR2 (80) Y Unique developer�s key with application_short_name
LANGUAGE VARCHAR2 (4) Y Language
DATA_SOURCE_NAME VARCHAR2 (120) Y Data source name
DESCRIPTION VARCHAR2 (2000)
Data source description
SOURCE_LANG VARCHAR2 (4) Y Source Language
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_DS_DEFINITIONS_TL does not reference any database object

XDO.XDO_DS_DEFINITIONS_TL is referenced by following:

XDO
VIEW - XDO_DS_DEFINITIONS_TL#

[top of page]

Table: XDO_EFT_SEQUENCE_NAMES

Description:
Comments

XDO_EFT_SEQUENCE_NAMES is a table for storing the names of periodic sequences found in eText templates.

Indexes
Index Type Tablespace Column
XDO_EFT_SEQUENCE_NAMES_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_CODE
LANGUAGE
TERRITORY
APPLICATION_SHORT_NAME
SEQUENCE_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y
TEMPLATE_CODE VARCHAR2 (80) Y
LANGUAGE VARCHAR2 (6) Y
TERRITORY VARCHAR2 (6) Y
SEQUENCE_NAME VARCHAR2 (240)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_EFT_SEQUENCE_NAMES does not reference any database object

XDO.XDO_EFT_SEQUENCE_NAMES is referenced by following:

XDO
VIEW - XDO_EFT_SEQUENCE_NAMES#

[top of page]

Table: XDO_FONT_MAPPINGS

Description:
Primary Key: XDO_FONT_MAPPINGS_PK
  1. BASE_FONT
  2. LANGUAGE
  3. MAPPING_CODE
  4. STYLE
  5. TERRITORY
  6. WEIGHT
Comments

XDO_FONT_MAPPINGS stores the mappings from a base font to a target Truetype or Type 1 font. A collection of these mappings forms a font mapping set.

Columns
Name Datatype Length Mandatory Comments
MAPPING_CODE VARCHAR2 (80) Y
BASE_FONT VARCHAR2 (120) Y
STYLE VARCHAR2 (10) Y
WEIGHT VARCHAR2 (10) Y
LANGUAGE VARCHAR2 (6) Y
TERRITORY VARCHAR2 (6) Y
TARGET_FONT_TYPE VARCHAR2 (10) Y
TARGET_FONT VARCHAR2 (120) Y
TTC_NUMBER NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_FONT_MAPPINGS does not reference any database object

XDO.XDO_FONT_MAPPINGS is referenced by following:

XDO
VIEW - XDO_FONT_MAPPINGS#

[top of page]

Table: XDO_FONT_MAPPING_SETS_B

Description:
Primary Key: XDO_FONT_MAPPING_SETS_B_PK
  1. MAPPING_CODE
Comments

XDO_FONT_MAPPING_SETS_B stores the header information for a font mapping set, which is a collection of font mappings (see XDO_FONT_MAPPINGS table).

Columns
Name Datatype Length Mandatory Comments
MAPPING_CODE VARCHAR2 (80) Y
MAPPING_TYPE VARCHAR2 (1) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_FONT_MAPPING_SETS_B does not reference any database object

XDO.XDO_FONT_MAPPING_SETS_B is referenced by following:

XDO
VIEW - XDO_FONT_MAPPING_SETS_B#

[top of page]

Table: XDO_FONT_MAPPING_SETS_TL

Description:
Primary Key: XDO_FONT_MAPPING_SETS_TL_PK
  1. LANGUAGE
  2. MAPPING_CODE
Comments

XDO_FONT_MAPPING_SETS_TL is a translation table for XDO_FONT_MAPPING_SETS_B.

Columns
Name Datatype Length Mandatory Comments
MAPPING_CODE VARCHAR2 (80) Y
LANGUAGE VARCHAR2 (4) Y
MAPPING_NAME VARCHAR2 (120) Y
SOURCE_LANG VARCHAR2 (4)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

XDO.XDO_FONT_MAPPING_SETS_TL does not reference any database object

XDO.XDO_FONT_MAPPING_SETS_TL is referenced by following:

XDO
VIEW - XDO_FONT_MAPPING_SETS_TL#

[top of page]

Table: XDO_LOBS

Description: This table is used for storing locale(langauge and territory) sensitive binary and text files. It is mainly used for storing language layout templates.
Primary Key: XDO_LOBS_PK
  1. LOB_TYPE
  2. APPLICATION_SHORT_NAME
  3. LOB_CODE
  4. LANGUAGE
  5. TERRITORY
Comments

This table is used for storing locale(langauge and territory) sensitive binary and text files. It is mainly used for storing language layout templates.

Indexes
Index Type Tablespace Column
SYS_IL0000332070C00010$$ UNIQUE APPS_TS_TX_DATA
XDO_LOBS_U1 UNIQUE APPS_TS_TX_IDX LOB_TYPE
APPLICATION_SHORT_NAME
LOB_CODE
LANGUAGE
TERRITORY
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
LOB_TYPE VARCHAR2 (30) Y Lob Type
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application short name
LOB_CODE VARCHAR2 (80) Y Lob code
LANGUAGE VARCHAR2 (6) Y Language
TERRITORY VARCHAR2 (6) Y Territory
FILE_NAME VARCHAR2 (120) Y File name
XDO_FILE_TYPE VARCHAR2 (30) Y File type
FILE_STATUS VARCHAR2 (1) Y file status (enabled)
FILE_CONTENT_TYPE VARCHAR2 (120) Y Content type (mime type)
FILE_DATA BLOB (4000)
File data
PROGRAM VARCHAR2 (30)
Program which inserted this record
PROGRAM_TAG VARCHAR2 (50)
Program tag
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TRANS_COMPLETE VARCHAR2 (1)
For MLS templates, whether all strings are translated
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_LOBS does not reference any database object

XDO.XDO_LOBS is referenced by following:

XDO
VIEW - XDO_LOBS#

[top of page]

Table: XDO_TEMPLATES_B

Description: XDO_TEMPLATES_B is a table for template information. Each template has a corresponding data source definition stored in the XDO_DS_DEFINITIONS_B. Each translation of a certain template, not each template, has a correspoinding physical templ
Primary Key: XDO_TEMPLATES_B_PK
  1. APPLICATION_SHORT_NAME
  2. TEMPLATE_CODE
Primary Key: XDO_TEMPLATES_B_UK1
  1. APPLICATION_ID
  2. TEMPLATE_CODE
Primary Key: XDO_TEMPLATES_B_UK2
  1. TEMPLATE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IRC_OFFERS.TEMPLATE_ID XDO_TEMPLATES_B
IRC_TEMPLATE_ASSOCIATIONS.TEMPLATE_ID XDO_TEMPLATES_B
Comments

XDO_TEMPLATES_B is a table for template information. Each template has a corresponding data source definition stored in the XDO_DS_DEFINITIONS_B. Each translation of a certain template, not each template, has a correspoinding physical template file. The physical template file information are stored in the XDO_TEMPLATE_FILES.

Indexes
Index Type Tablespace Column
XDO_TEMPLATES_B_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
TEMPLATE_CODE
ZD_EDITION_NAME
XDO_TEMPLATES_B_U2 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
TEMPLATE_CODE
ZD_EDITION_NAME
XDO_TEMPLATES_B_U3 UNIQUE APPS_TS_TX_IDX TEMPLATE_ID
ZD_EDITION_NAME
XDO_TEMPLATES_B_N1 NONUNIQUE APPS_TS_TX_IDX DS_APP_SHORT_NAME
DATA_SOURCE_CODE
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Y Template ID
APPLICATION_ID NUMBER
Y Application ID
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Foreign Key to fnd_application(APPLICATION_SHORT_NAME)
TEMPLATE_CODE VARCHAR2 (80) Y Template code
DS_APP_SHORT_NAME VARCHAR2 (50) Y Foreign key to xdo_ds_definitions_b(APPLICATION_SHORT_NAME)
DATA_SOURCE_CODE VARCHAR2 (80) Y Foreign key to xdo_ds_definitions_b(DATA_SOURCE_CODE)
TEMPLATE_TYPE_CODE VARCHAR2 (30) Y Template type
DEFAULT_LANGUAGE VARCHAR2 (6) Y Foreign key to fnd_iso_languags(ISO_LANGUAGE_2)
DEFAULT_TERRITORY VARCHAR2 (6) Y Foreign key to fnd_territories(TERRITORY_CODE). '00' is used as 'Not specified' or 'Null' value.
TEMPLATE_STATUS VARCHAR2 (1) Y Status (enabled)
USE_ALIAS_TABLE VARCHAR2 (1) Y It is used for PDF Form Field Mapping. If �Y�, query xdo_template_fields table for alias names
DEPENDENCY_FLAG VARCHAR2 (1)
This column is to tell whether the template is an independent, standalone template which can be processed by XML Publisher processors or a fragment of a template that will be included into other templates. The value 'P'(parent) will be assigned to the standalone templates and 'C'(child) will be assigned to the template fragments.
START_DATE DATE
Y Start effective date
END_DATE DATE

End effective date
OBJECT_VERSION_NUMBER NUMBER (9) Y Version number
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield column
MLS_LANGUAGE VARCHAR2 (6)
Base translatable locale language
MLS_TERRITORY VARCHAR2 (6)
Base translatable locale territory
DEFAULT_OUTPUT_TYPE VARCHAR2 (10)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_TEMPLATES_B does not reference any database object

XDO.XDO_TEMPLATES_B is referenced by following:

XDO
VIEW - XDO_TEMPLATES_B#

[top of page]

Table: XDO_TEMPLATES_TL

Description: XDO_TEMPLATES_TL is a translation table for XDO_TEMPLATES_B.
Primary Key: XDO_TEMPLATES_TL_PK
  1. APPLICATION_SHORT_NAME
  2. TEMPLATE_CODE
  3. LANGUAGE
Primary Key: XDO_TEMPLATES_TL_UK1
  1. APPLICATION_SHORT_NAME
  2. TEMPLATE_NAME
  3. LANGUAGE
Comments

XDO_TEMPLATES_TL is a translation table for XDO_TEMPLATES_B.

Indexes
Index Type Tablespace Column
XDO_TEMPLATES_TL_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
TEMPLATE_CODE
LANGUAGE
ZD_EDITION_NAME
XDO_TEMPLATES_TL_U2 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
TEMPLATE_NAME
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application Short Name
TEMPLATE_CODE VARCHAR2 (80) Y Template code
LANGUAGE VARCHAR2 (4) Y Language
TEMPLATE_NAME VARCHAR2 (120) Y Template Name
DESCRIPTION VARCHAR2 (1000)
Description
SOURCE_LANG VARCHAR2 (4) Y Source Language
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_TEMPLATES_TL does not reference any database object

XDO.XDO_TEMPLATES_TL is referenced by following:

XDO
VIEW - XDO_TEMPLATES_TL#

[top of page]

Table: XDO_TEMPLATE_FIELDS

Description: XDO_TEMPLATE_FIELDS is a table for template field information. Each field belongs to one of physical template files stored in XDO_TEMPLATE_FILES.
Primary Key: XDO_TEMPLATE_FIELDS_PK
  1. APPLICATION_SHORT_NAME
  2. TEMPLATE_CODE
  3. FIELD_NAME
Comments

XDO_TEMPLATE_FIELDS is a table for template field information. Each field belongs to one of physical template files stored in XDO_TEMPLATE_FILES.

Indexes
Index Type Tablespace Column
XDO_TEMPLATE_FIELDS_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
TEMPLATE_CODE
FIELD_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application Short Name
TEMPLATE_CODE VARCHAR2 (80) Y Template Code
FIELD_NAME VARCHAR2 (255) Y Field Name
ALIAS_NAME VARCHAR2 (255)
Alias name
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_TEMPLATE_FIELDS does not reference any database object

XDO.XDO_TEMPLATE_FIELDS is referenced by following:

XDO
VIEW - XDO_TEMPLATE_FIELDS#

[top of page]

Table: XDO_TRANS_UNITS

Description: This table is used to store the header information regarding each segment of translatable text in layout templates.
Primary Key: XDO_TRANS_UNITS_PK
  1. APPLICATION_SHORT_NAME
  2. TEMPLATE_CODE
  3. UNIT_ID
Comments

This table is used to store the header information regarding each segment of translatable text in layout templates.

Indexes
Index Type Tablespace Column
XDO_TRANS_UNITS_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
TEMPLATE_CODE
UNIT_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application Short Name
TEMPLATE_CODE VARCHAR2 (80) Y Template code
UNIT_ID VARCHAR2 (255) Y Trans Unit ID
NOTE VARCHAR2 (4000)
Note
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_TRANS_UNITS does not reference any database object

XDO.XDO_TRANS_UNITS is referenced by following:

XDO
VIEW - XDO_TRANS_UNITS#

[top of page]

Table: XDO_TRANS_UNIT_PROPS

Description: This table is used to store any untranslatable values embedded within a segment of text. These values will be merged back into the text translations.
Primary Key: XDO_TRANS_UNIT_PROPS_PK
  1. APPLICATION_SHORT_NAME
  2. TEMPLATE_CODE
  3. UNIT_ID
  4. PROP_TYPE
Comments

This table is used to store any untranslatable values embedded within a segment of text. These values will be merged back into the text translations.

Indexes
Index Type Tablespace Column
XDO_TRANS_UNIT_PROPS_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
TEMPLATE_CODE
UNIT_ID
PROP_TYPE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application Short Name
TEMPLATE_CODE VARCHAR2 (80) Y Template Code
UNIT_ID VARCHAR2 (255) Y Trans unit ID
PROP_TYPE VARCHAR2 (6) Y Prop type
PROP_VALUE VARCHAR2 (4000)
Property value
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_TRANS_UNIT_PROPS does not reference any database object

XDO.XDO_TRANS_UNIT_PROPS is referenced by following:

XDO
VIEW - XDO_TRANS_UNIT_PROPS#

[top of page]

Table: XDO_TRANS_UNIT_VALUES

Description: This table is used to store the actual value of the translatable text in layout templates. There is one record for each language the text is translated to.
Primary Key: XDO_TRANS_UNIT_VALUES_PK
  1. APPLICATION_SHORT_NAME
  2. TEMPLATE_CODE
  3. UNIT_ID
  4. LANGUAGE
  5. TERRITORY
Comments

This table is used to store the actual value of the translatable text in layout templates. There is one record for each language the text is translated to.

Indexes
Index Type Tablespace Column
XDO_TRANS_UNIT_VALUES_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
LANGUAGE
TEMPLATE_CODE
TERRITORY
UNIT_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application Short name
TEMPLATE_CODE VARCHAR2 (80) Y Template code
UNIT_ID VARCHAR2 (255) Y Trans unit ID
LANGUAGE VARCHAR2 (6) Y Language
TERRITORY VARCHAR2 (6) Y Territory
VALUE VARCHAR2 (4000)
String value for this locale
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XDO.XDO_TRANS_UNIT_VALUES does not reference any database object

XDO.XDO_TRANS_UNIT_VALUES is referenced by following:

XDO
VIEW - XDO_TRANS_UNIT_VALUES#

[top of page]

View: XDO_CONFIG_PROPERTIES_VL

Comments

XDO_CONFIG_PROPERTIES_VL is a view to join XDO_CONFIG_PROPERTIES_B and XDO_CONFIG_PROPERTIES_TL.

Columns
Name Datatype Length Mandatory Comments
PROPERTY_CODE VARCHAR2 (100) Y
PROPERTY_NAME VARCHAR2 (120) Y
CATEGORY VARCHAR2 (50) Y
XDO_CFG_NAME VARCHAR2 (100) Y
LOOKUP_TYPE VARCHAR2 (50)
SORT_ORDER NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.XDO_CONFIG_PROPERTIES_VL references the following:

APPS
SYNONYM - XDO_CONFIG_PROPERTIES_B
SYNONYM - XDO_CONFIG_PROPERTIES_TL

APPS.XDO_CONFIG_PROPERTIES_VL is not referenced by any database object

[top of page]

View: XDO_CURRENCY_FORMAT_SETS_VL

Comments
Columns
Name Datatype Length Mandatory Comments
FORMAT_SET_CODE VARCHAR2 (80) Y
FORMAT_SET_NAME VARCHAR2 (120) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.XDO_CURRENCY_FORMAT_SETS_VL references the following:

APPS
SYNONYM - XDO_CURRENCY_FORMAT_SETS_B
SYNONYM - XDO_CURRENCY_FORMAT_SETS_TL

APPS.XDO_CURRENCY_FORMAT_SETS_VL is not referenced by any database object

[top of page]

View: XDO_DS_DEFINITIONS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

XDO_DS_DEFINITIONS_VL is a view to join XDO_DS_DEFINITIONS_B and XDO_DS_DEFINITIONS_TL.

Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application short name
DATA_SOURCE_CODE VARCHAR2 (80) Y Data source code
DATA_SOURCE_STATUS VARCHAR2 (1) Y Status (enabled/disabled)
START_DATE DATE
Y Start effective date
END_DATE DATE

End effective date
DATA_SOURCE_NAME VARCHAR2 (120) Y Data source name
DESCRIPTION VARCHAR2 (2000)
Description
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9) Y Version number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield column

[top of page]

APPS.XDO_DS_DEFINITIONS_VL references the following:

APPS
SYNONYM - XDO_DS_DEFINITIONS_B
SYNONYM - XDO_DS_DEFINITIONS_TL

APPS.XDO_DS_DEFINITIONS_VL is not referenced by any database object

[top of page]

View: XDO_FONT_MAPPING_SETS_VL

Comments

XDO_FONT_MAPPING_SETS_VL is a view to join XDO_FONT_MAPPING_SETS_B and XDO_FONT_MAPPING_SETS_TL.

Columns
Name Datatype Length Mandatory Comments
MAPPING_CODE VARCHAR2 (80) Y
MAPPING_NAME VARCHAR2 (120) Y
MAPPING_TYPE VARCHAR2 (1) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.XDO_FONT_MAPPING_SETS_VL references the following:

APPS
SYNONYM - XDO_FONT_MAPPING_SETS_B
SYNONYM - XDO_FONT_MAPPING_SETS_TL

APPS.XDO_FONT_MAPPING_SETS_VL is not referenced by any database object

[top of page]

View: XDO_TEMPLATES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

XDO_TEMPLATES_VL is a view to join XDO_TEMPLATES_B and XDO_TEMPLATES_TL.

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Y Template ID
APPLICATION_ID NUMBER
Y Application ID
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Application Short Name
TEMPLATE_CODE VARCHAR2 (80) Y Template Code
DS_APP_SHORT_NAME VARCHAR2 (50) Y Data source application short name
DATA_SOURCE_CODE VARCHAR2 (80) Y Data source code
TEMPLATE_TYPE_CODE VARCHAR2 (30) Y Template type
DEFAULT_LANGUAGE VARCHAR2 (6) Y Default locale language
DEFAULT_TERRITORY VARCHAR2 (6) Y Default locale territory
MLS_LANGUAGE VARCHAR2 (6)
Base translatable locale language
MLS_TERRITORY VARCHAR2 (6)
Base translatable locale territory
TEMPLATE_STATUS VARCHAR2 (1) Y Status (enabled /disabled)
USE_ALIAS_TABLE VARCHAR2 (1) Y Use PDF mapping alias
DEPENDENCY_FLAG VARCHAR2 (1)
Subtemplate
START_DATE DATE
Y Start effective date
END_DATE DATE

End effective date
TEMPLATE_NAME VARCHAR2 (120) Y Template name
DEFAULT_OUTPUT_TYPE VARCHAR2 (10)
DESCRIPTION VARCHAR2 (1000)
Description
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9) Y Version number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield column

[top of page]

APPS.XDO_TEMPLATES_VL references the following:

APPS
SYNONYM - XDO_TEMPLATES_B
SYNONYM - XDO_TEMPLATES_TL

APPS.XDO_TEMPLATES_VL is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract