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 - XDP Tables and Views

TABLE - XDP.XDP_ACTION_CODES
TABLE - XDP.XDP_ACTION_CODES_TL
TABLE - XDP.XDP_ADAPTER_ADMIN_REQS
TABLE - XDP.XDP_ADAPTER_AUDIT
TABLE - XDP.XDP_ADAPTER_JOB_QUEUE
TABLE - XDP.XDP_ADAPTER_REG
TABLE - XDP.XDP_ADAPTER_TYPES_B
TABLE - XDP.XDP_ADAPTER_TYPES_TL
TABLE - XDP.XDP_ADAPTER_TYPE_ATTRS_B
TABLE - XDP.XDP_ADAPTER_TYPE_ATTRS_TL
TABLE - XDP.XDP_DEBUG
TABLE - XDP.XDP_DQER_REGISTRATION
TABLE - XDP.XDP_DQ_CONFIGURATION
TABLE - XDP.XDP_DQ_CONFIGURATION_TL
TABLE - XDP.XDP_DQ_EXCEPTIONS
TABLE - XDP.XDP_ERRORS
TABLE - XDP.XDP_ERROR_COUNT
TABLE - XDP.XDP_ERROR_LOG
TABLE - XDP.XDP_FA_DETAILS
TABLE - XDP.XDP_FA_FULFILLMENT_PROC
TABLE - XDP.XDP_FA_PARAMETERS
TABLE - XDP.XDP_FA_RESUBMISSION_LOG
TABLE - XDP.XDP_FA_RUNTIME_LIST
TABLE - XDP.XDP_FES
TABLE - XDP.XDP_FES_TL
TABLE - XDP.XDP_FE_ATTRIBUTE_DEF
TABLE - XDP.XDP_FE_ATTRIBUTE_DEF_TL
TABLE - XDP.XDP_FE_ATTRIBUTE_VAL
TABLE - XDP.XDP_FE_ATTRIBUTE_VAL_TL
TABLE - XDP.XDP_FE_CMD_AUD_TRAILS
TABLE - XDP.XDP_FE_GENERIC_CONFIG
TABLE - XDP.XDP_FE_SW_GEN_LOOKUP
TABLE - XDP.XDP_FE_SW_GEN_LOOKUP_TL
TABLE - XDP.XDP_FE_TYPES
TABLE - XDP.XDP_FE_TYPES_TL
TABLE - XDP.XDP_FMC_AUDIT_TRAILS
TABLE - XDP.XDP_FMC_AUD_TRAIL_DETS
TABLE - XDP.XDP_FULFILL_ACTIONS
TABLE - XDP.XDP_FULFILL_ACTIONS_TL
TABLE - XDP.XDP_FULFILL_WORKLIST
TABLE - XDP.XDP_LINE_RELATIONSHIPS
TABLE - XDP.XDP_OE_ORDER_HEADERS
TABLE - XDP.XDP_OE_ORDER_LINES
TABLE - XDP.XDP_OE_ORDER_LINE_DETS
TABLE - XDP.XDP_OE_ORDER_PARAMETERS
TABLE - XDP.XDP_ORDER_BUNDLES
TABLE - XDP.XDP_ORDER_HEADERS
TABLE - XDP.XDP_ORDER_LINEITEM_DETS
TABLE - XDP.XDP_ORDER_LINE_ITEMS
TABLE - XDP.XDP_ORDER_PARAMETERS
TABLE - XDP.XDP_ORDER_RELATIONSHIPS
TABLE - XDP.XDP_PARAMETER_POOL
TABLE - XDP.XDP_PARAMETER_POOL_TL
TABLE - XDP.XDP_PROC_BODY
TABLE - XDP.XDP_PROC_BODY_TL
TABLE - XDP.XDP_SERVICES
TABLE - XDP.XDP_SERVICES_TL
TABLE - XDP.XDP_SERVICE_PACKAGES
TABLE - XDP.XDP_SERVICE_PACKAGES_TL
TABLE - XDP.XDP_SERVICE_PKG_DET
TABLE - XDP.XDP_SERVICE_PKG_DET_TL
TABLE - XDP.XDP_SERVICE_VAL_ACTS
TABLE - XDP.XDP_SERVICE_VAL_ACTS_TL
TABLE - XDP.XDP_SERVICE_WI_MAP
TABLE - XDP.XDP_SERVICE_WI_MAP_TL
TABLE - XDP.XDP_WF_PROCESS_COORD
TABLE - XDP.XDP_WI_FA_MAPPING
TABLE - XDP.XDP_WI_FA_MAPPING_TL
TABLE - XDP.XDP_WI_PARAMETERS
TABLE - XDP.XDP_WI_RELATIONSHIPS
TABLE - XDP.XDP_WORKITEMS
TABLE - XDP.XDP_WORKITEMS_TL
TABLE - XDP.XDP_WORKLIST_DETAILS
VIEW - APPS.XDP_ACTION_CODES_V
VIEW - APPS.XDP_ADAPTER_ADMIN_REQS_V
VIEW - APPS.XDP_ADAPTER_AUDIT_V
VIEW - APPS.XDP_ADAPTER_JOB_QUEUE_V
VIEW - APPS.XDP_ADAPTER_REG_V
VIEW - APPS.XDP_ADAPTER_SUMMARY_V
VIEW - APPS.XDP_ADAPTER_TYPES_VL
VIEW - APPS.XDP_ADAPTER_TYPE_ATTRS_VL
VIEW - APPS.XDP_ADAPTER_TYPE_REQ_TYPES_V
VIEW - APPS.XDP_ADAPTER_TYPE_V
VIEW - APPS.XDP_DQ_CONFIGURATION_VL
VIEW - APPS.XDP_ERROR_LOG_V
VIEW - APPS.XDP_EVENTS_V
VIEW - APPS.XDP_FA_PARAMETERS_DISP_V
VIEW - APPS.XDP_FA_PARAMETERS_V
VIEW - APPS.XDP_FES_VL
VIEW - APPS.XDP_FE_ATTRIBUTE_DEF_VL
VIEW - APPS.XDP_FE_ATTRIBUTE_VAL_VL
VIEW - APPS.XDP_FE_GENERIC_CONFIG_V
VIEW - APPS.XDP_FE_SUMMARY_V
VIEW - APPS.XDP_FE_SW_GEN_LOOKUP_VL
VIEW - APPS.XDP_FE_TYPES_VL
VIEW - APPS.XDP_FMC_V
VIEW - APPS.XDP_FULFILL_ACTIONS_VL
VIEW - APPS.XDP_INBOUND_MESSAGES_V
VIEW - APPS.XDP_LOOKUPS
VIEW - APPS.XDP_OE_ORDER_DETAILS_V
VIEW - APPS.XDP_ORDER_DETAILS_V
VIEW - APPS.XDP_ORU_ORDERS_V
VIEW - APPS.XDP_OUTBOUND_MESSAGES_V
VIEW - APPS.XDP_PARAMETER_POOL_VL
VIEW - APPS.XDP_PROC_BODY_VL
VIEW - APPS.XDP_PROFILE_OPTIONS_V
VIEW - APPS.XDP_READY_FAS_V
VIEW - APPS.XDP_READY_FES_V
VIEW - APPS.XDP_READY_ORDER_V
VIEW - APPS.XDP_READY_WORKITEM_V
VIEW - APPS.XDP_SERVICE_VAL_ACTS_VL
VIEW - APPS.XDP_SERVICE_WI_MAP_VL
VIEW - APPS.XDP_SUMMARY_QUEUES_V
VIEW - APPS.XDP_SVE_PKG_DET_DISP_V
VIEW - APPS.XDP_SVE_VAL_ACTION_DISP_V
VIEW - APPS.XDP_SVE_WI_MAPPING_DISP_V
VIEW - APPS.XDP_WAITING_FES_V
VIEW - APPS.XDP_WI_FA_MAPPING_DISP_V
VIEW - APPS.XDP_WI_FA_MAPPING_VL
VIEW - APPS.XDP_WI_PARAMETERS_DISP_V
VIEW - APPS.XDP_WORKITEMS_VL

Table: XDP_ACTION_CODES

Description: Not used
Primary Key: XDP_ACTION_CODES_PK
  1. ACTION_CODE_ID
Primary Key: XDP_ACTION_CODES_UK1
  1. ACTION_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_ACTION_CODES_TL.ACTION_CODE_ID XDP_ACTION_CODES

[top of page]

XDP.XDP_ACTION_CODES does not reference any database object

XDP.XDP_ACTION_CODES is referenced by following:

XDP
VIEW - XDP_ACTION_CODES#

[top of page]

Table: XDP_ACTION_CODES_TL

Description: Not used
Primary Key: XDP_ACTION_CODES_TL_PK
  1. ACTION_CODE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ACTION_CODES_TL.ACTION_CODE_ID XDP_ACTION_CODES

[top of page]

XDP.XDP_ACTION_CODES_TL does not reference any database object

XDP.XDP_ACTION_CODES_TL is referenced by following:

XDP
VIEW - XDP_ACTION_CODES_TL#

[top of page]

Table: XDP_ADAPTER_ADMIN_REQS

Description: Stores all Adapter specific pending jobs
Primary Key: XDP_ADAPTER_ADMIN_REQS_PK
  1. REQUEST_ID

[top of page]

XDP.XDP_ADAPTER_ADMIN_REQS does not reference any database object

XDP.XDP_ADAPTER_ADMIN_REQS is referenced by following:

XDP
VIEW - XDP_ADAPTER_ADMIN_REQS#

[top of page]

Table: XDP_ADAPTER_AUDIT

Description: Holds audit information about all the completed administration requests for all Adapters
Primary Key: XDP_ADAPTER_AUDIT_PK
  1. ADAPTER_AUDIT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_AUDIT.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
XDP_ADAPTER_AUDIT.APPLICATION_ID
XDP_ADAPTER_AUDIT.SERVICE_INSTANCE_ID 		FND_CONCURRENT_QUEUES

[top of page]

XDP.XDP_ADAPTER_AUDIT does not reference any database object

XDP.XDP_ADAPTER_AUDIT is referenced by following:

XDP
VIEW - XDP_ADAPTER_AUDIT#

[top of page]

Table: XDP_ADAPTER_JOB_QUEUE

Description: Job queue for the NEM
Primary Key: XDP_ADAPTER_JOB_QUEUE_PK
  1. JOB_ID
Primary Key: XDP_ADAPTER_JOB_QUEUE_UK1
  1. WF_ITEM_KEY
  2. WF_ITEM_TYPE

[top of page]

