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:

[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

[top of page]

XDO.XDO_CONFIG_KEYS does not reference any database object

XDO.XDO_CONFIG_KEYS is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_CONFIG_PROPERTIES_B does not reference any database object

XDO.XDO_CONFIG_PROPERTIES_B is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_CONFIG_PROPERTIES_TL does not reference any database object

XDO.XDO_CONFIG_PROPERTIES_TL is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_CONFIG_VALUES does not reference any database object

XDO.XDO_CONFIG_VALUES is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_CURRENCY_FORMATS does not reference any database object

XDO.XDO_CURRENCY_FORMATS is referenced by following:

APPS
SYNONYM - 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

[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:

APPS
SYNONYM - 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

[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:

APPS
SYNONYM - XDO_CURRENCY_FORMAT_SETS_TL

[top of page]

Table: XDO_DGF_BLOCK_CONTEXTS

Description:

[top of page]

XDO.XDO_DGF_BLOCK_CONTEXTS does not reference any database object

XDO.XDO_DGF_BLOCK_CONTEXTS is referenced by following:

APPS
SYNONYM - XDO_DGF_BLOCK_CONTEXTS

[top of page]

Table: XDO_DGF_RPT_CONTEXTS

Description:

[top of page]

XDO.XDO_DGF_RPT_CONTEXTS does not reference any database object

XDO.XDO_DGF_RPT_CONTEXTS is referenced by following:

APPS
SYNONYM - XDO_DGF_RPT_CONTEXTS

[top of page]

Table: XDO_DGF_RPT_CONTEXT_PARAMETERS

Description:

[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:

APPS
SYNONYM - XDO_DGF_RPT_CONTEXT_PARAMETERS

[top of page]

Table: XDO_DGF_RULE_CATALOG_B

Description:

[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:

APPS
SYNONYM - XDO_DGF_RULE_CATALOG_B

[top of page]

Table: XDO_DGF_RULE_CATALOG_TL

Description:

[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:

APPS
SYNONYM - XDO_DGF_RULE_CATALOG_TL

[top of page]

Table: XDO_DGF_TPL_CONTEXTS

Description:

[top of page]

XDO.XDO_DGF_TPL_CONTEXTS does not reference any database object

XDO.XDO_DGF_TPL_CONTEXTS is referenced by following:

APPS
SYNONYM - XDO_DGF_TPL_CONTEXTS

[top of page]

Table: XDO_DGF_TPL_RULES

Description:

[top of page]

XDO.XDO_DGF_TPL_RULES does not reference any database object

XDO.XDO_DGF_TPL_RULES is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_DS_DEFINITIONS_B does not reference any database object

XDO.XDO_DS_DEFINITIONS_B is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_DS_DEFINITIONS_TL does not reference any database object

XDO.XDO_DS_DEFINITIONS_TL is referenced by following:

APPS
SYNONYM - XDO_DS_DEFINITIONS_TL

[top of page]

Table: XDO_EFT_SEQUENCE_NAMES

Description:

[top of page]

XDO.XDO_EFT_SEQUENCE_NAMES does not reference any database object

XDO.XDO_EFT_SEQUENCE_NAMES is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_FONT_MAPPINGS does not reference any database object

XDO.XDO_FONT_MAPPINGS is referenced by following:

APPS
SYNONYM - XDO_FONT_MAPPINGS

[top of page]

Table: XDO_FONT_MAPPING_SETS_B

Description:
Primary Key: XDO_FONT_MAPPING_SETS_B_PK
  1. MAPPING_CODE

[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:

APPS
SYNONYM - 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

[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:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_LOBS does not reference any database object

XDO.XDO_LOBS is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_TEMPLATES_B does not reference any database object

XDO.XDO_TEMPLATES_B is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_TEMPLATES_TL does not reference any database object

XDO.XDO_TEMPLATES_TL is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_TEMPLATE_FIELDS does not reference any database object

XDO.XDO_TEMPLATE_FIELDS is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_TRANS_UNITS does not reference any database object

XDO.XDO_TRANS_UNITS is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_TRANS_UNIT_PROPS does not reference any database object

XDO.XDO_TRANS_UNIT_PROPS is referenced by following:

APPS
SYNONYM - 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

[top of page]

XDO.XDO_TRANS_UNIT_VALUES does not reference any database object

XDO.XDO_TRANS_UNIT_VALUES is referenced by following:

APPS
SYNONYM - XDO_TRANS_UNIT_VALUES

[top of page]

View: XDO_CONFIG_PROPERTIES_VL

[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

[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 referenced by following:

APPS
TRIGGER - XDO_CURRENCY_FORMAT_SETS_IL
TRIGGER - XDO_CURRENCY_FORMAT_SETS_UL

[top of page]

View: XDO_DS_DEFINITIONS_VL

[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 referenced by following:

APPS
TRIGGER - XDO_DS_DEFINITIONS_DL
TRIGGER - XDO_DS_DEFINITIONS_IL
TRIGGER - XDO_DS_DEFINITIONS_UL

[top of page]

View: XDO_FONT_MAPPING_SETS_VL

[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 referenced by following:

APPS
TRIGGER - XDO_FONT_MAPPING_SETS_IL
TRIGGER - XDO_FONT_MAPPING_SETS_UL

[top of page]

View: XDO_TEMPLATES_VL

[top of page]

APPS.XDO_TEMPLATES_VL references the following:

APPS
SYNONYM - XDO_TEMPLATES_B
SYNONYM - XDO_TEMPLATES_TL
APPS.XDO_TEMPLATES_VL is referenced by following:

APPS
PACKAGE BODY - FND_CONC_TEMPLATES
VIEW - IEX_DELIVERY_TEMPLATES_V
PACKAGE BODY - IEX_SEND_XML_PVT
PACKAGE BODY - OKS_AUTO_REMINDER
PACKAGE BODY - OKS_K_ACTIONS_PVT
VIEW - OKS_LAYOUT_TEMPLATES_V
PACKAGE BODY - OKS_TEMPLATE_SET_PUB
PACKAGE BODY - PAY_CORE_XDO_UTILS
PACKAGE BODY - PAY_MX_TRR_PKG
PACKAGE BODY - PAY_PAYGTN_PKG
PACKAGE BODY - PQP_EXR_SWI
PACKAGE BODY - QP_PRICE_BOOK_UTIL
PACKAGE BODY - RG_REPORT_SUBMISSION_PKG
PACKAGE BODY - WSH_SHIPPING_PARAMS_PVT
TRIGGER - XDO_TEMPLATES_DL
TRIGGER - XDO_TEMPLATES_IL
TRIGGER - XDO_TEMPLATES_UL

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