XDP.XDP_ADAPTER_JOB_QUEUE does not reference any database object

XDP.XDP_ADAPTER_JOB_QUEUE is referenced by following:

XDP
VIEW - XDP_ADAPTER_JOB_QUEUE#

[top of page]

Table: XDP_ADAPTER_REG

Description: Stores configuration data pertaining to all Adapters
Primary Key: XDP_ADAPTER_REG_PK
  1. CHANNEL_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_REG.FE_ID XDP_FES
XDP_ADAPTER_REG.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
XDP_ADAPTER_REG.APPLICATION_ID
XDP_ADAPTER_REG.SERVICE_INSTANCE_ID 		FND_CONCURRENT_QUEUES

[top of page]

XDP.XDP_ADAPTER_REG does not reference any database object

XDP.XDP_ADAPTER_REG is referenced by following:

XDP
VIEW - XDP_ADAPTER_REG#

[top of page]

Table: XDP_ADAPTER_TYPES_B

Description: Stores all seeded and user defined Adapter Types
Primary Key: XDP_ADAPTER_TYPES_PK
  1. ADAPTER_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_TYPES_B.BASE_ADAPTER_TYPE XDP_ADAPTER_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_AUDIT.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
XDP_ADAPTER_REG.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
XDP_ADAPTER_TYPES_B.BASE_ADAPTER_TYPE XDP_ADAPTER_TYPES_B
XDP_ADAPTER_TYPES_TL.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
XDP_ADAPTER_TYPE_ATTRS_B.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
XDP_FE_SW_GEN_LOOKUP.ADAPTER_TYPE XDP_ADAPTER_TYPES_B

[top of page]

XDP.XDP_ADAPTER_TYPES_B does not reference any database object

XDP.XDP_ADAPTER_TYPES_B is referenced by following:

XDP
VIEW - XDP_ADAPTER_TYPES_B#

[top of page]

Table: XDP_ADAPTER_TYPES_TL

Description: Translation Table
Primary Key: XDP_ADAPTER_TYPES_TL_PK
  1. ADAPTER_TYPE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_TYPES_TL.ADAPTER_TYPE XDP_ADAPTER_TYPES_B

[top of page]

XDP.XDP_ADAPTER_TYPES_TL does not reference any database object

XDP.XDP_ADAPTER_TYPES_TL is referenced by following:

XDP
VIEW - XDP_ADAPTER_TYPES_TL#

[top of page]

Table: XDP_ADAPTER_TYPE_ATTRS_B

Description: Stores attributes and their default values for seeded and custom adapter types.
Primary Key: XDP_ADAPTER_TYPE_ATTRS_B_PK
  1. ADAPTER_TYPE_ATTRS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_TYPE_ATTRS_B.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_TYPE_ATTRS_TL.ADAPTER_TYPE_ATTRS_ID XDP_ADAPTER_TYPE_ATTRS_B

[top of page]

XDP.XDP_ADAPTER_TYPE_ATTRS_B does not reference any database object

XDP.XDP_ADAPTER_TYPE_ATTRS_B is referenced by following:

XDP
VIEW - XDP_ADAPTER_TYPE_ATTRS_B#

[top of page]

Table: XDP_ADAPTER_TYPE_ATTRS_TL

Description: Stores the translateable display names and descriptions for adapter-type attributes.
Primary Key: XDP_ADAPTER_TYPE_ATTRS_TL_PK
  1. ADAPTER_TYPE_ATTRS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_TYPE_ATTRS_TL.ADAPTER_TYPE_ATTRS_ID XDP_ADAPTER_TYPE_ATTRS_B

[top of page]

XDP.XDP_ADAPTER_TYPE_ATTRS_TL does not reference any database object

XDP.XDP_ADAPTER_TYPE_ATTRS_TL is referenced by following:

XDP
VIEW - XDP_ADAPTER_TYPE_ATTRS_TL#

[top of page]

Table: XDP_DEBUG

Description: An internal debug table
Primary Key: XDP_DEBUG_PK
  1. EXEC_SEQ

[top of page]

XDP.XDP_DEBUG does not reference any database object

XDP.XDP_DEBUG is referenced by following:

XDP
VIEW - XDP_DEBUG#

[top of page]

Table: XDP_DQER_REGISTRATION

Description: Internal table used for registering processes responsible for dequeuing messages from internal queues
Primary Key: XDP_DQER_REGISTRATION_PK
  1. DQER_NAME

[top of page]

XDP.XDP_DQER_REGISTRATION does not reference any database object

XDP.XDP_DQER_REGISTRATION is referenced by following:

XDP
VIEW - XDP_DQER_REGISTRATION#

[top of page]

Table: XDP_DQ_CONFIGURATION

Description: Configuration table for application queues
Primary Key: XDP_DQ_CONFIGURATION_PK
  1. INTERNAL_Q_NAME
Primary Key: XDP_DQ_CONFIGURATION_UK1
  1. Q_ALIAS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_DQ_CONFIGURATION_TL.INTERNAL_Q_NAME XDP_DQ_CONFIGURATION

[top of page]

XDP.XDP_DQ_CONFIGURATION does not reference any database object

XDP.XDP_DQ_CONFIGURATION is referenced by following:

XDP
VIEW - XDP_DQ_CONFIGURATION#

[top of page]

Table: XDP_DQ_CONFIGURATION_TL

Description: Multi-lingual support table for application queue configuration
Primary Key: XDP_DQ_CONFIGURATION_TL_PK
  1. INTERNAL_Q_NAME
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_DQ_CONFIGURATION_TL.INTERNAL_Q_NAME XDP_DQ_CONFIGURATION

[top of page]

XDP.XDP_DQ_CONFIGURATION_TL does not reference any database object

XDP.XDP_DQ_CONFIGURATION_TL is referenced by following:

XDP
VIEW - XDP_DQ_CONFIGURATION_TL#

[top of page]

Table: XDP_DQ_EXCEPTIONS

Description: Common table to store queue exceptions
Primary Key: XDP_DQ_EXCEPTIONS_PK
  1. ERROR_REF_ID

[top of page]

XDP.XDP_DQ_EXCEPTIONS does not reference any database object

XDP.XDP_DQ_EXCEPTIONS is referenced by following:

XDP
VIEW - XDP_DQ_EXCEPTIONS#

[top of page]

Table: XDP_ERRORS

Description: Common table to store application errors
Primary Key: XDP_ERRORS_PK
  1. ERROR_ID

[top of page]

XDP.XDP_ERRORS does not reference any database object

XDP.XDP_ERRORS is referenced by following:

XDP
VIEW - XDP_ERRORS#

[top of page]

Table: XDP_ERROR_COUNT

Description: Stores number of times an error has occured for a certain instance of an object.

[top of page]

XDP.XDP_ERROR_COUNT does not reference any database object

XDP.XDP_ERROR_COUNT is referenced by following:

XDP
VIEW - XDP_ERROR_COUNT#

[top of page]

Table: XDP_ERROR_LOG

Description: Generically stores all persistent MLS compliant error messages belonging to different application entities (Order, Adapters, etc).
Primary Key: XDP_ERROR_LOG_PK
  1. ERROR_ID

[top of page]

XDP.XDP_ERROR_LOG does not reference any database object

XDP.XDP_ERROR_LOG is referenced by following:

XDP
VIEW - XDP_ERROR_LOG#

[top of page]

Table: XDP_FA_DETAILS

Description: XDP_FA_DETAILS contains the runtime FA parameter values.
Primary Key: XDP_FA_DETAILS_PK
  1. FA_INSTANCE_ID
  2. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FA_DETAILS.FULFILLMENT_ACTION_ID
XDP_FA_DETAILS.PARAMETER_NAME 		XDP_FA_PARAMETERS
XDP_FA_DETAILS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST

[top of page]

XDP.XDP_FA_DETAILS does not reference any database object

XDP.XDP_FA_DETAILS is referenced by following:

XDP
VIEW - XDP_FA_DETAILS#

[top of page]

Table: XDP_FA_FULFILLMENT_PROC

Description: Fulfillment Element Fulfillment procedures
Primary Key: XDP_FA_FULFILLMENT_PROC_PK
  1. FA_FULFILLMENT_PROC_ID
Primary Key: XDP_FA_FULFILLMENT_PROC_UK1
  1. FULFILLMENT_ACTION_ID
  2. FE_SW_GEN_LOOKUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FA_FULFILLMENT_PROC.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_FA_FULFILLMENT_PROC.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP
XDP_FA_FULFILLMENT_PROC.FULFILLMENT_PROC XDP_PROC_BODY
XDP_FA_FULFILLMENT_PROC.TEST_PROVISIONING_PROC XDP_PROC_BODY

[top of page]

XDP.XDP_FA_FULFILLMENT_PROC does not reference any database object

XDP.XDP_FA_FULFILLMENT_PROC is referenced by following:

XDP
VIEW - XDP_FA_FULFILLMENT_PROC#

[top of page]

Table: XDP_FA_PARAMETERS

Description: This table is used to define parameters for the Fulfillment Procedure.
Primary Key: XDP_FA_PARAMETERS_PK
  1. FULFILLMENT_ACTION_ID
  2. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FA_PARAMETERS.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_FA_PARAMETERS.EVALUATION_PROCEDURE XDP_PROC_BODY
XDP_FA_PARAMETERS.EVALUATION_PROCEDURE XDP_PROC_BODY
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FA_DETAILS.FULFILLMENT_ACTION_ID
XDP_FA_DETAILS.PARAMETER_NAME 		XDP_FA_PARAMETERS

[top of page]

XDP.XDP_FA_PARAMETERS does not reference any database object

XDP.XDP_FA_PARAMETERS is referenced by following:

XDP
VIEW - XDP_FA_PARAMETERS#

[top of page]

Table: XDP_FA_RESUBMISSION_LOG

Description: This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow.
Primary Key: XDP_FA_RESUBMISSION_LOG_PK
  1. RESUBMISSION_JOB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FA_RESUBMISSION_LOG.FE_ID XDP_FES
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FA_RUNTIME_LIST.RESUBMISSION_JOB_ID XDP_FA_RESUBMISSION_LOG

[top of page]

XDP.XDP_FA_RESUBMISSION_LOG does not reference any database object

XDP.XDP_FA_RESUBMISSION_LOG is referenced by following:

XDP
VIEW - XDP_FA_RESUBMISSION_LOG#

[top of page]

Table: XDP_FA_RUNTIME_LIST

Description: This table contains the list of the FAs which need to be executed for a workitem instance.
Primary Key: XDP_FA_RUNTIME_LIST_PK
  1. FA_INSTANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FA_RUNTIME_LIST.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_FA_RUNTIME_LIST.RESUBMISSION_JOB_ID XDP_FA_RESUBMISSION_LOG
XDP_FA_RUNTIME_LIST.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
XDP_FA_RUNTIME_LIST.FE_ID XDP_FES
XDP_FA_RUNTIME_LIST.PROC_NAME XDP_PROC_BODY
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FA_DETAILS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST
XDP_FE_CMD_AUD_TRAILS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST
XNP_CALLBACK_EVENTS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST
XNP_MSGS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST
XNP_TIMER_REGISTRY.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST

[top of page]

XDP.XDP_FA_RUNTIME_LIST does not reference any database object

XDP.XDP_FA_RUNTIME_LIST is referenced by following:

XDP
VIEW - XDP_FA_RUNTIME_LIST#

[top of page]

Table: XDP_FES

Description: This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element.
Primary Key: XDP_FES_PK
  1. FE_ID
Primary Key: XDP_FES_UK1
  1. FE_ID
  2. FETYPE_ID
Primary Key: XDP_FES_UK2
  1. FULFILLMENT_ELEMENT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FES.FETYPE_ID XDP_FE_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_ADAPTER_REG.FE_ID XDP_FES
XDP_FA_RESUBMISSION_LOG.FE_ID XDP_FES
XDP_FA_RUNTIME_LIST.FE_ID XDP_FES
XDP_FES_TL.FE_ID XDP_FES
XDP_FE_GENERIC_CONFIG.FE_ID XDP_FES
XNP_EVENT_SUBSCRIBERS.FE_ID XDP_FES
XNP_NETWORK_MAPS.PARENT_FE_ID XDP_FES
XNP_NETWORK_MAPS.CHILD_FE_ID XDP_FES
XNP_SERVED_NUM_RANGES.FE_ID XDP_FES
XNP_SP_ADAPTERS.FE_ID XDP_FES
XNP_SV_SMS_FE_MAPS.FE_ID XDP_FES
XNS_CP_FES.FE_ID XDP_FES
XNS_INCIDENT_EXT_REFS.FE_ID XDP_FES

[top of page]

XDP.XDP_FES does not reference any database object

XDP.XDP_FES is referenced by following:

XDP
VIEW - XDP_FES#

[top of page]

Table: XDP_FES_TL

Description: Table to hold details of network element instances.
Primary Key: XDP_FES_TL_PK
  1. FE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FES_TL.FE_ID XDP_FES

[top of page]

XDP.XDP_FES_TL does not reference any database object

XDP.XDP_FES_TL is referenced by following:

XDP
VIEW - XDP_FES_TL#

[top of page]

Table: XDP_FE_ATTRIBUTE_DEF

Description: Fulfillment Element Attribute Definition
Primary Key: XDP_FE_ATTRIBUTE_DEF_PK
  1. FE_ATTRIBUTE_ID
Primary Key: XDP_FE_ATTRIBUTE_DEF_UK1
  1. FE_SW_GEN_LOOKUP_ID
  2. FE_ATTRIBUTE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_ATTRIBUTE_DEF.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FE_ATTRIBUTE_DEF_TL.FE_ATTRIBUTE_ID XDP_FE_ATTRIBUTE_DEF
XDP_FE_ATTRIBUTE_VAL.FE_ATTRIBUTE_ID XDP_FE_ATTRIBUTE_DEF

[top of page]

XDP.XDP_FE_ATTRIBUTE_DEF does not reference any database object

XDP.XDP_FE_ATTRIBUTE_DEF is referenced by following:

XDP
VIEW - XDP_FE_ATTRIBUTE_DEF#

[top of page]

Table: XDP_FE_ATTRIBUTE_DEF_TL

Description: Fulfillment Element Attribute Definition
Primary Key: XDP_FE_ATTRIBUTE_DEF_TL_PK
  1. FE_ATTRIBUTE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_ATTRIBUTE_DEF_TL.FE_ATTRIBUTE_ID XDP_FE_ATTRIBUTE_DEF

[top of page]

XDP.XDP_FE_ATTRIBUTE_DEF_TL does not reference any database object

XDP.XDP_FE_ATTRIBUTE_DEF_TL is referenced by following:

XDP
VIEW - XDP_FE_ATTRIBUTE_DEF_TL#

[top of page]

Table: XDP_FE_ATTRIBUTE_VAL

Description: FE Attribute Values
Primary Key: XDP_FE_ATTRIBUTE_VAL_PK
  1. FE_ATTRIBUTE_ID
  2. FE_GENERIC_CONFIG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_ATTRIBUTE_VAL.FE_ATTRIBUTE_ID XDP_FE_ATTRIBUTE_DEF
XDP_FE_ATTRIBUTE_VAL.FE_GENERIC_CONFIG_ID XDP_FE_GENERIC_CONFIG
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FE_ATTRIBUTE_VAL_TL.FE_ATTRIBUTE_ID
XDP_FE_ATTRIBUTE_VAL_TL.FE_GENERIC_CONFIG_ID 		XDP_FE_ATTRIBUTE_VAL

[top of page]

XDP.XDP_FE_ATTRIBUTE_VAL does not reference any database object

XDP.XDP_FE_ATTRIBUTE_VAL is referenced by following:

XDP
VIEW - XDP_FE_ATTRIBUTE_VAL#

[top of page]

Table: XDP_FE_ATTRIBUTE_VAL_TL

Description: FE Attribute Values
Primary Key: XDP_FE_ATTRIBUTE_VAL_TL_PK
  1. FE_ATTRIBUTE_ID
  2. FE_GENERIC_CONFIG_ID
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_ATTRIBUTE_VAL_TL.FE_ATTRIBUTE_ID
XDP_FE_ATTRIBUTE_VAL_TL.FE_GENERIC_CONFIG_ID 		XDP_FE_ATTRIBUTE_VAL

[top of page]

XDP.XDP_FE_ATTRIBUTE_VAL_TL does not reference any database object

XDP.XDP_FE_ATTRIBUTE_VAL_TL is referenced by following:

XDP
VIEW - XDP_FE_ATTRIBUTE_VAL_TL#

[top of page]

Table: XDP_FE_CMD_AUD_TRAILS

Description: FE Command Audit Trail
Primary Key: XDP_FE_CMD_AUD_TRAILS_PK
  1. FA_INSTANCE_ID
  2. FE_COMMAND_SEQ
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_CMD_AUD_TRAILS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST

[top of page]

XDP.XDP_FE_CMD_AUD_TRAILS does not reference any database object

XDP.XDP_FE_CMD_AUD_TRAILS is referenced by following:

XDP
VIEW - XDP_FE_CMD_AUD_TRAILS#

[top of page]

Table: XDP_FE_GENERIC_CONFIG

Description: Fulfillment Element Generic Config definition.
Primary Key: XDP_FE_GENERIC_CONFIG_PK
  1. FE_GENERIC_CONFIG_ID
Primary Key: XDP_FE_GENERIC_CONFIG_UK1
  1. FE_ID
  2. START_DATE
Primary Key: XDP_FE_GENERIC_CONFIG_UK2
  1. FE_ID
  2. FE_SW_GEN_LOOKUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_GENERIC_CONFIG.FE_ID XDP_FES
XDP_FE_GENERIC_CONFIG.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP
XDP_FE_GENERIC_CONFIG.SW_START_PROC XDP_PROC_BODY
XDP_FE_GENERIC_CONFIG.SW_EXIT_PROC XDP_PROC_BODY
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FE_ATTRIBUTE_VAL.FE_GENERIC_CONFIG_ID XDP_FE_GENERIC_CONFIG

[top of page]

XDP.XDP_FE_GENERIC_CONFIG does not reference any database object

XDP.XDP_FE_GENERIC_CONFIG is referenced by following:

XDP
VIEW - XDP_FE_GENERIC_CONFIG#

[top of page]

Table: XDP_FE_SW_GEN_LOOKUP

Description: Software Generic Lookup
Primary Key: XDP_FE_SW_GEN_LOOKUP_PK
  1. FE_SW_GEN_LOOKUP_ID
Primary Key: XDP_FE_SW_GEN_LOOKUP_UK1
  1. FETYPE_ID
  2. SW_GENERIC
  3. ADAPTER_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_SW_GEN_LOOKUP.SW_START_PROC XDP_PROC_BODY
XDP_FE_SW_GEN_LOOKUP.SW_EXIT_PROC XDP_PROC_BODY
XDP_FE_SW_GEN_LOOKUP.FETYPE_ID XDP_FE_TYPES
XDP_FE_SW_GEN_LOOKUP.ADAPTER_TYPE XDP_ADAPTER_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FA_FULFILLMENT_PROC.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP
XDP_FE_ATTRIBUTE_DEF.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP
XDP_FE_GENERIC_CONFIG.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP
XDP_FE_SW_GEN_LOOKUP_TL.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP

[top of page]

XDP.XDP_FE_SW_GEN_LOOKUP does not reference any database object

XDP.XDP_FE_SW_GEN_LOOKUP is referenced by following:

XDP
VIEW - XDP_FE_SW_GEN_LOOKUP#

[top of page]

Table: XDP_FE_SW_GEN_LOOKUP_TL

Description: Software Generic Lookup
Primary Key: XDP_FE_SW_GEN_LOOKUP_TL_PK
  1. FE_SW_GEN_LOOKUP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_SW_GEN_LOOKUP_TL.FE_SW_GEN_LOOKUP_ID XDP_FE_SW_GEN_LOOKUP

[top of page]

XDP.XDP_FE_SW_GEN_LOOKUP_TL does not reference any database object

XDP.XDP_FE_SW_GEN_LOOKUP_TL is referenced by following:

XDP
VIEW - XDP_FE_SW_GEN_LOOKUP_TL#

[top of page]

Table: XDP_FE_TYPES

Description: Fulfillment Element Type definition
Primary Key: XDP_FE_TYPES_PK
  1. FETYPE_ID
Primary Key: XDP_FE_TYPES_UK1
  1. FULFILLMENT_ELEMENT_TYPE
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FES.FETYPE_ID XDP_FE_TYPES
XDP_FE_SW_GEN_LOOKUP.FETYPE_ID XDP_FE_TYPES
XDP_FE_TYPES_TL.FETYPE_ID XDP_FE_TYPES

[top of page]

XDP.XDP_FE_TYPES does not reference any database object

XDP.XDP_FE_TYPES is referenced by following:

XDP
VIEW - XDP_FE_TYPES#

[top of page]

Table: XDP_FE_TYPES_TL

Description: Fulfillment Element Type definition
Primary Key: XDP_FE_TYPES_TL_PK
  1. FETYPE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FE_TYPES_TL.FETYPE_ID XDP_FE_TYPES

[top of page]

XDP.XDP_FE_TYPES_TL does not reference any database object

XDP.XDP_FE_TYPES_TL is referenced by following:

XDP
VIEW - XDP_FE_TYPES_TL#

[top of page]

Table: XDP_FMC_AUDIT_TRAILS

Description: This table stores the reponses from the upstream system regarding a service fulfillment error
Primary Key: XDP_FMC_AUDIT_TRAILS_PK
  1. FMC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FMC_AUDIT_TRAILS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FMC_AUD_TRAIL_DETS.FMC_ID XDP_FMC_AUDIT_TRAILS

[top of page]

XDP.XDP_FMC_AUDIT_TRAILS does not reference any database object

XDP.XDP_FMC_AUDIT_TRAILS is referenced by following:

XDP
VIEW - XDP_FMC_AUDIT_TRAILS#

[top of page]

Table: XDP_FMC_AUD_TRAIL_DETS

Description: This table contains the history of the service parameter value change for a faulty order.
Primary Key: XDP_FMC_AUD_TRAIL_DETS_PK
  1. FMC_ID
  2. PARAMETER_TYPE
  3. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FMC_AUD_TRAIL_DETS.FMC_ID XDP_FMC_AUDIT_TRAILS

[top of page]

XDP.XDP_FMC_AUD_TRAIL_DETS does not reference any database object

XDP.XDP_FMC_AUD_TRAIL_DETS is referenced by following:

XDP
VIEW - XDP_FMC_AUD_TRAIL_DETS#

[top of page]

Table: XDP_FULFILL_ACTIONS

Description: Fulfillment Action definition
Primary Key: XDP_FULFILL_ACTIONS_PK
  1. FULFILLMENT_ACTION_ID
Primary Key: XDP_FULFILL_ACTIONS_UK1
  1. FULFILLMENT_ACTION
  2. VERSION
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FULFILL_ACTIONS.FE_ROUTING_PROC XDP_PROC_BODY
XDP_FULFILL_ACTIONS.EVALUATE_PARAM_PROC XDP_PROC_BODY
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FA_FULFILLMENT_PROC.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_FA_PARAMETERS.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_FA_RUNTIME_LIST.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_FULFILL_ACTIONS_TL.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_WI_FA_MAPPING.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS

[top of page]

XDP.XDP_FULFILL_ACTIONS does not reference any database object

XDP.XDP_FULFILL_ACTIONS is referenced by following:

XDP
VIEW - XDP_FULFILL_ACTIONS#

[top of page]

Table: XDP_FULFILL_ACTIONS_TL

Description: MLS (Multi-Language Support) for the XDP_ FULFILLMENT_ACTIONS table
Primary Key: XDP_FULFILL_ACTIONS_TL_PK
  1. FULFILLMENT_ACTION_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FULFILL_ACTIONS_TL.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS

[top of page]

XDP.XDP_FULFILL_ACTIONS_TL does not reference any database object

XDP.XDP_FULFILL_ACTIONS_TL is referenced by following:

XDP
VIEW - XDP_FULFILL_ACTIONS_TL#

[top of page]

Table: XDP_FULFILL_WORKLIST

Description: This table identifies a list of services that need to be fulfilled for the given order
Primary Key: XDP_FULFILL_WORKLIST_PK
  1. WORKITEM_INSTANCE_ID
Primary Key: XDP_FULFILL_WORKLIST_UK1
  1. WORKITEM_INSTANCE_ID
  2. WORKITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_FULFILL_WORKLIST.LINE_ITEM_ID XDP_ORDER_LINE_ITEMS
XDP_FULFILL_WORKLIST.ORDER_ID
XDP_FULFILL_WORKLIST.LINE_NUMBER 		XDP_ORDER_LINE_ITEMS
XDP_FULFILL_WORKLIST.WORKITEM_ID XDP_WORKITEMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FA_RUNTIME_LIST.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
XDP_FMC_AUDIT_TRAILS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
XDP_WI_RELATIONSHIPS.RELATED_WI_INSTANCE_ID XDP_FULFILL_WORKLIST
XDP_WI_RELATIONSHIPS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
XDP_WORKLIST_DETAILS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
XNP_CALLBACK_EVENTS.WI_INSTANCE_ID XDP_FULFILL_WORKLIST
XNP_MSGS.WI_INSTANCE_ID XDP_FULFILL_WORKLIST
XNP_SV_ORDER_MAPPINGS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
XNP_TIMER_REGISTRY.WI_INSTANCE_ID XDP_FULFILL_WORKLIST

[top of page]

XDP.XDP_FULFILL_WORKLIST does not reference any database object

XDP.XDP_FULFILL_WORKLIST is referenced by following:

XDP
VIEW - XDP_FULFILL_WORKLIST#

[top of page]

Table: XDP_LINE_RELATIONSHIPS

Description: XDP_LINE_RELATIONSHIPS table is used to identify whether a line item is part of a package line
Primary Key: XDP_LINE_RELATIONSHIPS_PK
  1. LINE_ITEM_ID
  2. RELATED_LINE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_LINE_RELATIONSHIPS.LINE_ITEM_ID XDP_ORDER_LINE_ITEMS
XDP_LINE_RELATIONSHIPS.RELATED_LINE_ITEM_ID XDP_ORDER_LINE_ITEMS

[top of page]

XDP.XDP_LINE_RELATIONSHIPS does not reference any database object

XDP.XDP_LINE_RELATIONSHIPS is referenced by following:

XDP
VIEW - XDP_LINE_RELATIONSHIPS#

[top of page]

Table: XDP_OE_ORDER_HEADERS

Description: XDP_OE_ORDER_HEADERS contains the order header information for orders generated by Oracle SFM -Order Entry Interface.
Primary Key: XDP_OE_ORDER_HEADERS_UK
  1. ORDER_NUMBER
  2. ORDER_VERSION
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_OE_ORDER_LINES.ORDER_NUMBER
XDP_OE_ORDER_LINES.ORDER_VERSION 		XDP_OE_ORDER_HEADERS
XDP_OE_ORDER_PARAMETERS.ORDER_NUMBER
XDP_OE_ORDER_PARAMETERS.ORDER_VERSION 		XDP_OE_ORDER_HEADERS

[top of page]

XDP.XDP_OE_ORDER_HEADERS does not reference any database object

XDP.XDP_OE_ORDER_HEADERS is referenced by following:

XDP
VIEW - XDP_OE_ORDER_HEADERS#

[top of page]

Table: XDP_OE_ORDER_LINES

Description: XDP_OE_ORDER_LINES contains all the order line information for an order which is generated by Oracle SFM - Order Entry interface.
Primary Key: XDP_OE_ORDER_LINES_UK1
  1. ORDER_NUMBER
  2. ORDER_VERSION
  3. LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_OE_ORDER_LINES.ORDER_NUMBER
XDP_OE_ORDER_LINES.ORDER_VERSION 		XDP_OE_ORDER_HEADERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_OE_ORDER_LINE_DETS.ORDER_NUMBER
XDP_OE_ORDER_LINE_DETS.ORDER_VERSION
XDP_OE_ORDER_LINE_DETS.LINE_NUMBER 		XDP_OE_ORDER_LINES

[top of page]

XDP.XDP_OE_ORDER_LINES does not reference any database object

XDP.XDP_OE_ORDER_LINES is referenced by following:

XDP
VIEW - XDP_OE_ORDER_LINES#

[top of page]

Table: XDP_OE_ORDER_LINE_DETS

Description: The table XDP_OE_ORDER_LINE_DETAILS contains the order line parameter values for an order which is generated by SFM- Order Entry interface.
Primary Key: XDP_OE_ORDER_LINE_DETS_UK1
  1. ORDER_NUMBER
  2. ORDER_VERSION
  3. LINE_NUMBER
  4. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_OE_ORDER_LINE_DETS.ORDER_NUMBER
XDP_OE_ORDER_LINE_DETS.ORDER_VERSION
XDP_OE_ORDER_LINE_DETS.LINE_NUMBER 		XDP_OE_ORDER_LINES

[top of page]

XDP.XDP_OE_ORDER_LINE_DETS does not reference any database object

XDP.XDP_OE_ORDER_LINE_DETS is referenced by following:

XDP
VIEW - XDP_OE_ORDER_LINE_DETS#

[top of page]

Table: XDP_OE_ORDER_PARAMETERS

Description: XDP_OE_ORDER_PARAMETERS contains all the order parameters for an order which is generated by SFM - Order Entry interface.
Primary Key: XDP_OE_ORDER_PARAMETERS_UK
  1. ORDER_NUMBER
  2. ORDER_VERSION
  3. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_OE_ORDER_PARAMETERS.ORDER_NUMBER
XDP_OE_ORDER_PARAMETERS.ORDER_VERSION 		XDP_OE_ORDER_HEADERS

[top of page]

XDP.XDP_OE_ORDER_PARAMETERS does not reference any database object

XDP.XDP_OE_ORDER_PARAMETERS is referenced by following:

XDP
VIEW - XDP_OE_ORDER_PARAMETERS#

[top of page]

Table: XDP_ORDER_BUNDLES

Description: This table stores all Bundles associated with an order.
Primary Key: XDP_ORDER_BUNDLES_PK
  1. ORDER_ID
  2. BUNDLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ORDER_BUNDLES.ORDER_ID XDP_ORDER_HEADERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_ORDER_LINE_ITEMS.ORDER_ID
XDP_ORDER_LINE_ITEMS.BUNDLE_ID 		XDP_ORDER_BUNDLES

[top of page]

XDP.XDP_ORDER_BUNDLES does not reference any database object

XDP.XDP_ORDER_BUNDLES is referenced by following:

XDP
VIEW - XDP_ORDER_BUNDLES#

[top of page]

Table: XDP_ORDER_HEADERS

Description: Order Headers
Primary Key: XDP_ORDER_HEADERS_PK
  1. ORDER_ID
Primary Key: XDP_ORDER_HEADERS_UK1
  1. EXTERNAL_ORDER_NUMBER
  2. EXTERNAL_ORDER_VERSION
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ORDER_HEADERS.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_ORDER_BUNDLES.ORDER_ID XDP_ORDER_HEADERS
XDP_ORDER_LINE_ITEMS.ORDER_ID XDP_ORDER_HEADERS
XDP_ORDER_PARAMETERS.ORDER_ID XDP_ORDER_HEADERS
XDP_ORDER_RELATIONSHIPS.ORDER_ID XDP_ORDER_HEADERS
XDP_ORDER_RELATIONSHIPS.RELATED_ORDER_ID XDP_ORDER_HEADERS
XNP_CALLBACK_EVENTS.ORDER_ID XDP_ORDER_HEADERS
XNP_MSGS.ORDER_ID XDP_ORDER_HEADERS
XNP_SV_ORDER_MAPPINGS.ORDER_ID XDP_ORDER_HEADERS
XNP_SYNC_REGISTRATION.ORDER_ID XDP_ORDER_HEADERS
XNP_TIMER_REGISTRY.ORDER_ID XDP_ORDER_HEADERS

[top of page]

XDP.XDP_ORDER_HEADERS does not reference any database object

XDP.XDP_ORDER_HEADERS is referenced by following:

XDP
VIEW - XDP_ORDER_HEADERS#

[top of page]

Table: XDP_ORDER_LINEITEM_DETS

Description: Order Line Item Details
Primary Key: XDP_ORDER_LINEITEM_DETS_PK
  1. LINE_ITEM_ID
  2. LINE_PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ORDER_LINEITEM_DETS.LINE_ITEM_ID XDP_ORDER_LINE_ITEMS

[top of page]

XDP.XDP_ORDER_LINEITEM_DETS does not reference any database object

XDP.XDP_ORDER_LINEITEM_DETS is referenced by following:

XDP
VIEW - XDP_ORDER_LINEITEM_DETS#

[top of page]

Table: XDP_ORDER_LINE_ITEMS

Description: Order Line Items
Primary Key: XDP_ORDER_LINE_ITEMS_PK
  1. LINE_ITEM_ID
Primary Key: XDP_ORDER_LINE_ITEMS_UK
  1. ORDER_ID
  2. LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ORDER_LINE_ITEMS.ORDER_ID
XDP_ORDER_LINE_ITEMS.BUNDLE_ID 		XDP_ORDER_BUNDLES
XDP_ORDER_LINE_ITEMS.ORDER_ID XDP_ORDER_HEADERS
XDP_ORDER_LINE_ITEMS.WORKITEM_ID XDP_WORKITEMS
XDP_ORDER_LINE_ITEMS.INVENTORY_ITEM_ID
XDP_ORDER_LINE_ITEMS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID CSI_ITEM_INSTANCES
XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID CSI_T_TXN_LINE_DETAILS
XDP_ORDER_LINE_ITEMS.SITE_USE_ID HZ_CUST_SITE_USES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FULFILL_WORKLIST.LINE_ITEM_ID XDP_ORDER_LINE_ITEMS
XDP_FULFILL_WORKLIST.ORDER_ID
XDP_FULFILL_WORKLIST.LINE_NUMBER 		XDP_ORDER_LINE_ITEMS
XDP_LINE_RELATIONSHIPS.LINE_ITEM_ID XDP_ORDER_LINE_ITEMS
XDP_LINE_RELATIONSHIPS.RELATED_LINE_ITEM_ID XDP_ORDER_LINE_ITEMS
XDP_ORDER_LINEITEM_DETS.LINE_ITEM_ID XDP_ORDER_LINE_ITEMS

[top of page]

XDP.XDP_ORDER_LINE_ITEMS does not reference any database object

XDP.XDP_ORDER_LINE_ITEMS is referenced by following:

XDP
VIEW - XDP_ORDER_LINE_ITEMS#

[top of page]

Table: XDP_ORDER_PARAMETERS

Description: This table holds all parameters related to the order coming from the upstream system (Customer Care, Order Entry). These parameters are Order level parameters.
Primary Key: XDP_ORDER_PARAMETERS_PK
  1. ORDER_ID
  2. ORDER_PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ORDER_PARAMETERS.ORDER_ID XDP_ORDER_HEADERS

[top of page]

XDP.XDP_ORDER_PARAMETERS does not reference any database object

XDP.XDP_ORDER_PARAMETERS is referenced by following:

XDP
VIEW - XDP_ORDER_PARAMETERS#

[top of page]

Table: XDP_ORDER_RELATIONSHIPS

Description: This table holds the relationship between orders.
Primary Key: XDP_ORDER_RELATIONSHIPS_PK
  1. ORDER_ID
  2. RELATED_ORDER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_ORDER_RELATIONSHIPS.ORDER_ID XDP_ORDER_HEADERS
XDP_ORDER_RELATIONSHIPS.RELATED_ORDER_ID XDP_ORDER_HEADERS

[top of page]

XDP.XDP_ORDER_RELATIONSHIPS does not reference any database object

XDP.XDP_ORDER_RELATIONSHIPS is referenced by following:

XDP
VIEW - XDP_ORDER_RELATIONSHIPS#

[top of page]

Table: XDP_PARAMETER_POOL

Description: Not used
Primary Key: XDP_PARAMETER_POOL_PK
  1. PARAMETER_ID
Primary Key: XDP_PARAMETER_POOL_UK1
  1. PARAMETER_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_PARAMETER_POOL_TL.PARAMETER_ID XDP_PARAMETER_POOL

[top of page]

XDP.XDP_PARAMETER_POOL does not reference any database object

XDP.XDP_PARAMETER_POOL is referenced by following:

XDP
VIEW - XDP_PARAMETER_POOL#

[top of page]

Table: XDP_PARAMETER_POOL_TL

Description: Not used
Primary Key: XDP_PARAMETER_POOL_TL_PK
  1. PARAMETER_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_PARAMETER_POOL_TL.PARAMETER_ID XDP_PARAMETER_POOL

[top of page]

XDP.XDP_PARAMETER_POOL_TL does not reference any database object

XDP.XDP_PARAMETER_POOL_TL is referenced by following:

XDP
VIEW - XDP_PARAMETER_POOL_TL#

[top of page]

Table: XDP_PROC_BODY

Description: XDP_PROC_BODY stores the source of all the user defined procedures
Primary Key: XDP_PROC_BODY_PK
  1. PROC_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FA_FULFILLMENT_PROC.FULFILLMENT_PROC XDP_PROC_BODY
XDP_FA_FULFILLMENT_PROC.TEST_PROVISIONING_PROC XDP_PROC_BODY
XDP_FA_PARAMETERS.EVALUATION_PROCEDURE XDP_PROC_BODY
XDP_FA_PARAMETERS.EVALUATION_PROCEDURE XDP_PROC_BODY
XDP_FA_RUNTIME_LIST.PROC_NAME XDP_PROC_BODY
XDP_FE_GENERIC_CONFIG.SW_START_PROC XDP_PROC_BODY
XDP_FE_GENERIC_CONFIG.SW_EXIT_PROC XDP_PROC_BODY
XDP_FE_SW_GEN_LOOKUP.SW_START_PROC XDP_PROC_BODY
XDP_FE_SW_GEN_LOOKUP.SW_EXIT_PROC XDP_PROC_BODY
XDP_FULFILL_ACTIONS.FE_ROUTING_PROC XDP_PROC_BODY
XDP_FULFILL_ACTIONS.EVALUATE_PARAM_PROC XDP_PROC_BODY
XDP_PROC_BODY_TL.PROC_NAME XDP_PROC_BODY
XDP_SERVICE_VAL_ACTS.WI_MAPPING_PROC XDP_PROC_BODY
XDP_WI_PARAMETERS.EVALUATION_PROCEDURE XDP_PROC_BODY
XDP_WI_PARAMETERS.VALIDATION_PROCEDURE XDP_PROC_BODY
XDP_WORKITEMS.FA_EXEC_MAP_PROC XDP_PROC_BODY
XDP_WORKITEMS.WF_EXEC_PROC XDP_PROC_BODY

[top of page]

XDP.XDP_PROC_BODY does not reference any database object

XDP.XDP_PROC_BODY is referenced by following:

XDP
VIEW - XDP_PROC_BODY#

[top of page]

Table: XDP_PROC_BODY_TL

Description: XDP_PROC_BODY_TL is the MLS (Multi-Language Support) table for the XDP_PROC_BODY table
Primary Key: XDP_PROC_BODY_TL_PK
  1. PROC_NAME
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_PROC_BODY_TL.PROC_NAME XDP_PROC_BODY

[top of page]

XDP.XDP_PROC_BODY_TL does not reference any database object

XDP.XDP_PROC_BODY_TL is referenced by following:

XDP
VIEW - XDP_PROC_BODY_TL#

[top of page]

Table: XDP_SERVICES

Description: Not used
Primary Key: XDP_SERVICES_PK
  1. SERVICE_ID
Primary Key: XDP_SERVICES_UK1
  1. SERVICE_NAME
  2. VERSION
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_SERVICES_TL.SERVICE_ID XDP_SERVICES
XDP_SERVICE_PKG_DET.SERVICE_ID XDP_SERVICES
XDP_SERVICE_VAL_ACTS.SERVICE_ID XDP_SERVICES

[top of page]

XDP.XDP_SERVICES does not reference any database object

XDP.XDP_SERVICES is referenced by following:

XDP
VIEW - XDP_SERVICES#

[top of page]

Table: XDP_SERVICES_TL

Description: Not used
Primary Key: XDP_SERVICES_TL_PK
  1. SERVICE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICES_TL.SERVICE_ID XDP_SERVICES

[top of page]

XDP.XDP_SERVICES_TL does not reference any database object

XDP.XDP_SERVICES_TL is referenced by following:

XDP
VIEW - XDP_SERVICES_TL#

[top of page]

Table: XDP_SERVICE_PACKAGES

Description: Not used
Primary Key: XDP_SERVICE_PACKAGES_PK
  1. PACKAGE_ID
Primary Key: XDP_SERVICE_PACKAGES_UK1
  1. PACKAGE_NAME
  2. PACKAGE_VERSION
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_SERVICE_PACKAGES_TL.PACKAGE_ID XDP_SERVICE_PACKAGES
XDP_SERVICE_PKG_DET.PACKAGE_ID XDP_SERVICE_PACKAGES

[top of page]

XDP.XDP_SERVICE_PACKAGES does not reference any database object

XDP.XDP_SERVICE_PACKAGES is referenced by following:

XDP
VIEW - XDP_SERVICE_PACKAGES#

[top of page]

Table: XDP_SERVICE_PACKAGES_TL

Description: Not used
Primary Key: XDP_SERVICE_PACKAGES_TL_PK
  1. PACKAGE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICE_PACKAGES_TL.PACKAGE_ID XDP_SERVICE_PACKAGES

[top of page]

XDP.XDP_SERVICE_PACKAGES_TL does not reference any database object

XDP.XDP_SERVICE_PACKAGES_TL is referenced by following:

XDP
VIEW - XDP_SERVICE_PACKAGES_TL#

[top of page]

Table: XDP_SERVICE_PKG_DET

Description: Not used
Primary Key: XDP_SERVICE_PKG_DET_PK
  1. PACKAGE_ID
  2. SERVICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICE_PKG_DET.PACKAGE_ID XDP_SERVICE_PACKAGES
XDP_SERVICE_PKG_DET.SERVICE_ID XDP_SERVICES
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_SERVICE_PKG_DET_TL.PACKAGE_ID
XDP_SERVICE_PKG_DET_TL.SERVICE_ID 		XDP_SERVICE_PKG_DET

[top of page]

XDP.XDP_SERVICE_PKG_DET does not reference any database object

XDP.XDP_SERVICE_PKG_DET is referenced by following:

XDP
VIEW - XDP_SERVICE_PKG_DET#

[top of page]

Table: XDP_SERVICE_PKG_DET_TL

Description: Not used
Primary Key: XDP_SERVICE_PKG_DET_TL_PK
  1. PACKAGE_ID
  2. SERVICE_ID
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICE_PKG_DET_TL.PACKAGE_ID
XDP_SERVICE_PKG_DET_TL.SERVICE_ID 		XDP_SERVICE_PKG_DET

[top of page]

XDP.XDP_SERVICE_PKG_DET_TL does not reference any database object

XDP.XDP_SERVICE_PKG_DET_TL is referenced by following:

XDP
VIEW - XDP_SERVICE_PKG_DET_TL#

[top of page]

Table: XDP_SERVICE_VAL_ACTS

Description: XDP_SERVICE_VAL_ACTS is used to define the valid service actions for a given service
Primary Key: XDP_SERVICE_VAL_ACTS_PK
  1. SERVICE_VAL_ACT_ID
Primary Key: XDP_SERVICE_VAL_ACTS_UK1
  1. SERVICE_ID
  2. ACTION_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICE_VAL_ACTS.INVENTORY_ITEM_ID
XDP_SERVICE_VAL_ACTS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
XDP_SERVICE_VAL_ACTS.WI_MAPPING_PROC XDP_PROC_BODY
XDP_SERVICE_VAL_ACTS.SERVICE_ID XDP_SERVICES
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_SERVICE_VAL_ACTS_TL.SERVICE_VAL_ACT_ID XDP_SERVICE_VAL_ACTS
XDP_SERVICE_WI_MAP.SERVICE_VAL_ACT_ID XDP_SERVICE_VAL_ACTS

[top of page]

XDP.XDP_SERVICE_VAL_ACTS does not reference any database object

XDP.XDP_SERVICE_VAL_ACTS is referenced by following:

XDP
VIEW - XDP_SERVICE_VAL_ACTS#

[top of page]

Table: XDP_SERVICE_VAL_ACTS_TL

Description: XDP_SERVICE_VAL_ACTS_TL is the MLS (Multi-Language Support) table for the XDP_SERVICE_VAL_ACTS table
Primary Key: XDP_SERVICE_VAL_ACTS_TL_PK
  1. SERVICE_VAL_ACT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICE_VAL_ACTS_TL.SERVICE_VAL_ACT_ID XDP_SERVICE_VAL_ACTS

[top of page]

XDP.XDP_SERVICE_VAL_ACTS_TL does not reference any database object

XDP.XDP_SERVICE_VAL_ACTS_TL is referenced by following:

XDP
VIEW - XDP_SERVICE_VAL_ACTS_TL#

[top of page]

Table: XDP_SERVICE_WI_MAP

Description: XDP_SERVICE_WI_MAP is used to define the list of work items that need to be executed to fulfill the given service action
Primary Key: XDP_SERVICE_WI_MAP_PK
  1. SERVICE_WI_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICE_WI_MAP.SERVICE_VAL_ACT_ID XDP_SERVICE_VAL_ACTS
XDP_SERVICE_WI_MAP.WORKITEM_ID XDP_WORKITEMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_SERVICE_WI_MAP_TL.SERVICE_WI_MAP_ID XDP_SERVICE_WI_MAP

[top of page]

XDP.XDP_SERVICE_WI_MAP does not reference any database object

XDP.XDP_SERVICE_WI_MAP is referenced by following:

XDP
VIEW - XDP_SERVICE_WI_MAP#

[top of page]

Table: XDP_SERVICE_WI_MAP_TL

Description: XDP_SERVICE_WI_MAP_TL is the MLS (Multi-Language Support) table for the XDP_SERVICE_WI_MAP table
Primary Key: XDP_SERVICE_WI_MAP_TL_PK
  1. SERVICE_WI_MAP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_SERVICE_WI_MAP_TL.SERVICE_WI_MAP_ID XDP_SERVICE_WI_MAP

[top of page]

XDP.XDP_SERVICE_WI_MAP_TL does not reference any database object

XDP.XDP_SERVICE_WI_MAP_TL is referenced by following:

XDP
VIEW - XDP_SERVICE_WI_MAP_TL#

[top of page]

Table: XDP_WF_PROCESS_COORD

Description: Workflow process coordination
Primary Key: XDP_WF_PROCESS_COORD_PK
  1. WF_COORDINATION_ID

[top of page]

XDP.XDP_WF_PROCESS_COORD does not reference any database object

XDP.XDP_WF_PROCESS_COORD is referenced by following:

XDP
VIEW - XDP_WF_PROCESS_COORD#

[top of page]

Table: XDP_WI_FA_MAPPING

Description: XDP_WI_FA_MAPPING defines the list of fulfillment actions to be excuted in order to fulfill a work item
Primary Key: XDP_WI_FA_MAPPING_PK
  1. WI_FA_MAPPING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_WI_FA_MAPPING.FULFILLMENT_ACTION_ID XDP_FULFILL_ACTIONS
XDP_WI_FA_MAPPING.WORKITEM_ID XDP_WORKITEMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_WI_FA_MAPPING_TL.WI_FA_MAPPING_ID XDP_WI_FA_MAPPING

[top of page]

XDP.XDP_WI_FA_MAPPING does not reference any database object

XDP.XDP_WI_FA_MAPPING is referenced by following:

XDP
VIEW - XDP_WI_FA_MAPPING#

[top of page]

Table: XDP_WI_FA_MAPPING_TL

Description: XDP_WI_FA_MAPPING_TL is the MLS (Multi-Language Support) table for the XDP_WI_FA_MAPPING table
Primary Key: XDP_WI_FA_MAPPING_TL_PK
  1. WI_FA_MAPPING_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_WI_FA_MAPPING_TL.WI_FA_MAPPING_ID XDP_WI_FA_MAPPING

[top of page]

XDP.XDP_WI_FA_MAPPING_TL does not reference any database object

XDP.XDP_WI_FA_MAPPING_TL is referenced by following:

XDP
VIEW - XDP_WI_FA_MAPPING_TL#

[top of page]

Table: XDP_WI_PARAMETERS

Description: XDP_WI_PARAMETERS holds all the work item parameters and associated properties for a given work item
Primary Key: XDP_WI_PARAMETERS_PK
  1. WORKITEM_ID
  2. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_WI_PARAMETERS.EVALUATION_PROCEDURE XDP_PROC_BODY
XDP_WI_PARAMETERS.VALIDATION_PROCEDURE XDP_PROC_BODY
XDP_WI_PARAMETERS.WORKITEM_ID XDP_WORKITEMS
XDP_WI_PARAMETERS.WORKITEM_ID XDP_WORKITEMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_WORKLIST_DETAILS.WORKITEM_ID
XDP_WORKLIST_DETAILS.PARAMETER_NAME 		XDP_WI_PARAMETERS

[top of page]

XDP.XDP_WI_PARAMETERS does not reference any database object

XDP.XDP_WI_PARAMETERS is referenced by following:

XDP
VIEW - XDP_WI_PARAMETERS#

[top of page]

Table: XDP_WI_RELATIONSHIPS

Description: The table XDP_WI_RELATIONSHIPS hold all the relationships of any work item within an order.
Primary Key: XDP_WI_RELATIONSHIPS_PK
  1. WORKITEM_INSTANCE_ID
  2. RELATED_WI_INSTANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_WI_RELATIONSHIPS.RELATED_WI_INSTANCE_ID XDP_FULFILL_WORKLIST
XDP_WI_RELATIONSHIPS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST

[top of page]

XDP.XDP_WI_RELATIONSHIPS does not reference any database object

XDP.XDP_WI_RELATIONSHIPS is referenced by following:

XDP
VIEW - XDP_WI_RELATIONSHIPS#

[top of page]

Table: XDP_WORKITEMS

Description: XDP_WORKITEMS is used to define a work item
Primary Key: XDP_WORKITEMS_PK
  1. WORKITEM_ID
Primary Key: XDP_WORKITEMS_UK1
  1. WORKITEM_NAME
  2. VERSION
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_WORKITEMS.FA_EXEC_MAP_PROC XDP_PROC_BODY
XDP_WORKITEMS.WF_EXEC_PROC XDP_PROC_BODY
Foreign Keys to this table:
Foreign Key Column Foreign Table
XDP_FULFILL_WORKLIST.WORKITEM_ID XDP_WORKITEMS
XDP_ORDER_LINE_ITEMS.WORKITEM_ID XDP_WORKITEMS
XDP_SERVICE_WI_MAP.WORKITEM_ID XDP_WORKITEMS
XDP_WI_FA_MAPPING.WORKITEM_ID XDP_WORKITEMS
XDP_WI_PARAMETERS.WORKITEM_ID XDP_WORKITEMS
XDP_WI_PARAMETERS.WORKITEM_ID XDP_WORKITEMS
XDP_WORKITEMS_TL.WORKITEM_ID XDP_WORKITEMS
XNS_ACTION_WI_MAPPING.WORKITEM_ID XDP_WORKITEMS

[top of page]

XDP.XDP_WORKITEMS does not reference any database object

XDP.XDP_WORKITEMS is referenced by following:

XDP
VIEW - XDP_WORKITEMS#

[top of page]

Table: XDP_WORKITEMS_TL

Description: XDP_WORKITEMS_TL is the MLS table (Multi-Language Support) for the XDP_WORKITEMS table
Primary Key: XDP_WORKITEMS_TL_PK
  1. WORKITEM_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_WORKITEMS_TL.WORKITEM_ID XDP_WORKITEMS

[top of page]

XDP.XDP_WORKITEMS_TL does not reference any database object

XDP.XDP_WORKITEMS_TL is referenced by following:

XDP
VIEW - XDP_WORKITEMS_TL#

[top of page]

Table: XDP_WORKLIST_DETAILS

Description: Fulfillment Worklist Details
Primary Key: XDP_WORKLIST_DETAILS_PK
  1. WORKITEM_INSTANCE_ID
  2. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XDP_WORKLIST_DETAILS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST
XDP_WORKLIST_DETAILS.WORKITEM_ID
XDP_WORKLIST_DETAILS.PARAMETER_NAME 		XDP_WI_PARAMETERS
XDP_WORKLIST_DETAILS.TXN_ATTRIB_DETAIL_ID CSI_T_EXTEND_ATTRIBS
XDP_WORKLIST_DETAILS.ATTRIB_SOURCE_ID CSI_I_EXTENDED_ATTRIBS
XDP_WORKLIST_DETAILS.ATTRIB_SOURCE_ID CSI_IEA_VALUES

[top of page]

XDP.XDP_WORKLIST_DETAILS does not reference any database object

XDP.XDP_WORKLIST_DETAILS is referenced by following:

XDP
VIEW - XDP_WORKLIST_DETAILS#

[top of page]

View: XDP_ACTION_CODES_V

[top of page]

APPS.XDP_ACTION_CODES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OE_TRANSACTION_TYPES_ALL
SYNONYM - OE_TRANSACTION_TYPES_TL

APPS.XDP_ACTION_CODES_V is not referenced by any database object

[top of page]

View: XDP_ADAPTER_ADMIN_REQS_V

[top of page]

APPS.XDP_ADAPTER_ADMIN_REQS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - XDP_ADAPTER_ADMIN_REQS
SYNONYM - XDP_ADAPTER_REG
VIEW - XDP_ADAPTER_TYPE_REQ_TYPES_V
PUBLIC
SYNONYM - DBA_JOBS
- DBA_JOBS

APPS.XDP_ADAPTER_ADMIN_REQS_V is not referenced by any database object

[top of page]

View: XDP_ADAPTER_AUDIT_V

[top of page]

APPS.XDP_ADAPTER_AUDIT_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - XDP_ADAPTER_AUDIT
VIEW - XDP_ADAPTER_TYPE_REQ_TYPES_V

APPS.XDP_ADAPTER_AUDIT_V is not referenced by any database object

[top of page]

View: XDP_ADAPTER_JOB_QUEUE_V

[top of page]

APPS.XDP_ADAPTER_JOB_QUEUE_V references the following:

APPS
SYNONYM - XDP_ADAPTER_JOB_QUEUE

APPS.XDP_ADAPTER_JOB_QUEUE_V is not referenced by any database object

[top of page]

View: XDP_ADAPTER_REG_V

[top of page]

APPS.XDP_ADAPTER_REG_V references the following:

APPS
SYNONYM - FND_CONCURRENT_QUEUES
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - XDP_ADAPTER_REG
VIEW - XDP_ADAPTER_TYPES_VL
VIEW - XDP_FES_VL

APPS.XDP_ADAPTER_REG_V is not referenced by any database object

[top of page]

View: XDP_ADAPTER_SUMMARY_V

[top of page]

APPS.XDP_ADAPTER_SUMMARY_V references the following:

APPS
SYNONYM - XDP_ADAPTER_JOB_QUEUE
SYNONYM - XDP_ADAPTER_REG
SYNONYM - XDP_FE_GENERIC_CONFIG
SYNONYM - XDP_FE_SW_GEN_LOOKUP
SYNONYM - XDP_FE_TYPES
- XDP_FES_VL

APPS.XDP_ADAPTER_SUMMARY_V is not referenced by any database object

[top of page]

View: XDP_ADAPTER_TYPES_VL

[top of page]

APPS.XDP_ADAPTER_TYPES_VL references the following:

APPS
SYNONYM - XDP_ADAPTER_TYPES_B
SYNONYM - XDP_ADAPTER_TYPES_TL
APPS.XDP_ADAPTER_TYPES_VL is referenced by following:

APPS
VIEW - XDP_ADAPTER_REG_V
VIEW - XDP_FE_GENERIC_CONFIG_V

[top of page]

View: XDP_ADAPTER_TYPE_ATTRS_VL

[top of page]

APPS.XDP_ADAPTER_TYPE_ATTRS_VL references the following:

APPS
SYNONYM - XDP_ADAPTER_TYPE_ATTRS_B
SYNONYM - XDP_ADAPTER_TYPE_ATTRS_TL

APPS.XDP_ADAPTER_TYPE_ATTRS_VL is not referenced by any database object

[top of page]

View: XDP_ADAPTER_TYPE_REQ_TYPES_V

[top of page]

APPS.XDP_ADAPTER_TYPE_REQ_TYPES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - XDP_ADAPTER_TYPES_B
APPS.XDP_ADAPTER_TYPE_REQ_TYPES_V is referenced by following:

APPS
VIEW - XDP_ADAPTER_ADMIN_REQS_V
VIEW - XDP_ADAPTER_AUDIT_V

[top of page]

View: XDP_ADAPTER_TYPE_V

[top of page]

APPS.XDP_ADAPTER_TYPE_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - XDP_ADAPTER_REG

APPS.XDP_ADAPTER_TYPE_V is not referenced by any database object

[top of page]

View: XDP_DQ_CONFIGURATION_VL

[top of page]

APPS.XDP_DQ_CONFIGURATION_VL references the following:

APPS
SYNONYM - XDP_DQ_CONFIGURATION
SYNONYM - XDP_DQ_CONFIGURATION_TL

APPS.XDP_DQ_CONFIGURATION_VL is not referenced by any database object

[top of page]

View: XDP_ERROR_LOG_V

[top of page]

APPS.XDP_ERROR_LOG_V references the following:

APPS
PACKAGE - XDP_ERRORS_PKG
SYNONYM - XDP_ERROR_LOG

APPS.XDP_ERROR_LOG_V is not referenced by any database object

[top of page]

View: XDP_EVENTS_V

[top of page]

APPS.XDP_EVENTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
PACKAGE - XDP_SYSCN_UTIL
SYNONYM - XNP_IN_EVT_QTAB
SYNONYM - XNP_MSGS
- XDP_FES_VL

APPS.XDP_EVENTS_V is not referenced by any database object

[top of page]

View: XDP_FA_PARAMETERS_DISP_V

[top of page]

APPS.XDP_FA_PARAMETERS_DISP_V references the following:

APPS
VIEW - CSI_LOOKUPS
SYNONYM - XDP_FA_PARAMETERS

APPS.XDP_FA_PARAMETERS_DISP_V is not referenced by any database object

[top of page]

View: XDP_FA_PARAMETERS_V

[top of page]

APPS.XDP_FA_PARAMETERS_V references the following:

APPS
SYNONYM - XDP_FA_PARAMETERS

APPS.XDP_FA_PARAMETERS_V is not referenced by any database object

[top of page]

View: XDP_FES_VL

[top of page]

APPS.XDP_FES_VL references the following:

APPS
SYNONYM - XDP_FES
SYNONYM - XDP_FES_TL
APPS.XDP_FES_VL is referenced by following:

APPS
VIEW - XDP_ADAPTER_REG_V
VIEW - XDP_FE_GENERIC_CONFIG_V
VIEW - XDP_FE_SUMMARY_V
VIEW - XDP_INBOUND_MESSAGES_V
VIEW - XDP_OUTBOUND_MESSAGES_V

[top of page]

View: XDP_FE_ATTRIBUTE_DEF_VL

[top of page]

APPS.XDP_FE_ATTRIBUTE_DEF_VL references the following:

APPS
SYNONYM - XDP_FE_ATTRIBUTE_DEF
SYNONYM - XDP_FE_ATTRIBUTE_DEF_TL

APPS.XDP_FE_ATTRIBUTE_DEF_VL is not referenced by any database object

[top of page]

View: XDP_FE_ATTRIBUTE_VAL_VL

[top of page]

APPS.XDP_FE_ATTRIBUTE_VAL_VL references the following:

APPS
SYNONYM - XDP_FE_ATTRIBUTE_VAL
SYNONYM - XDP_FE_ATTRIBUTE_VAL_TL

APPS.XDP_FE_ATTRIBUTE_VAL_VL is not referenced by any database object

[top of page]

View: XDP_FE_GENERIC_CONFIG_V

[top of page]

APPS.XDP_FE_GENERIC_CONFIG_V references the following:

APPS
VIEW - XDP_ADAPTER_TYPES_VL
VIEW - XDP_FES_VL
SYNONYM - XDP_FE_GENERIC_CONFIG
VIEW - XDP_FE_SW_GEN_LOOKUP_VL

APPS.XDP_FE_GENERIC_CONFIG_V is not referenced by any database object

[top of page]

View: XDP_FE_SUMMARY_V

[top of page]

APPS.XDP_FE_SUMMARY_V references the following:

APPS
SYNONYM - XDP_ADAPTER_REG
SYNONYM - XDP_ADAPTER_TYPES_B
VIEW - XDP_FES_VL

APPS.XDP_FE_SUMMARY_V is not referenced by any database object

[top of page]

View: XDP_FE_SW_GEN_LOOKUP_VL

[top of page]

APPS.XDP_FE_SW_GEN_LOOKUP_VL references the following:

APPS
SYNONYM - XDP_FE_SW_GEN_LOOKUP
SYNONYM - XDP_FE_SW_GEN_LOOKUP_TL
APPS.XDP_FE_SW_GEN_LOOKUP_VL is referenced by following:

APPS
VIEW - XDP_FE_GENERIC_CONFIG_V

[top of page]

View: XDP_FE_TYPES_VL

[top of page]

APPS.XDP_FE_TYPES_VL references the following:

APPS
SYNONYM - XDP_FE_TYPES
SYNONYM - XDP_FE_TYPES_TL

APPS.XDP_FE_TYPES_VL is not referenced by any database object

[top of page]

View: XDP_FMC_V

[top of page]

APPS.XDP_FMC_V references the following:

APPS
VIEW - WF_LOOKUPS
SYNONYM - WF_NOTIFICATIONS

APPS.XDP_FMC_V is not referenced by any database object

[top of page]

View: XDP_FULFILL_ACTIONS_VL

[top of page]

APPS.XDP_FULFILL_ACTIONS_VL references the following:

APPS
SYNONYM - XDP_FULFILL_ACTIONS
SYNONYM - XDP_FULFILL_ACTIONS_TL
APPS.XDP_FULFILL_ACTIONS_VL is referenced by following:

APPS
VIEW - XDP_ORU_ORDERS_V
VIEW - XDP_READY_FAS_V
VIEW - XDP_READY_FES_V
VIEW - XDP_WAITING_FES_V

[top of page]

View: XDP_INBOUND_MESSAGES_V

[top of page]

APPS.XDP_INBOUND_MESSAGES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - XDP_FES_VL
PACKAGE - XDP_SYSCN_UTIL
SYNONYM - XNP_IN_MSG_QTAB
SYNONYM - XNP_MSGS

APPS.XDP_INBOUND_MESSAGES_V is not referenced by any database object

[top of page]

View: XDP_LOOKUPS

[top of page]

APPS.XDP_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES

APPS.XDP_LOOKUPS is not referenced by any database object

[top of page]

View: XDP_OE_ORDER_DETAILS_V

[top of page]

APPS.XDP_OE_ORDER_DETAILS_V references the following:

APPS
SYNONYM - XDP_OE_ORDER_HEADERS
SYNONYM - XDP_OE_ORDER_LINES

APPS.XDP_OE_ORDER_DETAILS_V is not referenced by any database object

[top of page]

View: XDP_ORDER_DETAILS_V

[top of page]

APPS.XDP_ORDER_DETAILS_V references the following:

APPS
SYNONYM - XDP_FULFILL_WORKLIST
SYNONYM - XDP_ORDER_HEADERS
SYNONYM - XDP_ORDER_LINE_ITEMS
SYNONYM - XDP_WORKITEMS

APPS.XDP_ORDER_DETAILS_V is not referenced by any database object

[top of page]

View: XDP_ORU_ORDERS_V

[top of page]

APPS.XDP_ORU_ORDERS_V references the following:

APPS
SYNONYM - XDP_FA_RUNTIME_LIST
VIEW - XDP_FULFILL_ACTIONS_VL
SYNONYM - XDP_FULFILL_WORKLIST
SYNONYM - XDP_ORDER_HEADERS
SYNONYM - XDP_ORDER_LINE_ITEMS
VIEW - XDP_WORKITEMS_VL

APPS.XDP_ORU_ORDERS_V is not referenced by any database object

[top of page]

View: XDP_OUTBOUND_MESSAGES_V

[top of page]

APPS.XDP_OUTBOUND_MESSAGES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - XDP_FES_VL
PACKAGE - XDP_SYSCN_UTIL
SYNONYM - XNP_MSGS
SYNONYM - XNP_OUT_MSG_QTAB
SYS
PACKAGE - STANDARD
SYSTEM
TYPE - XNP_MESSAGE_TYPE

APPS.XDP_OUTBOUND_MESSAGES_V is not referenced by any database object

[top of page]

View: XDP_PARAMETER_POOL_VL

[top of page]

APPS.XDP_PARAMETER_POOL_VL references the following:

APPS
VIEW - CSI_LOOKUPS

APPS.XDP_PARAMETER_POOL_VL is not referenced by any database object

[top of page]

View: XDP_PROC_BODY_VL

[top of page]

APPS.XDP_PROC_BODY_VL references the following:

APPS
SYNONYM - XDP_PROC_BODY
SYNONYM - XDP_PROC_BODY_TL

APPS.XDP_PROC_BODY_VL is not referenced by any database object

[top of page]

View: XDP_PROFILE_OPTIONS_V

[top of page]

APPS.XDP_PROFILE_OPTIONS_V references the following:

APPS
SYNONYM - FND_PROFILE_OPTIONS
SYNONYM - FND_PROFILE_OPTIONS_TL
SYNONYM - FND_PROFILE_OPTION_VALUES

APPS.XDP_PROFILE_OPTIONS_V is not referenced by any database object

[top of page]

View: XDP_READY_FAS_V

[top of page]

APPS.XDP_READY_FAS_V references the following:

APPS
SYNONYM - XDP_FA_QTAB
SYNONYM - XDP_FA_RUNTIME_LIST
VIEW - XDP_FULFILL_ACTIONS_VL
SYNONYM - XDP_FULFILL_WORKLIST
SYNONYM - XDP_ORDER_HEADERS
PACKAGE - XDP_SYSCN_UTIL
VIEW - XDP_WORKITEMS_VL

APPS.XDP_READY_FAS_V is not referenced by any database object

[top of page]

View: XDP_READY_FES_V

[top of page]

APPS.XDP_READY_FES_V references the following:

APPS
SYNONYM - XDP_FA_RUNTIME_LIST
VIEW - XDP_FULFILL_ACTIONS_VL
SYNONYM - XDP_FULFILL_WORKLIST
SYNONYM - XDP_ORDER_HEADERS
PACKAGE - XDP_SYSCN_UTIL
SYNONYM - XDP_WF_CHANNEL_QTAB
- XDP_FES_VL
- XDP_WORKITEMS_VL

APPS.XDP_READY_FES_V is not referenced by any database object

[top of page]

View: XDP_READY_ORDER_V

[top of page]

APPS.XDP_READY_ORDER_V references the following:

APPS
SYNONYM - XDP_ORDER_HEADERS
SYNONYM - XDP_ORDER_PROCESSOR_QTAB
PACKAGE - XDP_SYSCN_UTIL

APPS.XDP_READY_ORDER_V is not referenced by any database object

[top of page]

View: XDP_READY_WORKITEM_V

[top of page]

APPS.XDP_READY_WORKITEM_V references the following:

APPS
SYNONYM - XDP_FULFILL_WORKLIST
SYNONYM - XDP_ORDER_HEADERS
PACKAGE - XDP_SYSCN_UTIL
SYNONYM - XDP_WORKITEM_QTAB
- XDP_WORKITEMS_VL

APPS.XDP_READY_WORKITEM_V is not referenced by any database object

[top of page]

View: XDP_SERVICE_VAL_ACTS_VL

[top of page]

APPS.XDP_SERVICE_VAL_ACTS_VL references the following:

APPS
SYNONYM - XDP_SERVICE_VAL_ACTS
SYNONYM - XDP_SERVICE_VAL_ACTS_TL

APPS.XDP_SERVICE_VAL_ACTS_VL is not referenced by any database object

[top of page]

View: XDP_SERVICE_WI_MAP_VL

[top of page]

APPS.XDP_SERVICE_WI_MAP_VL references the following:

APPS
SYNONYM - XDP_SERVICE_WI_MAP
SYNONYM - XDP_SERVICE_WI_MAP_TL

APPS.XDP_SERVICE_WI_MAP_VL is not referenced by any database object

[top of page]

View: XDP_SUMMARY_QUEUES_V

[top of page]

APPS.XDP_SUMMARY_QUEUES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
- XDP_DQ_CONFIGURATION_VL

APPS.XDP_SUMMARY_QUEUES_V is not referenced by any database object

[top of page]

View: XDP_SVE_PKG_DET_DISP_V

[top of page]

APPS.XDP_SVE_PKG_DET_DISP_V references the following:

APPS
SYNONYM - XDP_SERVICES
SYNONYM - XDP_SERVICES_TL
SYNONYM - XDP_SERVICE_PKG_DET
SYNONYM - XDP_SERVICE_PKG_DET_TL

APPS.XDP_SVE_PKG_DET_DISP_V is not referenced by any database object

[top of page]

View: XDP_SVE_VAL_ACTION_DISP_V

[top of page]

APPS.XDP_SVE_VAL_ACTION_DISP_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - OE_TRANSACTION_TYPES_TL
SYNONYM - XDP_SERVICE_VAL_ACTS
SYNONYM - XDP_SERVICE_VAL_ACTS_TL

APPS.XDP_SVE_VAL_ACTION_DISP_V is not referenced by any database object

[top of page]

View: XDP_SVE_WI_MAPPING_DISP_V

[top of page]

APPS.XDP_SVE_WI_MAPPING_DISP_V references the following:

APPS
SYNONYM - XDP_SERVICE_VAL_ACTS
SYNONYM - XDP_SERVICE_WI_MAP
SYNONYM - XDP_SERVICE_WI_MAP_TL
SYNONYM - XDP_WORKITEMS
SYNONYM - XDP_WORKITEMS_TL

APPS.XDP_SVE_WI_MAPPING_DISP_V is not referenced by any database object

[top of page]

View: XDP_WAITING_FES_V

[top of page]

APPS.XDP_WAITING_FES_V references the following:

APPS
SYNONYM - XDP_ADAPTER_JOB_QUEUE
SYNONYM - XDP_FA_RUNTIME_LIST
VIEW - XDP_FULFILL_ACTIONS_VL
SYNONYM - XDP_FULFILL_WORKLIST
SYNONYM - XDP_ORDER_HEADERS
- XDP_FES_VL
- XDP_WORKITEMS_VL

APPS.XDP_WAITING_FES_V is not referenced by any database object

[top of page]

View: XDP_WI_FA_MAPPING_DISP_V

[top of page]

APPS.XDP_WI_FA_MAPPING_DISP_V references the following:

APPS
SYNONYM - XDP_FULFILL_ACTIONS
SYNONYM - XDP_FULFILL_ACTIONS_TL
SYNONYM - XDP_WI_FA_MAPPING
SYNONYM - XDP_WI_FA_MAPPING_TL

APPS.XDP_WI_FA_MAPPING_DISP_V is not referenced by any database object

[top of page]

View: XDP_WI_FA_MAPPING_VL

[top of page]

APPS.XDP_WI_FA_MAPPING_VL references the following:

APPS
SYNONYM - XDP_WI_FA_MAPPING
SYNONYM - XDP_WI_FA_MAPPING_TL

APPS.XDP_WI_FA_MAPPING_VL is not referenced by any database object

[top of page]

View: XDP_WI_PARAMETERS_DISP_V

[top of page]

APPS.XDP_WI_PARAMETERS_DISP_V references the following:

APPS
VIEW - CSI_LOOKUPS
SYNONYM - XDP_WI_PARAMETERS

APPS.XDP_WI_PARAMETERS_DISP_V is not referenced by any database object

[top of page]

View: XDP_WORKITEMS_VL

[top of page]

APPS.XDP_WORKITEMS_VL references the following:

APPS
SYNONYM - XDP_WORKITEMS
SYNONYM - XDP_WORKITEMS_TL
APPS.XDP_WORKITEMS_VL is referenced by following:

APPS
VIEW - XDP_ORU_ORDERS_V
VIEW - XDP_READY_FAS_V

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