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

TABLE - IEU.IEU_CLI_PROV_PLUGINS
TABLE - IEU.IEU_CLI_PROV_PLUGIN_MED_MAPS
TABLE - IEU.IEU_CTL_PLUGINS_B
TABLE - IEU.IEU_CTL_PLUGINS_TL
TABLE - IEU.IEU_MSG_MESSAGES
TABLE - IEU.IEU_SH_ACTIVITIES
TABLE - IEU.IEU_SH_ACT_TYPES_B
TABLE - IEU.IEU_SH_ACT_TYPES_TL
TABLE - IEU.IEU_SH_SESSIONS
TABLE - IEU.IEU_UWQM_AUDIT_LOG
TABLE - IEU.IEU_UWQM_ITEMS
TABLE - IEU.IEU_UWQM_PRIORITIES_B
TABLE - IEU.IEU_UWQM_PRIORITIES_TL
TABLE - IEU.IEU_UWQM_WORK_SOURCES_B
TABLE - IEU.IEU_UWQM_WORK_SOURCES_TL
TABLE - IEU.IEU_UWQM_WS_ASSCT_PROPS
TABLE - IEU.IEU_UWQ_AGENT_BINDINGS
TABLE - IEU.IEU_UWQ_CLI_MED_PLUGINS
TABLE - IEU.IEU_UWQ_LOGIN_RULES_B
TABLE - IEU.IEU_UWQ_LOGIN_RULES_TL
TABLE - IEU.IEU_UWQ_MACTION_DEFS_B
TABLE - IEU.IEU_UWQ_MACTION_DEFS_TL
TABLE - IEU.IEU_UWQ_MEDIA_ACTIONS
TABLE - IEU.IEU_UWQ_MEDIA_TYPES_B
TABLE - IEU.IEU_UWQ_MEDIA_TYPES_TL
TABLE - IEU.IEU_UWQ_NODE_DS
TABLE - IEU.IEU_UWQ_NONMEDIA_ACTIONS
TABLE - IEU.IEU_UWQ_RES_CATS_B
TABLE - IEU.IEU_UWQ_RES_CATS_TL
TABLE - IEU.IEU_UWQ_RES_CAT_ENM_MAPS
TABLE - IEU.IEU_UWQ_RTNODE_BIND_VALS
TABLE - IEU.IEU_UWQ_SEL_ENUMERATORS
TABLE - IEU.IEU_UWQ_SEL_MRT_DATA
TABLE - IEU.IEU_UWQ_SEL_RT_NODES
TABLE - IEU.IEU_UWQ_SVR_MPS_MMAPS
TABLE - IEU.IEU_UWQ_SVR_MPS_PLUGINS
TABLE - IEU.IEU_WP_ACTION_MAPS
TABLE - IEU.IEU_WP_ACTION_PARAMS
TABLE - IEU.IEU_WP_ACT_PARAM_SETS_B
TABLE - IEU.IEU_WP_ACT_PARAM_SETS_TL
TABLE - IEU.IEU_WP_NODE_SECTION_MAPS
TABLE - IEU.IEU_WP_PARAM_DEFS_B
TABLE - IEU.IEU_WP_PARAM_DEFS_TL
TABLE - IEU.IEU_WP_PARAM_PROPS_B
TABLE - IEU.IEU_WP_PARAM_PROPS_TL
TABLE - IEU.IEU_WP_PROPERTIES_B
TABLE - IEU.IEU_WP_PROPERTIES_TL
TABLE - IEU.IEU_WP_SECTIONS_B
TABLE - IEU.IEU_WP_SECTIONS_TL
TABLE - IEU.IEU_WP_UI_COMPONENTS_B
TABLE - IEU.IEU_WP_UI_COMPONENTS_TL
TABLE - IEU.IEU_WP_UI_COMP_CATG_B
TABLE - IEU.IEU_WP_UI_COMP_CATG_TL
TABLE - IEU.IEU_WP_UI_COMP_DATATYPES
VIEW - APPS.IEU_LOOKUPS
VIEW - APPS.IEU_UWQ_BLENDED_V
VIEW - APPS.IEU_UWQ_DISP_ORDER_AVAIL_V
VIEW - APPS.IEU_UWQ_ESC_MYOWN_V
VIEW - APPS.IEU_UWQ_INBOUND_TEL_V
VIEW - APPS.IEU_UWQ_MACTION_DEFS_VL
VIEW - APPS.IEU_UWQ_MEDIA_ACTIONS_VL
VIEW - APPS.IEU_UWQ_MEDIA_V
VIEW - APPS.IEU_UWQ_TASKS_GA_V
VIEW - APPS.IEU_UWQ_TASKS_GO_V
VIEW - APPS.IEU_UWQ_TASKS_IA_V
VIEW - APPS.IEU_UWQ_TASKS_IO_V
VIEW - APPS.IEU_UWQ_TASKS_MYOWN_V
VIEW - APPS.IEU_UWQ_TASKS_NODE_V
VIEW - APPS.IEU_UWQ_TASKS_TA_V
VIEW - APPS.IEU_UWQ_TASKS_TO_V
VIEW - APPS.IEU_UWQ_TASKS_V
VIEW - APPS.IEU_UWQ_TASK_GA_REF_V
VIEW - APPS.IEU_UWQ_TASK_GO_REF_V
VIEW - APPS.IEU_UWQ_TASK_IA_REF_V
VIEW - APPS.IEU_UWQ_TASK_IO_REF_V
VIEW - APPS.IEU_UWQ_TASK_TA_REF_V
VIEW - APPS.IEU_UWQ_TASK_TO_REF_V
VIEW - APPS.IEU_UWQ_WEB_CALLBACK_V
VIEW - APPS.IEU_WP_ACTION_PARAMS_V
VIEW - APPS.IEU_WP_ACT_PARAM_SETS_VL
VIEW - APPS.IEU_WP_TASK_OWNR_LOV_V
VIEW - APPS.IEU_WP_UI_COMPONENTS_VL

Table: IEU_CLI_PROV_PLUGINS

Description: UWQ Client-Side Media Provider Plugins
Primary Key: IEU_CLI_PROV_PLUGINS_PK
  1. PLUGIN_ID
Primary Key: IEU_CLI_PROV_PLUGINS_U1
  1. PLUGIN_CLASS_NAME
Comments

UWQ Client-Side Media Provider Plugins

Columns
Name Datatype Length Mandatory Comments
PLUGIN_ID NUMBER (15) Y PK
PLUGIN_CLASS_NAME VARCHAR2 (1996) Y Fully qualified Java class name implementing the oracle.apps.ieu.client.provider.ClientProviderAgent
IS_ACTIVE_FLAG VARCHAR2 (1)
A value other than Y/y indicates that this plugin will not be loaded into the UWQ runtime
APPLICATION_ID NUMBER
Y Unique Application ID
OBJECT_VERSION_NUMBER NUMBER

Standard Column
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

[top of page]

IEU.IEU_CLI_PROV_PLUGINS does not reference any database object

IEU.IEU_CLI_PROV_PLUGINS is referenced by following:

APPS
SYNONYM - IEU_CLI_PROV_PLUGINS

[top of page]

Table: IEU_CLI_PROV_PLUGIN_MED_MAPS

Description: Maps the supported Media Types for UWQ Client Media Provider Plugins
Primary Key: IEU_CLI_PROV_PLUGIN_MED_MAP_PK
  1. PLUGIN_MED_MAP_ID
Primary Key: IEU_CLI_PROV_PLUGIN_MED_MAP_U1
  1. PLUGIN_ID
  2. MEDIA_TYPE_ID
Comments

Maps the supported Media Types for UWQ Client Media Provider Plugins

Columns
Name Datatype Length Mandatory Comments
PLUGIN_MED_MAP_ID NUMBER (15) Y PK
PLUGIN_ID NUMBER (15) Y FK to IEU_CLI_PROV_PLUGINS
MEDIA_TYPE_ID NUMBER (15) Y FK to IEU_UWQ_MEDIA_TYPES_B
CONDITIONAL_FUNC VARCHAR2 (255)
PL/SQL function name which can be dynamically called for deteriming whether the plugin/media type mapping conditions are met.
OBJECT_VERSION_NUMBER NUMBER

Standard column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

IEU.IEU_CLI_PROV_PLUGIN_MED_MAPS does not reference any database object

IEU.IEU_CLI_PROV_PLUGIN_MED_MAPS is referenced by following:

APPS
SYNONYM - IEU_CLI_PROV_PLUGIN_MED_MAPS

[top of page]

Table: IEU_CTL_PLUGINS_B

Description: UWQ Controller UI Plugins.
Primary Key: IEU_CTL_PLUGINS_B_PK
  1. PLUGIN_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_CTL_PLUGINS_TL.PLUGIN_ID IEU_CTL_PLUGINS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_CTL_PLUGINS_B_U1 UNIQUE APPS_TS_SEED PLUGIN_ID
Columns
Name Datatype Length Mandatory Comments
PLUGIN_ID NUMBER (15) Y PK for the table.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
CLASS_NAME VARCHAR2 (1990) Y Fully qualified class name of the plugin to load.
IMAGE_FILE_NAME VARCHAR2 (1990) Y Image file to display in the UI for this plugin.
AUDIO_FILE_NAME VARCHAR2 (1990)
Audio file to display in the UI for this plugin.
IS_REQUIRED_FLAG VARCHAR2 (1)
Indicates if loading this plugin is mandatory.
DO_LAUNCH_FUNC VARCHAR2 (255)
Specifies the function that will determine if the plugin should be launched.
INIT_ERROR_MSG_NAME VARCHAR2 (30)
FK to FND_NEW_MESSAGES. Optional error message passed to plugin when initialization fails.
APPLICATION_ID NUMBER
Y Application ID of plugin owner. Used to reference FND_NEW_MESSAGES as well.

[top of page]

IEU.IEU_CTL_PLUGINS_B does not reference any database object

IEU.IEU_CTL_PLUGINS_B is referenced by following:

APPS
SYNONYM - IEU_CTL_PLUGINS_B

[top of page]

Table: IEU_CTL_PLUGINS_TL

Description: UWQ Controller UI Plugins Translations.
Primary Key: IEU_CTL_PLUGINS_TL_PK
  1. PLUGIN_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_CTL_PLUGINS_TL.PLUGIN_ID IEU_CTL_PLUGINS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_CTL_PLUGINS_TL_U1 UNIQUE APPS_TS_SEED PLUGIN_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PLUGIN_ID NUMBER (15) Y PK for the table.
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SOURCE_LANG VARCHAR2 (240) Y Source language of the translation.
NAME VARCHAR2 (1990) Y Translated name of the priority.
DESCRIPTION VARCHAR2 (1990) Y Translated description of the priority.

[top of page]

IEU.IEU_CTL_PLUGINS_TL does not reference any database object

IEU.IEU_CTL_PLUGINS_TL is referenced by following:

APPS
SYNONYM - IEU_CTL_PLUGINS_TL

[top of page]

Table: IEU_MSG_MESSAGES

Description: Message table
Primary Key: IEU_MSG_MESSAGES_PK
  1. MESSAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_MSG_MESSAGES.APPLICATION_ID FND_APPLICATION
IEU_MSG_MESSAGES.RESOURCE_ID JTF_RS_RESOURCE_EXTNS
IEU_MSG_MESSAGES.WORKITEM_OBJ_CODE JTF_OBJECTS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_MSG_MESSAGES_U1 UNIQUE APPS_TS_TX_IDX MESSAGE_ID
IEU_MSG_MESSAGES_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_TYPE
RESOURCE_ID
STATUS_ID
LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER (15) Y PK for the table.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
APPLICATION_ID NUMBER (15) Y Application (product team) that sent the message.
RESOURCE_TYPE VARCHAR2 (30) Y Resource Type of the resource the message is for.
RESOURCE_ID NUMBER (15) Y Resource ID of the resource the message is for.
STATUS_ID NUMBER (3) Y Internal status ID code (i.e., delivered, read, deleted).
TITLE VARCHAR2 (240) Y Short title to display for the message.
BODY VARCHAR2 (1990) Y Body of the message.
WORKITEM_OBJ_CODE VARCHAR2 (30)
FK to JTF_OBJECTS_B. It represents source of work item.
WORKITEM_PK_ID NUMBER (15)
Uniquely identifies the work item, per Document, viz. SR, TASK etc.

[top of page]

IEU.IEU_MSG_MESSAGES does not reference any database object

IEU.IEU_MSG_MESSAGES is referenced by following:

APPS
SYNONYM - IEU_MSG_MESSAGES

[top of page]

Table: IEU_SH_ACTIVITIES

Description: Session History activities.
Primary Key: IEU_SH_ACTIVITIES_PK
  1. ACTIVITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_SH_ACTIVITIES.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_SH_ACTIVITIES.SESSION_ID IEU_SH_SESSIONS
IEU_SH_ACTIVITIES.ACTIVITY_TYPE_ID IEU_SH_ACT_TYPES_B
IEU_SH_ACTIVITIES.PARENT_CYCLE_ID IEU_SH_ACTIVITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_SH_ACTIVITIES.PARENT_CYCLE_ID IEU_SH_ACTIVITIES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_SH_ACTIVITIES_U1 UNIQUE APPS_TS_TX_IDX ACTIVITY_ID
IEU_SH_ACTIVITIES_N1 NONUNIQUE APPS_TS_TX_IDX SESSION_ID
ACTIVITY_TYPE_CODE
ACTIVE_FLAG
IEU_SH_ACTIVITIES_N2 NONUNIQUE APPS_TS_TX_IDX MEDIA_ID
ACTIVE_FLAG
IEU_SH_ACTIVITIES_N3 NONUNIQUE APPS_TS_TX_IDX BEGIN_DATE_TIME
DELIVER_DATE_TIME
IEU_SH_ACTIVITIES_N4 NONUNIQUE APPS_TS_TX_IDX END_DATE_TIME
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ID NUMBER (15) Y Uniquely identifies the row.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SESSION_ID NUMBER (15) Y Uniquely identifies the row.
ACTIVITY_TYPE_ID NUMBER (15) Y References activity type base table.
ACTIVITY_TYPE_CODE VARCHAR2 (32) Y Used programmatically to identify activity types.
BEGIN_DATE_TIME DATE
Y Time the session began.
END_DATE_TIME DATE

Time the session ended.
MEDIA_TYPE_ID NUMBER (15)
References media type involved in activity, if any.
MEDIA_ID NUMBER (15)
References JTF_IH media involved in activity, if any.
ACTIVE_FLAG VARCHAR2 (1)
Indicates if record is still active, or completed.
COMPLETION_CODE VARCHAR2 (30)
For activity types that can end for multiple reasons, indicates the type of completion. References the FND_LOOKUP_TYPE IEU_SH_COMPL_CODE.
DELIVER_DATE_TIME DATE

Time the item was delivered. Does not apply to all activity types.
REASON_CODE VARCHAR2 (30)
Contains the reason for the activity, if applicable. References the FND_LOOKUP_TYPE IEU_CTRL_BREAK_REASON.
REQUEST_METHOD VARCHAR2 (30)
For non-media activities, specifies the request type. References the FND_LOOKUP_TYPE IEU_SH_REQ_METHOD.
REQUESTED_MEDIA_TYPE_ID NUMBER (15)
References the media type requested as part of the activity, if any. Foreign key to IEU_UWQ_MEDIA_TYPES_B.
STATE_CODE VARCHAR2 (30)
Contains the current state of the activity. This is specific to each activity.
WORK_ITEM_TYPE_CODE VARCHAR2 (30)
Contains the object code of the non-media work item, if any. Foreign key to JTF_OBJECTS_B.
WORK_ITEM_PK_ID NUMBER

Contains the primary key of the non-media work item.
FORCE_CLOSED_BY_UWQ_FLAG VARCHAR2 (240)
Indicates if the record is force 'Closed' by UWQ, after being identified as 'Idle'. For e.g. a case where the Agent session got crashed.
CATEGORY_TYPE VARCHAR2 (30)
An activity-specific category type identifier.
CATEGORY_VALUE VARCHAR2 (128)
An activity-specific category identifier.
PARENT_CYCLE_ID NUMBER (15)
For media activities, contains the ID of the containing media cycle.

[top of page]

IEU.IEU_SH_ACTIVITIES does not reference any database object

IEU.IEU_SH_ACTIVITIES is referenced by following:

APPS
SYNONYM - IEU_SH_ACTIVITIES

[top of page]

Table: IEU_SH_ACT_TYPES_B

Description: Session activity types (base).
Primary Key: IEU_SH_ACT_TYPES_B_PK
  1. ACTIVITY_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_SH_ACTIVITIES.ACTIVITY_TYPE_ID IEU_SH_ACT_TYPES_B
IEU_SH_ACT_TYPES_TL.ACTIVITY_TYPE_ID IEU_SH_ACT_TYPES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_SH_ACT_TYPES_B_U1 UNIQUE APPS_TS_SEED ACTIVITY_TYPE_ID
IEU_SH_ACT_TYPES_B_U2 UNIQUE APPS_TS_SEED ACTIVITY_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_TYPE_ID NUMBER (15) Y Primary key for table.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
APPLICATION_ID NUMBER
Y Application id of the product owning the data.
ACTIVITY_TYPE_CODE VARCHAR2 (32) Y Used programmatically to identify activity types.

[top of page]

IEU.IEU_SH_ACT_TYPES_B does not reference any database object

IEU.IEU_SH_ACT_TYPES_B is referenced by following:

APPS
SYNONYM - IEU_SH_ACT_TYPES_B

[top of page]

Table: IEU_SH_ACT_TYPES_TL

Description: Session activity types( translated)
Primary Key: IEU_SH_ACT_TYPES_TL_PK
  1. ACTIVITY_TYPE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_SH_ACT_TYPES_TL.ACTIVITY_TYPE_ID IEU_SH_ACT_TYPES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_SH_ACT_TYPES_TL_U1 UNIQUE APPS_TS_SEED ACTIVITY_TYPE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_TYPE_ID NUMBER (15) Y Foreign key to base table.
LANGUAGE VARCHAR2 (4) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (4) Y Source language of the translation.
APPLICATION_ID NUMBER
Y Application id of the product owning the data.
NAME VARCHAR2 (1990) Y User displayable label for the column name.
DESCRIPTION VARCHAR2 (1990) Y User displayable description of what the column represents.

[top of page]

IEU.IEU_SH_ACT_TYPES_TL does not reference any database object

IEU.IEU_SH_ACT_TYPES_TL is referenced by following:

APPS
SYNONYM - IEU_SH_ACT_TYPES_TL

[top of page]

Table: IEU_SH_SESSIONS

Description: Session History main session.
Primary Key: IEU_SH_SESSIONS_PK
  1. SESSION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_SH_ACTIVITIES.SESSION_ID IEU_SH_SESSIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_SH_SESSIONS_U1 UNIQUE APPS_TS_TX_IDX SESSION_ID
IEU_SH_SESSIONS_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
ACTIVE_FLAG
IEU_SH_SESSIONS_N2 NONUNIQUE APPS_TS_TX_IDX BEGIN_DATE_TIME
IEU_SH_SESSIONS_N3 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
BEGIN_DATE_TIME
IEU_SH_SESSIONS_N4 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
IEU_SH_SESSIONS_N5 NONUNIQUE APPS_TS_TX_IDX END_DATE_TIME
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER (15) Y Uniquely identifies the row.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RESOURCE_ID NUMBER (15) Y Identifies JTF resource ID of the agent.
BEGIN_DATE_TIME DATE
Y Time the session began.
END_DATE_TIME DATE

Time the session ended.
ACTIVE_FLAG VARCHAR2 (1)
Indicates if record is still active, or completed.
APPLICATION_ID NUMBER
Y Identifies the application owning the data.
EXTENSION VARCHAR2 (32)
The telephone extension used by the agent for this session.
END_REASON_CODE VARCHAR2 (30)
The reason the session was ended. References the FND_LOOKUP_TYPE IEU_CTRL_BREAK_REASON.
FORCE_CLOSED_BY_UWQ_FLAG VARCHAR2 (1)
Indicates if the record is force 'Closed' by UWQ, after being identified as 'Idle'. For e.g. a case where the Agent session got crashed.

[top of page]

IEU.IEU_SH_SESSIONS does not reference any database object

IEU.IEU_SH_SESSIONS is referenced by following:

APPS
SYNONYM - IEU_SH_SESSIONS

[top of page]

Table: IEU_UWQM_AUDIT_LOG

Description: Work Distribution Audit Log
Comments

Audit Log is used to track all Activities on the UWQ Work Repository Item

Indexes
Index Type Tablespace Column
IEU_UWQM_AUDIT_LOG_U1 UNIQUE APPS_TS_TX_IDX AUDIT_LOG_ID
IEU_UWQM_AUDIT_LOG_N1 NONUNIQUE APPS_TS_TX_IDX WORKITEM_OBJ_CODE
WORKITEM_PK_ID
Columns
Name Datatype Length Mandatory Comments
AUDIT_LOG_ID NUMBER (15) Y Uniquely identifies the work item.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
ACTION_KEY VARCHAR2 (32)
Represents the Action on the Actual Work Item
EVENT_KEY VARCHAR2 (32)
Represents the Activity on the UWQ Work Item as a result of the Action
WORKITEM_PK_ID NUMBER (15)
ID to pass to Object when launching item.
WORKITEM_OBJ_CODE VARCHAR2 (30)
FK to JTF_OBJECTS_B. It represents source of work item.
WORK_ITEM_NUMBER VARCHAR2 (240)
Application-specific workitem identifier.
WS_CODE VARCHAR2 (240)
Work Source ID
APPLICATION_ID NUMBER

Application ID of the program which creates the workitem.
MODULE VARCHAR2 (240)
Name of the Module responsible for the activity like Distribution Function, User Hooks etc
PRIORITY_ID_CURR NUMBER (15)
FK to IEU_MWM_PRIORITIES_B. Reference to priority level, used for translation.
PRIORITY_ID_PREV NUMBER (15)
FK to IEU_MWM_PRIORITIES_B. Reference to priority level, used for translation.
OWNER_TYPE_CURR VARCHAR2 (25)
Contains the current resource type for the workitem owner.
OWNER_TYPE_PREV VARCHAR2 (25)
Contains the previous resource type for the workitem owner.
OWNER_ID_CURR NUMBER

Contains the current resource ID for the workitem owner.
OWNER_ID_PREV NUMBER

Contains the previous resource ID for the workitem owner.
ASSIGNEE_TYPE_CURR VARCHAR2 (25)
Contains the current resource type for the workitem assignee (if any).
ASSIGNEE_TYPE_PREV VARCHAR2 (25)
Contains the previous resource type for the workitem assignee (if any).
ASSIGNEE_ID_CURR NUMBER

Contains the current resource ID for the workitem assignee (if any).
ASSIGNEE_ID_PREV NUMBER

Contains the previous resource ID for the workitem assignee (if any).
SOURCE_OBJECT_ID_CURR NUMBER

Contains the current ID of the source document of the workitem.
SOURCE_OBJECT_ID_PREV NUMBER

Contains the previous ID of the source document of the workitem.
SOURCE_OBJECT_TYPE_CODE_CURR VARCHAR2 (30)
Contains the current object code for the source document of the workitem.
SOURCE_OBJECT_TYPE_CODE_PREV VARCHAR2 (30)
Contains the current object code for the source document of the workitem.
DUE_DATE_CURR DATE

Current Due date for the work item.
DUE_DATE_PREV DATE

Previous Due date for the work item.
WORKITEM_STATUS_ID_CURR NUMBER (15)
Current Work-Item Status indicator for the item. 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
WORKITEM_STATUS_ID_PREV NUMBER (15)
Previous Work-Item Status indicator for the item. 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
WORKITEM_DIST_STATUS_ID_CURR NUMBER (2)
Current Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
WORKITEM_DIST_STATUS_ID_PREV NUMBER (2)
Previous Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
RESCHEDULE_TIME_CURR DATE

Current Rescheule Time for the Work Item
RESCHEDULE_TIME_PREV DATE

Previous Rescheule Time for the Work Item
PARENT_WORKITEM_STATUS_ID_CURR NUMBER (2)
Current Parent Status ID 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
PARENT_WORKITEM_STATUS_ID_PREV NUMBER (2)
Previous Parent Status ID 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
PARENT_DIST_STATUS_ID_CURR NUMBER (2)
Current Parent Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
PARENT_DIST_STATUS_ID_PREV NUMBER (2)
Previous Parent Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
IEU_COMMENT_CODE1 VARCHAR2 (4000)
Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE2 VARCHAR2 (4000)
Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE3 VARCHAR2 (4000)
Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE4 VARCHAR2 (4000)
Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE5 VARCHAR2 (4000)
Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
WORKITEM_COMMENT_CODE1 VARCHAR2 (4000)
Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE2 VARCHAR2 (4000)
Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE3 VARCHAR2 (4000)
Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE4 VARCHAR2 (4000)
Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE5 VARCHAR2 (4000)
Specifies the Code for certain rules applied by the Application.
RETURN_STATUS VARCHAR2 (10)
Action/Event return status. The values are - SUCCESS, ERROR, UNEXPECTED
ERROR_CODE VARCHAR2 (4000)
Specifies the error code and the error message
LOGGING_LEVEL VARCHAR2 (100)
Audit Log logging levels

[top of page]

IEU.IEU_UWQM_AUDIT_LOG does not reference any database object

IEU.IEU_UWQM_AUDIT_LOG is referenced by following:

APPS
SYNONYM - IEU_UWQM_AUDIT_LOG

[top of page]

Table: IEU_UWQM_ITEMS

Description: UWQ Metaphor items table.
Primary Key: IEU_UWQM_ITEMS_PK
  1. WORK_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE JTF_OBJECTS_B
IEU_UWQM_ITEMS.ASSIGNEE_ID JTF_RS_RESOURCE_EXTNS
IEU_UWQM_ITEMS.OWNER_ID JTF_RS_RESOURCE_EXTNS
IEU_UWQM_ITEMS.PRIORITY_ID IEU_UWQM_PRIORITIES_B
IEU_UWQM_ITEMS.PARTY_ID HZ_PARTIES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQM_ITEMS_U1 UNIQUE APPS_TS_TX_IDX WORK_ITEM_ID
IEU_UWQM_ITEMS_U2 UNIQUE APPS_TS_TX_IDX WORKITEM_OBJ_CODE
WORKITEM_PK_ID
IEU_UWQM_ITEMS_N1 NONUNIQUE APPS_TS_TX_IDX OWNER_TYPE
OWNER_ID
WS_ID
DISTRIBUTION_STATUS_ID
STATUS_ID
PRIORITY_LEVEL
DUE_DATE
IEU_UWQM_ITEMS_N2 NONUNIQUE APPS_TS_TX_IDX ASSIGNEE_TYPE
ASSIGNEE_ID
WS_ID
DISTRIBUTION_STATUS_ID
STATUS_ID
PRIORITY_LEVEL
DUE_DATE
IEU_UWQM_ITEMS_N3 NONUNIQUE APPS_TS_TX_IDX SOURCE_OBJECT_ID
SOURCE_OBJECT_TYPE_CODE
DISTRIBUTION_STATUS_ID
IEU_UWQM_ITEMS_N4 NONUNIQUE APPS_TS_TX_IDX WS_ID
STATUS_ID
Columns
Name Datatype Length Mandatory Comments
WORK_ITEM_ID NUMBER (15) Y Uniquely identifies the work item.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
WORKITEM_OBJ_CODE VARCHAR2 (30) Y FK to JTF_OBJECTS_B. It represents source of work item.
WORKITEM_PK_ID NUMBER (15) Y ID to pass to Object when launching item.
STATUS_ID NUMBER (15)
Work-Item Status indicator for the item. 0 - Open 1 - Closed 2 - Deleted 3 - Sleep
PRIORITY_ID NUMBER (15) Y FK to IEU_MWM_PRIORITIES_B. Reference to priority level, used for translation.
PRIORITY_LEVEL NUMBER (3) Y Priority level, denormalized from IEU_MWM_PRIORITIES_B.
DUE_DATE DATE

Due date for the work item.
TITLE VARCHAR2 (1990) Y The title of the work item (i.e., Task title).
PARTY_ID NUMBER (15)
Customer the item is related to.
OWNER_TYPE VARCHAR2 (25)
Contains the effective resource type for the workitem owner.
OWNER_ID NUMBER

Contains the resource ID for the workitem owner.
ASSIGNEE_TYPE VARCHAR2 (25)
Contains the effective resource type for the workitem assignee (if any).
ASSIGNEE_ID NUMBER

Contains the resource ID for the workitem assignee (if any).
SOURCE_OBJECT_ID NUMBER

Contains the ID of the source document of the workitem.
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Contains the object code for the source document of the workitem.
OWNER_TYPE_ACTUAL VARCHAR2 (30)
Contains the actual resource type of the owner of this workitem.
ASSIGNEE_TYPE_ACTUAL VARCHAR2 (30)
Contains the actual resource type of the assignee for this workitem.
APPLICATION_ID NUMBER
Y Application ID of the program which creates the workitem.
IEU_ENUM_TYPE_UUID VARCHAR2 (38)
UUID for the enumerator associated with this workitem.
STATUS_UPDATE_USER_ID NUMBER

FND_USER ID of the last user to update the status of the workitem.
WORK_ITEM_NUMBER VARCHAR2 (64)
Application-specific workitem identifier.
RESCHEDULE_TIME DATE

Rescheule Time for the Work Item
WS_ID NUMBER (15)
Work Source ID
DISTRIBUTION_STATUS_ID NUMBER (2)
Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed

[top of page]

IEU.IEU_UWQM_ITEMS does not reference any database object

IEU.IEU_UWQM_ITEMS is referenced by following:

APPS
SYNONYM - IEU_UWQM_ITEMS

[top of page]

Table: IEU_UWQM_PRIORITIES_B

Description: UWQ Metaphor priorities.
Primary Key: IEU_UWQM_PRIORITIES_B_PK
  1. PRIORITY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_UWQM_ITEMS.PRIORITY_ID IEU_UWQM_PRIORITIES_B
IEU_UWQM_PRIORITIES_TL.PRIORITY_ID IEU_UWQM_PRIORITIES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQM_PRIORITIES_B_U1 UNIQUE APPS_TS_SEED PRIORITY_ID
IEU_UWQM_PRIORITIES_B_U2 UNIQUE APPS_TS_SEED PRIORITY_LEVEL
IEU_UWQM_PRIORITIES_B_U3 UNIQUE APPS_TS_SEED PRIORITY_CODE
Columns
Name Datatype Length Mandatory Comments
PRIORITY_ID NUMBER (15) Y PK for the table.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
PRIORITY_LEVEL NUMBER (3) Y Priority level used for sorting results.
PRIORITY_CODE VARCHAR2 (30) Y A readable code for the priority usable by applications.

[top of page]

IEU.IEU_UWQM_PRIORITIES_B does not reference any database object

IEU.IEU_UWQM_PRIORITIES_B is referenced by following:

APPS
SYNONYM - IEU_UWQM_PRIORITIES_B

[top of page]

Table: IEU_UWQM_PRIORITIES_TL

Description: UWQ Metaphor priorities translations.
Primary Key: IEU_UWQM_PRIORITIES_TL_PK
  1. PRIORITY_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQM_PRIORITIES_TL.PRIORITY_ID IEU_UWQM_PRIORITIES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQM_PRIORITIES_TL_U1 UNIQUE APPS_TS_SEED PRIORITY_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PRIORITY_ID NUMBER (15) Y PK for the table.
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SOURCE_LANG VARCHAR2 (240) Y Source language of the translation.
NAME VARCHAR2 (80) Y Translated name of the priority.
DESCRIPTION VARCHAR2 (1990) Y Translated description of the priority.

[top of page]

IEU.IEU_UWQM_PRIORITIES_TL does not reference any database object

IEU.IEU_UWQM_PRIORITIES_TL is referenced by following:

APPS
SYNONYM - IEU_UWQM_PRIORITIES_TL

[top of page]

Table: IEU_UWQM_WORK_SOURCES_B

Description: UWQ Work Source Definitions
Primary Key: IEU_UWQM_WORK_SOURCES_B_PK
  1. WS_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQM_WORK_SOURCES_B_U1 UNIQUE APPS_TS_SEED WS_ID
Columns
Name Datatype Length Mandatory Comments
WS_ID NUMBER (15) Y PK for the table.
APPLICATION_ID NUMBER (15)
Application Identifier
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
WS_TYPE VARCHAR2 (25) Y Universally unique identifier of the enumeration type.
WS_CODE VARCHAR2 (32) Y A unique identifier code for the Work Source definition.
OBJECT_CODE VARCHAR2 (32)
FK to JTF_OBJECTS_B. It represents source of work item.
WS_ENABLE_PROFILE_OPTION VARCHAR2 (80)
Identifies the profile option that determines if the work source is enabled for distribution.
DISTRIBUTE_FROM VARCHAR2 (100)
Indicates the type of Resource categorization from which the Distribution is done. Currently, the supported types are: 1. Group Owner 2. Group Assignee
DISTRIBUTE_TO VARCHAR2 (100)
Indicates the type of Resource categorization to which the Distribution is done. Currently, the supported types are: 1. Individual Assignee 2. Individual Owner
DISTRIBUTION_FUNCTION VARCHAR2 (256)
Fully qualified distribution function.
NOT_VALID_FLAG VARCHAR2 (1)
Indicates whether the row is valid or should be ignored.
ACTIVE_FLAG VARCHAR2 (1)
Indicates whether the Work Source has been activated or not.

[top of page]

IEU.IEU_UWQM_WORK_SOURCES_B does not reference any database object

IEU.IEU_UWQM_WORK_SOURCES_B is referenced by following:

APPS
SYNONYM - IEU_UWQM_WORK_SOURCES_B

[top of page]

Table: IEU_UWQM_WORK_SOURCES_TL

Description: UWQ Work Source Translations
Primary Key: IEU_UWQM_WORK_SOURCES_TL_PK
  1. WS_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQM_WORK_SOURCES_TL_U1 UNIQUE APPS_TS_SEED WS_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
WS_ID NUMBER (15) Y FK to Work Sources.
WS_NAME VARCHAR2 (1000) Y Work Source Name
WS_DESCRIPTION VARCHAR2 (1996)
Description of the Work Source.
LANGUAGE VARCHAR2 (4) Y Language of the translation.
SOURCE_LANG VARCHAR2 (4)
Source language of the translation.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQM_WORK_SOURCES_TL does not reference any database object

IEU.IEU_UWQM_WORK_SOURCES_TL is referenced by following:

APPS
SYNONYM - IEU_UWQM_WORK_SOURCES_TL

[top of page]

Table: IEU_UWQM_WS_ASSCT_PROPS

Description: UWQ Work Source Asoociation Properties
Primary Key: IEU_UWQM_WS_ASSCT_PROPS_PK
  1. WS_ASSOCIATION_PROP_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQM_WS_ASSCT_PROPS_U1 UNIQUE APPS_TS_SEED WS_ASSOCIATION_PROP_ID
Columns
Name Datatype Length Mandatory Comments
WS_ASSOCIATION_PROP_ID NUMBER (15) Y PK for the table.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
WS_ID NUMBER (15) Y Work Source Association ID
PARENT_WS_ID NUMBER (15)
Parent Work Source ID for this Work-Source Association
CHILD_WS_ID NUMBER (15)
Child Work Source ID for the Association
DIST_ST_BASED_ON_PARENT_FLAG VARCHAR2 (5)
Indicates whether the distribution of the dependent (child) work-item will be based on that of parent, viz. the child work-item will not be distributed until the parent work-item is distributed.
TASKS_RULES_FUNCTION VARCHAR2 (256)
Rules Function for Tasks with source doc like SR etc.

[top of page]

IEU.IEU_UWQM_WS_ASSCT_PROPS does not reference any database object

IEU.IEU_UWQM_WS_ASSCT_PROPS is referenced by following:

APPS
SYNONYM - IEU_UWQM_WS_ASSCT_PROPS

[top of page]

Table: IEU_UWQ_AGENT_BINDINGS

Description: Persists bindings of an agent to servers.
Primary Key: IEU_UWQ_AGENT_BINDINGS_PK
  1. SERVER_ID
  2. RESOURCE_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_AGENT_BINDINGS_U1 UNIQUE APPS_TS_TX_IDX SERVER_ID
RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15) Y Identifies JTF resource for the binding.
SERVER_ID NUMBER (15) Y Identifies the IEO_SVR_SERVER of the binding.
LAST_UPDATE_DATE DATE
Y Last time the binding was updated.
NOT_VALID VARCHAR2 (1)
Indicates if row is valid or not.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQ_AGENT_BINDINGS does not reference any database object

IEU.IEU_UWQ_AGENT_BINDINGS is referenced by following:

APPS
SYNONYM - IEU_UWQ_AGENT_BINDINGS

[top of page]

Table: IEU_UWQ_CLI_MED_PLUGINS

Description: UWQ Client (Media Type) Plugins
Primary Key: IEU_UWQ_CLI_PLUGINS_PK
  1. CLI_PLUGIN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_CLI_MED_PLUGINS.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_CLI_MED_PLUGINS.APPLICATION_ID FND_APPLICATION
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_CLI_MED_PLUGINS_U1 UNIQUE APPS_TS_SEED CLI_PLUGIN_ID
IEU_UWQ_CLI_MED_PLUGINS_N1 NONUNIQUE APPS_TS_SEED MEDIA_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
CLI_PLUGIN_ID NUMBER (15) Y UID of row.
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.
MEDIA_TYPE_ID NUMBER (15) Y FK to media type.
CLI_PLUGIN_CLASS VARCHAR2 (1996) Y Fully qualified Java class string.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
APPLICATION_ID NUMBER
Y Application Identifier

[top of page]

IEU.IEU_UWQ_CLI_MED_PLUGINS does not reference any database object

IEU.IEU_UWQ_CLI_MED_PLUGINS is referenced by following:

APPS
SYNONYM - IEU_UWQ_CLI_MED_PLUGINS

[top of page]

Table: IEU_UWQ_LOGIN_RULES_B

Description: Server Login Rules (Base)
Primary Key: IEU_UWQ_LOGIN_RULES_B_PK
  1. SVR_LOGIN_RULE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_UWQ_LOGIN_RULES_TL.SVR_LOGIN_RULE_ID IEU_UWQ_LOGIN_RULES_B
IEU_UWQ_MEDIA_TYPES_B.SVR_LOGIN_RULE_ID IEU_UWQ_LOGIN_RULES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_LOGIN_RULES_B_U1 NONUNIQUE APPS_TS_SEED SVR_LOGIN_RULE_ID
Columns
Name Datatype Length Mandatory Comments
SVR_LOGIN_RULE_ID NUMBER (15) Y PK of the Table
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
LOGIN_RULE_TYPE VARCHAR2 (30)
Login Rule Type (FUNC-Function based, MUUID - Media Type UUID)
LOGIN_RULE VARCHAR2 (255)
Login Rule (Function, Media Type UUID etc.)
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQ_LOGIN_RULES_B does not reference any database object

IEU.IEU_UWQ_LOGIN_RULES_B is referenced by following:

APPS
SYNONYM - IEU_UWQ_LOGIN_RULES_B

[top of page]

Table: IEU_UWQ_LOGIN_RULES_TL

Description: Server Login Rules (Translations)
Primary Key: IEU_UWQ_LOGIN_RULES_TL_PK
  1. SVR_LOGIN_RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_LOGIN_RULES_TL.SVR_LOGIN_RULE_ID IEU_UWQ_LOGIN_RULES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_LOGIN_RULES_TL_U1 NONUNIQUE APPS_TS_SEED SVR_LOGIN_RULE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SVR_LOGIN_RULE_ID NUMBER (15) Y PK of the Table
LANGUAGE VARCHAR2 (4) Y Language of the translation.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
LOGIN_RULE_NAME VARCHAR2 (255) Y Login Rule Short Name
LOGIN_RULE_DESC VARCHAR2 (1996)
Login Rule Description
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQ_LOGIN_RULES_TL does not reference any database object

IEU.IEU_UWQ_LOGIN_RULES_TL is referenced by following:

APPS
SYNONYM - IEU_UWQ_LOGIN_RULES_TL

[top of page]

Table: IEU_UWQ_MACTION_DEFS_B

Description: UWQ Action Definitions (base)
Primary Key: IEU_UWQ_MACTION_DEFS_B_PK
  1. MACTION_DEF_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_UWQ_MACTION_DEFS_TL.MACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
IEU_UWQ_MEDIA_ACTIONS.MACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
IEU_UWQ_NONMEDIA_ACTIONS.MACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
IEU_WP_ACTION_PARAMS.WP_ACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
IEU_WP_ACT_PARAM_SETS_B.WP_ACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_MACTION_DEFS_B_U1 UNIQUE APPS_TS_SEED MACTION_DEF_ID
IEU_UWQ_MACTION_DEFS_B_N1 NONUNIQUE APPS_TS_SEED ACTION_PROC
MACTION_DEF_ID
IEU_UWQ_MACTION_DEFS_B_N3 NONUNIQUE APPS_TS_SEED MACTION_DEF_KEY
Columns
Name Datatype Length Mandatory Comments
MACTION_DEF_ID NUMBER (15) Y UID of media action.
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.
ACTION_PROC VARCHAR2 (200)
Media action procedure name.
APPLICATION_ID NUMBER (15) Y App ID of the app that made the entry.
GLOBAL_FORM_PARAMS VARCHAR2 (500)
Column not used (not currently supported).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
ACTION_PROC_TYPE_CODE VARCHAR2 (1)
This is for different versions/types of Action(Foo) functions. The default is the one with the signature same as Media Action proc. 'E' - new signature for Non-Media Action functions.
MACTION_DEF_TYPE_FLAG VARCHAR2 (1)
Indicates the type of Action.Null/'M' -'Media Action (Default)'N' - 'Non-Media' Action'W' - 'Work' Action (For the Action Section of the UWQ Work Panel)'I' - 'Information' Action (For the Information Section of the UWQ Work Panel)'G' - 'Message' Action (For the Message Panel)
MACTION_DEF_KEY VARCHAR2 (32)
Unique Key for the Action.
MULTI_SELECT_FLAG VARCHAR2 (1)
The flag that indicates whether the Action is elligible in a Multi-Select mode.The valid values are: NULL/'N' - No (Default) 'Y' - Yes

[top of page]

IEU.IEU_UWQ_MACTION_DEFS_B does not reference any database object

IEU.IEU_UWQ_MACTION_DEFS_B is referenced by following:

APPS
SYNONYM - IEU_UWQ_MACTION_DEFS_B

[top of page]

Table: IEU_UWQ_MACTION_DEFS_TL

Description: Media Action Definitions (translations)
Primary Key: IEU_UWQ_MACTION_DEFS_TL_PK
  1. MACTION_DEF_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_MACTION_DEFS_TL.MACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_MACTION_DEFS_TL_U1 UNIQUE APPS_TS_SEED MACTION_DEF_ID
LANGUAGE
IEU_UWQ_MACTION_DEFS_TL_N1 NONUNIQUE APPS_TS_SEED ACTION_USER_LABEL
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
MACTION_DEF_ID NUMBER (15) Y Identifies the media action definition in the base table.
LANGUAGE VARCHAR2 (4) Y Language of the translation.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
ACTION_USER_LABEL VARCHAR2 (1996) Y Action label displayed to user.
SOURCE_LANG VARCHAR2 (4)
Source language of the translation.
ACTION_DESCRIPTION VARCHAR2 (1996)
Description of the action (displayed to user).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQ_MACTION_DEFS_TL does not reference any database object

IEU.IEU_UWQ_MACTION_DEFS_TL is referenced by following:

APPS
SYNONYM - IEU_UWQ_MACTION_DEFS_TL

[top of page]

Table: IEU_UWQ_MEDIA_ACTIONS

Description: UWQ Media Delivery Action Procedures.
Primary Key: IEU_UWQ_MEDIA_ACTIONS_PK
  1. MEDIA_ACTION_ID
Primary Key: IEU_UWQ_MEDIA_ACTIONS_UK1
  1. RESP_ID
  2. CLASSIFICATION
  3. MEDIA_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_MEDIA_ACTIONS.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_MEDIA_ACTIONS.MACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_MEDIA_ACTIONS_U1 UNIQUE APPS_TS_SEED RESP_ID
CLASSIFICATION
MEDIA_TYPE_ID
IEU_UWQ_MEDIA_ACTIONS_U2 UNIQUE APPS_TS_SEED MEDIA_ACTION_ID
IEU_UWQ_MEDIA_ACTIONS_N1 NONUNIQUE APPS_TS_SEED MEDIA_TYPE_ID
CLASSIFICATION
MACTION_DEF_ID
Columns
Name Datatype Length Mandatory Comments
MEDIA_ACTION_ID NUMBER (15) Y Identifies a media action specification.
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.
MEDIA_TYPE_ID NUMBER (15) Y Media type the action is for.
MACTION_DEF_ID NUMBER (15) Y FK to the media action definition.
APPLICATION_ID NUMBER (15) Y Application ID owning the entry.
CLASSIFICATION VARCHAR2 (500)
Classification for the action.
OTHER_PARAMS VARCHAR2 (500)
DO NOT USE (not currently supported).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
RESP_ID NUMBER (15)
FK to FND_RESPONSIBILITY

[top of page]

IEU.IEU_UWQ_MEDIA_ACTIONS does not reference any database object

IEU.IEU_UWQ_MEDIA_ACTIONS is referenced by following:

APPS
SYNONYM - IEU_UWQ_MEDIA_ACTIONS

[top of page]

Table: IEU_UWQ_MEDIA_TYPES_B

Description: UWQ Media Types (base)
Primary Key: IEU_UWQ_MEDIA_TYPES_B_PK
  1. MEDIA_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_MEDIA_TYPES_B.SVR_LOGIN_RULE_ID IEU_UWQ_LOGIN_RULES_B
IEU_UWQ_MEDIA_TYPES_B.APPLICATION_ID FND_APPLICATION
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_SH_ACTIVITIES.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_CLI_MED_PLUGINS.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_MEDIA_ACTIONS.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_SVR_MPS_MMAPS.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_MEDIA_TYPES_B_U1 UNIQUE APPS_TS_SEED MEDIA_TYPE_UUID
IEU_UWQ_MEDIA_TYPES_B_U2 UNIQUE APPS_TS_SEED MEDIA_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
MEDIA_TYPE_ID NUMBER (15) Y Uniquely identifies the media type.
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.
MEDIA_TYPE_UUID VARCHAR2 (38) Y Universally unique identifier of media type.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
SIMPLE_BLENDING_ORDER NUMBER (2)
Identifies the Prioritization order for Simple Blending offered by UWQ.
APPLICATION_ID NUMBER (15) Y Application Identifier
TEL_REQD_FLAG VARCHAR2 (1)
The flag indicates whether this Media Type requires Telephony Login along with appropriate parameters.
SVR_LOGIN_RULE_ID NUMBER (15)
Server Login Rule ID. FK to IEU_UWQ_LOGIN_RULES_B
SH_CATEGORY_TYPE VARCHAR2 (30)
Contains the type of categoy to be written to Session History for media cycles of this media type.
IMAGE_FILE_NAME VARCHAR2 (80)
Stores an image file to be associated with the media type.
CLASSIFICATION_QUERY_PROC VARCHAR2 (60)
Classification Query Procedure
BLENDED_FLAG VARCHAR2 (1)
Value of 'Y' indicates this type is supported by Blending.
BLENDED_DIR VARCHAR2 (1)
I - Indicates Inbound, O - Indicates Outbound

[top of page]

IEU.IEU_UWQ_MEDIA_TYPES_B does not reference any database object

IEU.IEU_UWQ_MEDIA_TYPES_B is referenced by following:

APPS
SYNONYM - IEU_UWQ_MEDIA_TYPES_B

[top of page]

Table: IEU_UWQ_MEDIA_TYPES_TL

Description: UWQ Media Types (translations)
Primary Key: IEU_UWQ_MEDIA_TYPES_TL_PK
  1. MEDIA_TYPE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_MEDIA_TYPES_TL.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_MEDIA_TYPES_TL_U1 UNIQUE APPS_TS_SEED MEDIA_TYPE_ID
LANGUAGE
IEU_UWQ_MEDIA_TYPES_TL_N1 NONUNIQUE APPS_TS_SEED MEDIA_TYPE_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
MEDIA_TYPE_ID NUMBER (15) Y FK to media type.
LANGUAGE VARCHAR2 (4) Y Language of the translation.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
MEDIA_TYPE_NAME VARCHAR2 (1996) Y Media type (string displayed to user).
SOURCE_LANG VARCHAR2 (4)
Source language of the translation.
MEDIA_TYPE_DESCRIPTION VARCHAR2 (1996)
Description of media type displayed to user.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQ_MEDIA_TYPES_TL does not reference any database object

IEU.IEU_UWQ_MEDIA_TYPES_TL is referenced by following:

APPS
SYNONYM - IEU_UWQ_MEDIA_TYPES_TL

[top of page]

Table: IEU_UWQ_NODE_DS

Description: UWQ Node-DataSource Mapping reference.
Primary Key: IEU_UWQ_NODE_DS_PK
  1. NODE_DS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_NODE_DS.DATASOURCE_NAME JTF_GRID_DATASOURCES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_NODE_DS_U1 UNIQUE APPS_TS_SEED NODE_DS_ID
IEU_UWQ_NODE_DS_U2 UNIQUE APPS_TS_SEED ENUM_TYPE_UUID
DATASOURCE_NAME
Columns
Name Datatype Length Mandatory Comments
NODE_DS_ID NUMBER (15) Y Identifies a UWQ Node-DS mapping.
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.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
ENUM_TYPE_UUID VARCHAR2 (38) Y Universally unique identifier of the enumeration type.
DATASOURCE_NAME VARCHAR2 (64) Y DataSource for SpreadTable.

[top of page]

IEU.IEU_UWQ_NODE_DS does not reference any database object

IEU.IEU_UWQ_NODE_DS is referenced by following:

APPS
SYNONYM - IEU_UWQ_NODE_DS

[top of page]

Table: IEU_UWQ_NONMEDIA_ACTIONS

Description: UWQ Non-Media Action Procedures.
Primary Key: IEU_UWQ_NONMEDIA_ACTIONS_PK
  1. NONMEDIA_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_NONMEDIA_ACTIONS.MACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_NONMEDIA_ACTIONS_U1 UNIQUE APPS_TS_SEED ACTION_OBJECT_CODE
MACTION_DEF_ID
RESPONSIBILITY_ID
SOURCE_FOR_TASK_FLAG
IEU_UWQ_NONMEDIA_ACTIONS_U2 UNIQUE APPS_TS_SEED NONMEDIA_ACTION_ID
IEU_UWQ_NONMEDIA_ACTIONS_N1 NONUNIQUE APPS_TS_SEED MACTION_DEF_ID
Columns
Name Datatype Length Mandatory Comments
NONMEDIA_ACTION_ID NUMBER (15) Y Identifies a media action specification.
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.
ACTION_OBJECT_CODE VARCHAR2 (100) Y This column represents the link to Source Document Object Code for Tasks. This means when if a Work-provider registers their Foo function with the same Object Code as the one they create Tasks with, and the view (Tasks/their own) contains the column IEU_OBJECT_CODE then the corresponding Action(Foo) function can be picked up.
MACTION_DEF_ID NUMBER (15) Y FK to the media action definition.
APPLICATION_ID NUMBER (15) Y Application ID owning the entry.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
RESPONSIBILITY_ID NUMBER

SOURCE_FOR_TASK_FLAG VARCHAR2 (5)

[top of page]

IEU.IEU_UWQ_NONMEDIA_ACTIONS does not reference any database object

IEU.IEU_UWQ_NONMEDIA_ACTIONS is referenced by following:

APPS
SYNONYM - IEU_UWQ_NONMEDIA_ACTIONS

[top of page]

Table: IEU_UWQ_RES_CATS_B

Description: Storage table for resource categorization clauses.
Primary Key: IEU_UWQ_RES_CATS_B_PK
  1. RES_CAT_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_RES_CATS_B_U1 UNIQUE APPS_TS_SEED RES_CAT_ID
Columns
Name Datatype Length Mandatory Comments
RES_CAT_ID NUMBER (15) Y The unique type code used in reference to the spec.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
APPLICATION_ID NUMBER
Y Application id of the product owning the data.
WHERE_CLAUSE VARCHAR2 (1990) Y Resource Categorization Where Clause.

[top of page]

IEU.IEU_UWQ_RES_CATS_B does not reference any database object

IEU.IEU_UWQ_RES_CATS_B is referenced by following:

APPS
SYNONYM - IEU_UWQ_RES_CATS_B

[top of page]

Table: IEU_UWQ_RES_CATS_TL

Description: Storage table for resource categorization translations.
Primary Key: IEU_UWQ_RES_CATS_TL_PK
  1. RES_CAT_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_RES_CATS_TL_U1 UNIQUE APPS_TS_SEED RES_CAT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
RES_CAT_ID NUMBER (15) Y Foreign key to base table.
LANGUAGE VARCHAR2 (4) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (4)
Source language of the translation.
NAME VARCHAR2 (1990) Y User displayable label for the resource categorization name.
DESCRIPTION VARCHAR2 (1990) Y User displayable description of what the resource categorization represents.

[top of page]

IEU.IEU_UWQ_RES_CATS_TL does not reference any database object

IEU.IEU_UWQ_RES_CATS_TL is referenced by following:

APPS
SYNONYM - IEU_UWQ_RES_CATS_TL

[top of page]

Table: IEU_UWQ_RES_CAT_ENM_MAPS

Description: Storage table for resource categorization clauses.
Primary Key: IEU_UWQ_RES_CAT_ENM_MAPS_PK
  1. ENUM_TYPE_UUID
  2. RES_CAT_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_RES_CAT_ENM_MAPS_U1 UNIQUE APPS_TS_SEED ENUM_TYPE_UUID
RES_CAT_ID
Columns
Name Datatype Length Mandatory Comments
ENUM_TYPE_UUID VARCHAR2 (38) Y Universally unique identifier of the enumeration type.
RES_CAT_ID NUMBER (15) Y The unique type code used in reference to the spec.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.

[top of page]

IEU.IEU_UWQ_RES_CAT_ENM_MAPS does not reference any database object

IEU.IEU_UWQ_RES_CAT_ENM_MAPS is referenced by following:

APPS
SYNONYM - IEU_UWQ_RES_CAT_ENM_MAPS

[top of page]

Table: IEU_UWQ_RTNODE_BIND_VALS

Description: UWQ Selector Run-Time Nodes Bind variable information.
Primary Key: IEU_UWQ_RTNODE_BIND_VALS_PK
  1. RTNODE_BIND_VAR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_RTNODE_BIND_VALS.SEL_RT_NODE_ID IEU_UWQ_SEL_RT_NODES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_RTNODE_BIND_VALS_U1 UNIQUE APPS_TS_TX_IDX RESOURCE_ID
NODE_ID
BIND_VAR_NAME
IEU_UWQ_RTNODE_BIND_VALS_U2 UNIQUE APPS_TS_TX_IDX RTNODE_BIND_VAR_ID
IEU_UWQ_RTNODE_BIND_VALS_N1 NONUNIQUE APPS_TS_TX_IDX SEL_RT_NODE_ID
IEU_UWQ_RTNODE_BIND_VALS_N2 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
NODE_ID
NOT_VALID_FLAG
Columns
Name Datatype Length Mandatory Comments
RTNODE_BIND_VAR_ID NUMBER (15) Y Uniquely identifies the Bind variable in the selector node row.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SEL_RT_NODE_ID NUMBER (15) Y Uniquely identifies selector node row.
RESOURCE_ID NUMBER (15) Y Identifies JTF resource ID of the agent.
NODE_ID NUMBER (10) Y Node ID.
BIND_VAR_NAME VARCHAR2 (32) Y Name of the Bind Variable for the node
BIND_VAR_VALUE VARCHAR2 (1990)
Name of the Bind Variable for the node
BIND_VAR_DATATYPE VARCHAR2 (240)
Datatype of the Bind Variable for the node
NOT_VALID_FLAG VARCHAR2 (1)
Indicates if row is valid (or not).

[top of page]

IEU.IEU_UWQ_RTNODE_BIND_VALS does not reference any database object

IEU.IEU_UWQ_RTNODE_BIND_VALS is referenced by following:

APPS
SYNONYM - IEU_UWQ_RTNODE_BIND_VALS

[top of page]

Table: IEU_UWQ_SEL_ENUMERATORS

Description: UWQ Selector Enumerator Functions.
Primary Key: IEU_UWQ_SEL_ENUMERATORS_PK
  1. SEL_ENUM_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID IEU_UWQ_SEL_ENUMERATORS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_SEL_ENUMERATORS_U1 UNIQUE APPS_TS_SEED ENUM_TYPE_UUID
IEU_UWQ_SEL_ENUMERATORS_U2 UNIQUE APPS_TS_SEED SEL_ENUM_ID
IEU_UWQ_SEL_ENUMERATORS_N1 NONUNIQUE APPS_TS_SEED MEDIA_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
SEL_ENUM_ID NUMBER (15) Y Uniquely identifies a node enumerator.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
ENUM_PROC VARCHAR2 (256)
Fully qualified enumeration function.
ENUM_TYPE_UUID VARCHAR2 (38) Y Universally unique identifier of the enumeration type.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
APPLICATION_ID NUMBER
Y Identifies the application owning the data.
WORK_Q_LABEL_LU_TYPE VARCHAR2 (30) Y Lookup Type for a Label that can be displayed on UIs to identify the work type.
WORK_Q_LABEL_LU_CODE VARCHAR2 (30) Y Lookup Code for a Label that can be displayed on UIs to identify the work type.
WORK_Q_ENABLE_PROFILE_OPTION VARCHAR2 (80)
Identifies the profile option that determines if work type is enabled.
WORK_Q_ORDER_PROFILE_OPTION VARCHAR2 (80)
Identifies the profile option used to specify display order.
WORK_Q_ORDER_SYSTEM_DEFAULT NUMBER (15)
Specifies the default to use if profile not set.
WORK_Q_VIEW_FOR_PRIMARY_NODE VARCHAR2 (30)
Identifies the provider view used to build the MyWork view.
REFRESH_PROC VARCHAR2 (255)
Fully qualified refresh function.
WORK_Q_VIEW_EXTRA_WHERE VARCHAR2 (1990)
Specifies an optional extra where clause when using the specified view.
MEDIA_TYPE_ID NUMBER (15)
Uniquely identifies the media type.
DEFAULT_RES_CAT_ID NUMBER (15)
FK to the default resource categorization.
RES_CAT_PROFILE_OPT VARCHAR2 (80)
Identifies the profile option that determines the resource categorization.
NOT_FOR_MYWORK_FLAG VARCHAR2 (1)
Indicates if the enumerator should be merged into MyWork view.
NOT_VALID_FLAG VARCHAR2 (1)
Indicates whether the row is valid or should be ignored.
WORK_Q_REGISTER_TYPE VARCHAR2 (1)
Indicates whether the work type registered is'M' - Media'N' - NonMedia'W' - 'WorkList only'
ACTION_PROC VARCHAR2 (255)
Fully qualified Non-Media Action procedure name, as Package.Procedure . This is to register what was so called Foo-function that returns the actual function to be launched, type and parameters.
ACTION_PROC_TYPE_CODE VARCHAR2 (1)
This is for different versions/types of Action(Foo) functions. The default is the one with the signature same as Media Action proc. 'E' - new signature for Non-Media Action functions.
ACTION_OBJECT_CODE VARCHAR2 (100)
This column represents the link to Source Document Object Code for Tasks. This means when if a Work-provider registers their Foo function with the same Object Code as the one they create Tasks with, and the view (Tasks/their own) contains the column IEU_OBJECT_CODE then the corresponding Action(Foo) function can be picked up.
WORK_PANEL_REGISTERED_FLAG VARCHAR2 (1)
Indicates whether the UWQ Work-Panel data has been registered for the Node and that there is atleast 1 or more Active/Valid Sections to be displayed for the Work-Node.

[top of page]

IEU.IEU_UWQ_SEL_ENUMERATORS does not reference any database object

IEU.IEU_UWQ_SEL_ENUMERATORS is referenced by following:

APPS
SYNONYM - IEU_UWQ_SEL_ENUMERATORS

[top of page]

Table: IEU_UWQ_SEL_MRT_DATA

Description: Data used for selector view.
Primary Key: IEU_UWQ_SEL_MRT_DATA_PK
  1. SEL_MRT_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_SEL_MRT_DATA_U1 UNIQUE APPS_TS_TX_IDX SEL_MRT_ID
IEU_UWQ_SEL_MRT_DATA_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
SVR_TYPE_ID
MEDIA_TYPE_ID
QUEUE_NAME
QUEUE_COUNT
Columns
Name Datatype Length Mandatory Comments
SEL_MRT_ID NUMBER (15) Y Uniquely identifies media run-time data row.
RESOURCE_ID NUMBER (15) Y JTF Resource ID that queue represent.
SVR_TYPE_ID NUMBER (15) Y Server that queue belongs to.
MEDIA_TYPE_ID NUMBER (15) Y Media type that queue represents.
QUEUE_NAME VARCHAR2 (500)
Queue name.
QUEUE_COUNT NUMBER (10) Y Queue count.
LAST_UPDATE_DATE DATE
Y Timestamp of last update.
PROVIDER_REF VARCHAR2 (32)
Provider specific reference.
NOT_VALID VARCHAR2 (1)
Indicates if row is valid or not.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQ_SEL_MRT_DATA does not reference any database object

IEU.IEU_UWQ_SEL_MRT_DATA is referenced by following:

APPS
PACKAGE - IEU_PVT
PACKAGE BODY - IEU_PVT
SYNONYM - IEU_UWQ_SEL_MRT_DATA

[top of page]

Table: IEU_UWQ_SEL_RT_NODES

Description: UWQ Selector Run-Time Nodes.
Primary Key: IEU_UWQ_SEL_RT_NODES_PK
  1. SEL_RT_NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID IEU_UWQ_SEL_ENUMERATORS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_UWQ_RTNODE_BIND_VALS.SEL_RT_NODE_ID IEU_UWQ_SEL_RT_NODES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_SEL_RT_NODES_U1 UNIQUE APPS_TS_TX_IDX RESOURCE_ID
SEL_ENUM_ID
NODE_ID
NODE_TYPE
IEU_UWQ_SEL_RT_NODES_U2 UNIQUE APPS_TS_TX_IDX RESOURCE_ID
NODE_ID
NOT_VALID
IEU_UWQ_SEL_RT_NODES_U3 UNIQUE APPS_TS_TX_IDX SEL_RT_NODE_ID
Columns
Name Datatype Length Mandatory Comments
SEL_RT_NODE_ID NUMBER (15) Y Uniquely identifies selector node row.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
RESOURCE_ID NUMBER (15) Y Identifies JTF resource ID of the agent.
SEL_ENUM_ID NUMBER (15) Y FK to enumerator.
NODE_ID NUMBER (10) Y Node ID.
NODE_TYPE NUMBER (10) Y Type of node.
NODE_LABEL VARCHAR2 (1996) Y Display label of the node.
COUNT NUMBER (10)
Elements contained in node (displayed).
DATA_SOURCE VARCHAR2 (64) Y DataSource for SpreadTable.
VIEW_NAME VARCHAR2 (64) Y View that DataSource is based upon.
MEDIA_TYPE_ID NUMBER (15)
FK to media type.
SEL_ENUM_PID NUMBER (15)
Parent's enumerator ID.
NODE_PID NUMBER (10)
Node's Parent.
NODE_WEIGHT NUMBER (10)
Weight for display order.
WHERE_CLAUSE VARCHAR2 (1996)
Where clause that qualifies agents view.
HIDE_IF_EMPTY VARCHAR2 (1)
Indicates to hide if count is zero (or not).
NOT_VALID VARCHAR2 (1)
Indicates if row is valid (or not).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
REFRESH_VIEW_NAME VARCHAR2 (64)
View that is used for Refreshing the Counts.
RES_CAT_ENUM_FLAG VARCHAR2 (1)
Indicates if the Resource Categorization is obtained from Enumerator seed.
REFRESH_VIEW_SUM_COL VARCHAR2 (30)
If specified, tells UWQ which column to use to SUM counts.
NODE_DEPTH NUMBER (10)
Node Depth in the Tree

[top of page]

IEU.IEU_UWQ_SEL_RT_NODES does not reference any database object

IEU.IEU_UWQ_SEL_RT_NODES is referenced by following:

APPS
SYNONYM - IEU_UWQ_SEL_RT_NODES

[top of page]

Table: IEU_UWQ_SVR_MPS_MMAPS

Description: UWQ Server (Media Provider) Media Maps
Primary Key: IEU_UWQ_SVR_MPS_MMAPS_PK
  1. SVR_MPS_MMAP_ID
Primary Key: IEU_UWQ_SVR_MPS_MMAPS_UK1
  1. MEDIA_TYPE_ID
  2. SVR_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_SVR_MPS_MMAPS.MEDIA_TYPE_ID IEU_UWQ_MEDIA_TYPES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_SVR_MPS_MMAPS_U1 UNIQUE APPS_TS_SEED MEDIA_TYPE_ID
SVR_TYPE_ID
IEU_UWQ_SVR_MPS_MMAPS_U2 UNIQUE APPS_TS_SEED SVR_MPS_MMAP_ID
Columns
Name Datatype Length Mandatory Comments
SVR_MPS_MMAP_ID NUMBER (15) Y Uniquely identifies media map row.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
MEDIA_TYPE_ID NUMBER (15) Y Media type ID.
SVR_TYPE_ID NUMBER (15) Y Server type ID.
MEDIA_TYPE_MAP NUMBER (10)
Server's representation of media type.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.

[top of page]

IEU.IEU_UWQ_SVR_MPS_MMAPS does not reference any database object

IEU.IEU_UWQ_SVR_MPS_MMAPS is referenced by following:

APPS
SYNONYM - IEU_UWQ_SVR_MPS_MMAPS

[top of page]

Table: IEU_UWQ_SVR_MPS_PLUGINS

Description: UWQ Server (Media Provider) Plugins
Primary Key: IEU_UWQ_SVR_MPS_PLUGINS_PK
  1. SVR_MPS_PLUGIN_ID
Primary Key: IEU_UWQ_SVR_MPS_PLUGINS_UK
  1. SVR_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_UWQ_SVR_MPS_PLUGINS.APPLICATION_ID FND_APPLICATION
IEU_UWQ_SVR_MPS_PLUGINS.SVR_TYPE_ID IEO_SVR_TYPES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_UWQ_SVR_MPS_PLUGINS_U1 UNIQUE APPS_TS_SEED SVR_MPS_PLUGIN_ID
IEU_UWQ_SVR_MPS_PLUGINS_U2 UNIQUE APPS_TS_SEED SVR_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
SVR_MPS_PLUGIN_ID NUMBER (15) Y UID of row.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SVR_TYPE_ID NUMBER (15) Y Server type ID.
SVR_PLUGIN_CLASS VARCHAR2 (1996) Y Fully qualified server plugin class (Java).
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
APPLICATION_ID NUMBER
Y Application Identifier

[top of page]

IEU.IEU_UWQ_SVR_MPS_PLUGINS does not reference any database object

IEU.IEU_UWQ_SVR_MPS_PLUGINS is referenced by following:

APPS
SYNONYM - IEU_UWQ_SVR_MPS_PLUGINS

[top of page]

Table: IEU_WP_ACTION_MAPS

Description: UWQ Action-Maps.
Primary Key: IEU_WP_ACTION_MAPS_PK
  1. WP_ACTION_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_ACTION_MAPS.ACTION_PARAM_SET_ID %
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_ACTION_MAPS_U1 UNIQUE APPS_TS_SEED WP_ACTION_MAP_ID
IEU_WP_ACTION_MAPS_N1 NONUNIQUE APPS_TS_SEED ACTION_MAP_CODE
ACTION_MAP_TYPE_CODE
RESPONSIBILITY_ID
NOT_VALID_FLAG
IEU_WP_ACTION_MAPS_N2 NONUNIQUE APPS_TS_SEED ACTION_PARAM_SET_ID
Columns
Name Datatype Length Mandatory Comments
WP_ACTION_MAP_ID NUMBER (15) Y Primary Key - Uniquely identifies the Action-Mapping
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
APPLICATION_ID NUMBER
Y Identifies the application owning the data.
RESPONSIBILITY_ID NUMBER

Identifies the responsibility for which the mapping is valid. When Null, acts like a default mapping for the combination.
ACTION_PARAM_SET_ID NUMBER (15) Y Action-Parameter Set ID to be mapped to the Work-Node or others based on the Map type code.
ACTION_MAP_TYPE_CODE VARCHAR2 (32)
Indicates the Action-Map Type code, of one or more of the following: 'NODE' - Node based Action-mapping (Actions mapped and populated on Work-node click.) 'UWQ' - Actions always mapped and populated while loggin in the UWQ session.
ACTION_MAP_CODE VARCHAR2 (64)
Indicates the Action-Map code. It's value depends upon the Action-Map type code. For Action-map type code of 'NODE', it is Enum Type UUID (unique for the node.)
ACTION_MAP_SEQUENCE NUMBER (5)
Action mapping sequence for the display.
PANEL_SEC_CAT_CODE VARCHAR2 (32)
Indicates the Panel or Section Category code, for which you may want to map the Actions. This will mainly currently be used by Information Categories like Notes and the Message Categories like 'Work-Item' related etc.
NOT_VALID_FLAG VARCHAR2 (5)
Indicates whether the row is valid or should be ignored.
DEV_DATA_FLAG VARCHAR2 (1)
This column's value differentiates developer defined data from site-leve defined data.

[top of page]

IEU.IEU_WP_ACTION_MAPS does not reference any database object

IEU.IEU_WP_ACTION_MAPS is referenced by following:

APPS
SYNONYM - IEU_WP_ACTION_MAPS

[top of page]

Table: IEU_WP_ACTION_PARAMS

Description: UWQ Action-Parameter Details.
Primary Key: IEU_WP_ACTION_PARAMS_PK
  1. ACTION_PARAM_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_ACTION_PARAMS.WP_ACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
IEU_WP_ACTION_PARAMS.PARAM_ID IEU_WP_PARAM_DEFS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_ACTION_PARAMS_U1 UNIQUE APPS_TS_SEED ACTION_PARAM_MAP_ID
IEU_WP_ACTION_PARAMS_U2 UNIQUE APPS_TS_SEED WP_ACTION_DEF_ID
PARAM_ID
IEU_WP_ACTION_PARAMS_N1 NONUNIQUE APPS_TS_SEED PARAM_ID
Columns
Name Datatype Length Mandatory Comments
ACTION_PARAM_MAP_ID NUMBER (15) Y Primary Key - Uniquely identifies the Action-Param mapping.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
WP_ACTION_DEF_ID NUMBER (15) Y Action ID to be mapped to parameters.
PARAM_ID NUMBER (15) Y Parameter ID to be mapped to the Actions.
NOT_VALID_FLAG VARCHAR2 (5)
Indicates whether the row is valid or should be ignored.

[top of page]

IEU.IEU_WP_ACTION_PARAMS does not reference any database object

IEU.IEU_WP_ACTION_PARAMS is referenced by following:

APPS
SYNONYM - IEU_WP_ACTION_PARAMS

[top of page]

Table: IEU_WP_ACT_PARAM_SETS_B

Description: UWQ Action-Param Sets - B
Primary Key: IEU_WP_ACT_PARAM_SETS_B_PK
  1. ACTION_PARAM_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_ACT_PARAM_SETS_B.WP_ACTION_DEF_ID IEU_UWQ_MACTION_DEFS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_WP_PARAM_PROPS_B.ACTION_PARAM_SET_ID IEU_WP_ACT_PARAM_SETS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_ACT_PARAM_SETS_B_U1 UNIQUE APPS_TS_SEED ACTION_PARAM_SET_ID
IEU_WP_ACT_PARAM_SETS_B_N1 NONUNIQUE APPS_TS_SEED WP_ACTION_DEF_ID
Columns
Name Datatype Length Mandatory Comments
ACTION_PARAM_SET_ID NUMBER (15) Y Primary Key - Uniquely identifies the Action-Parameter Set.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
WP_ACTION_DEF_ID NUMBER (15) Y Action ID to be mapped to parameters.

[top of page]

IEU.IEU_WP_ACT_PARAM_SETS_B does not reference any database object

IEU.IEU_WP_ACT_PARAM_SETS_B is referenced by following:

APPS
SYNONYM - IEU_WP_ACT_PARAM_SETS_B

[top of page]

Table: IEU_WP_ACT_PARAM_SETS_TL

Description: UWQ Action-Param Sets - TL
Primary Key: IEU_WP_ACT_PARAM_SETS_TL_PK
  1. ACTION_PARAM_SET_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_ACT_PARAM_SETS_TL.ACTION_PARAM_SET_ID %
Comments

The table stores the Action-Param set label. It will need to be unique within a specific Language.

Indexes
Index Type Tablespace Column
IEU_WP_ACT_PARAM_SETS_TL_U1 UNIQUE APPS_TS_SEED ACTION_PARAM_SET_ID
LANGUAGE
IEU_WP_ACT_PARAM_SETS_TL_N1 NONUNIQUE APPS_TS_SEED ACTION_PARAM_SET_LABEL
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ACTION_PARAM_SET_ID NUMBER (15) Y Action-Parameter Set ID
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
ACTION_PARAM_SET_LABEL VARCHAR2 (128) Y Action-Param Set Label. This will be displayed in the Actions Drop-down on UWQ UI Action Section.
ACTION_PARAM_SET_DESC VARCHAR2 (500)
Action-Param Set Description.

[top of page]

IEU.IEU_WP_ACT_PARAM_SETS_TL does not reference any database object

IEU.IEU_WP_ACT_PARAM_SETS_TL is referenced by following:

APPS
SYNONYM - IEU_WP_ACT_PARAM_SETS_TL

[top of page]

Table: IEU_WP_NODE_SECTION_MAPS

Description: Node - Section Maps.
Primary Key: IEU_WP_NODE_SECTION_MAPS_PK
  1. WP_NODE_SECTION_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_NODE_SECTION_MAPS.SECTION_ID %
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_NODE_SECTION_MAPS_U1 UNIQUE APPS_TS_SEED WP_NODE_SECTION_MAP_ID
Columns
Name Datatype Length Mandatory Comments
WP_NODE_SECTION_MAP_ID NUMBER (15) Y Primary Key - Uniquely identifies the Action-Mapping
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
APPLICATION_ID NUMBER

Identifies the application owning the data.
RESPONSIBILITY_ID NUMBER

Identifies the responsibility for which the mapping is valid. When Null, acts like a default mapping for the combination.
ENUM_TYPE_UUID VARCHAR2 (32) Y Indicates the Action-Map Type code, of one or more of the following: 'NODE' - Node based Action-mapping (Actions mapped and populated on Work-node click.) 'UWQ' - Actions always mapped and populated while loggin in the UWQ session.
SECTION_ID NUMBER (15) Y Section ID to be mapped to the Work-Node
SECTION_MAP_SEQUENCE NUMBER (5)
Section mapping sequence for the display.
NOT_VALID_FLAG VARCHAR2 (5)
Indicates whether the row is valid or should be ignored.

[top of page]

IEU.IEU_WP_NODE_SECTION_MAPS does not reference any database object

IEU.IEU_WP_NODE_SECTION_MAPS is referenced by following:

APPS
SYNONYM - IEU_WP_NODE_SECTION_MAPS

[top of page]

Table: IEU_WP_PARAM_DEFS_B

Description: UWQ Action-Parameter Details-B
Primary Key: IEU_WP_PARAM_DEFS_B_PK
  1. PARAM_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_WP_ACTION_PARAMS.PARAM_ID IEU_WP_PARAM_DEFS_B
IEU_WP_PARAM_DEFS_TL.PARAM_ID IEU_WP_PARAM_DEFS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_PARAM_DEFS_B_U1 UNIQUE APPS_TS_SEED PARAM_ID
Columns
Name Datatype Length Mandatory Comments
PARAM_ID NUMBER (15) Y Primary Key - Uniquely identifies a Parameter.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
APPLICATION_ID NUMBER

Application id of the product owning the data.
PARAM_NAME VARCHAR2 (128) Y Action-Parameter name. This can be the actual paramtere name as being used in the PL/SQL procedure that handles the Action. This is passed along with it's value when the Action is called.
DATA_TYPE VARCHAR2 (64)
Indicates Data Type for the Action Parameter. Valid values are the FND Lookup codes for theFND Lookup Type as 'DATA_TYPES'.

[top of page]

IEU.IEU_WP_PARAM_DEFS_B does not reference any database object

IEU.IEU_WP_PARAM_DEFS_B is referenced by following:

APPS
SYNONYM - IEU_WP_PARAM_DEFS_B

[top of page]

Table: IEU_WP_PARAM_DEFS_TL

Description: UWQ Action-Parameter Details-TL
Primary Key: IEU_WP_PARAM_DEFS_TL_PK
  1. PARAM_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_PARAM_DEFS_TL.PARAM_ID IEU_WP_PARAM_DEFS_B
Comments

The table stores the Labels and Description for the UWQ Action-Parameters.

Indexes
Index Type Tablespace Column
IEU_WP_PARAM_DEFS_TL_U1 UNIQUE APPS_TS_SEED PARAM_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAM_ID NUMBER (15) Y Primary Key - Uniquely identifies a Parameter.
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
PARAM_USER_LABEL VARCHAR2 (32) Y Action-ParameterLabel. This can also be displayed as Prompt if the Parameter is displayed on the UI.
PARAM_DESCRIPTION VARCHAR2 (500)
Action-Parameter Description. This can also be displayed as Tooltip/Hint if the Parameter is displayed on the UI.

[top of page]

IEU.IEU_WP_PARAM_DEFS_TL does not reference any database object

IEU.IEU_WP_PARAM_DEFS_TL is referenced by following:

APPS
SYNONYM - IEU_WP_PARAM_DEFS_TL

[top of page]

Table: IEU_WP_PARAM_PROPS_B

Description: Parameter-Property Details-B
Primary Key: IEU_WP_PARAM_PROPS_B_PK
  1. PARAM_PROPERTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_PARAM_PROPS_B.ACTION_PARAM_SET_ID IEU_WP_ACT_PARAM_SETS_B
IEU_WP_PARAM_PROPS_B.PROPERTY_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_WP_PARAM_PROPS_TL.PARAM_PROPERTY_ID IEU_WP_PARAM_PROPS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_PARAM_PROPS_B_U1 UNIQUE APPS_TS_SEED PARAM_PROPERTY_ID
IEU_WP_PARAM_PROPS_B_U2 UNIQUE APPS_TS_SEED ACTION_PARAM_SET_ID
PARAM_ID
PROPERTY_ID
IEU_WP_PARAM_PROPS_B_N1 NONUNIQUE APPS_TS_SEED ACTION_PARAM_SET_ID
IEU_WP_PARAM_PROPS_B_N2 NONUNIQUE APPS_TS_SEED PARAM_ID
Columns
Name Datatype Length Mandatory Comments
PARAM_PROPERTY_ID NUMBER (15) Y Primary Key - Uniquely identifies a Param Property.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
ACTION_PARAM_SET_ID NUMBER (15)
Action-Parameter Set ID. Null value means it's the default Action-Param Property for the Action-Parameters.
PARAM_ID NUMBER (15) Y Parameter ID
PROPERTY_ID NUMBER (15) Y Property ID
PROPERTY_VALUE VARCHAR2 (4000)
Property Value.
VALUE_OVERRIDE_FLAG VARCHAR2 (5)
Value Override flag indicates whether the Default property value can be overriden.
NOT_VALID_FLAG VARCHAR2 (5)
Indicates whether the row is valid or should be ignored.

[top of page]

IEU.IEU_WP_PARAM_PROPS_B does not reference any database object

IEU.IEU_WP_PARAM_PROPS_B is referenced by following:

APPS
SYNONYM - IEU_WP_PARAM_PROPS_B

[top of page]

Table: IEU_WP_PARAM_PROPS_TL

Description: Parameter-Property Details-TL
Primary Key: IEU_WP_PARAM_PROPS_TL_PK
  1. PARAM_PROPERTY_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_PARAM_PROPS_TL.PARAM_PROPERTY_ID IEU_WP_PARAM_PROPS_B
Comments

The table stores the Parameter-Property mappings for a specific Action-Parameter Set, for the properties that have VALUE_TRANSLATABLE_FLAG as 'Y'

Indexes
Index Type Tablespace Column
IEU_WP_PARAM_PROPS_TL_U1 UNIQUE APPS_TS_SEED PARAM_PROPERTY_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAM_PROPERTY_ID NUMBER (15) Y Parameter-Property ID
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
PROPERTY_VALUE VARCHAR2 (4000)
Action-ParameterLabel. This can also be displayed as Prompt if the Parameter is displayed on the UI.

[top of page]

IEU.IEU_WP_PARAM_PROPS_TL does not reference any database object

IEU.IEU_WP_PARAM_PROPS_TL is referenced by following:

APPS
SYNONYM - IEU_WP_PARAM_PROPS_TL

[top of page]

Table: IEU_WP_PROPERTIES_B

Description: Property Details-B
Primary Key: IEU_WP_PROPERTIES_B_PK
  1. PROPERTY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_WP_PROPERTIES_TL.PROPERTY_ID IEU_WP_PROPERTIES_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_PROPERTIES_B_U1 UNIQUE APPS_TS_SEED PROPERTY_ID
Columns
Name Datatype Length Mandatory Comments
PROPERTY_ID NUMBER (15) Y Primary Key - Uniquely identifies a Property.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
PROPERTY_NAME VARCHAR2 (128) Y Property name.
PROPERTY_SET_TYPE_CODE VARCHAR2 (64)
Indicates the Property Set type of one of the following. 'GENERAL' - general properties'UI_COMP_CATG_BASED' - UI Component Category based. Set Type ID = UI_COMP_CATG_ID
PROPERTY_SET_TYPE_ID NUMBER (15)
Property Set Type ID. It's value depnds upon the Property Set Type code.
PROPERTY_DEFAULT_VALUE VARCHAR2 (1996)
Property Default Value.
VALUE_OVERRIDE_FLAG VARCHAR2 (5)
Value Override flag indicates whether the Default property value can be overriden.
FORM_ITEM_PROPERTY_FLAG VARCHAR2 (5)
Indicates whether the Property is related to the Form Item component.
VALUE_TRANSLATABLE_FLAG VARCHAR2 (5)
Indicates whether the Property Value is translatable. If yes, then it goes in IEU_WP_PARAM_PROPS_TL table.
NOT_VALID_FLAG VARCHAR2 (5)
Indicates whether the row is valid or should be ignored.

[top of page]

IEU.IEU_WP_PROPERTIES_B does not reference any database object

IEU.IEU_WP_PROPERTIES_B is referenced by following:

APPS
SYNONYM - IEU_WP_PROPERTIES_B

[top of page]

Table: IEU_WP_PROPERTIES_TL

Description: Property Details - TL
Primary Key: IEU_WP_PROPERTIES_TL_PK
  1. PROPERTY_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_PROPERTIES_TL.PROPERTY_ID IEU_WP_PROPERTIES_B
Comments

The table stores the Labels and Description for the Properties that can be used by Action-Parameters. This is done for the Translation purposes for the Property labels that can be displayed on the UWQ-Panel Admin UI for the properties that can be overridden either by the Application Developers or the Customer-site Admins.

Indexes
Index Type Tablespace Column
IEU_WP_PROPERTIES_TL_U1 UNIQUE APPS_TS_SEED PROPERTY_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PROPERTY_ID NUMBER (15) Y Property ID
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
PROPERTY_LABEL VARCHAR2 (128) Y UWQ Property Label. This may be required to be displayed on UWQ-Panels Admin UI.
PROPERTY_DESCRIPTION VARCHAR2 (500)
Property Description.

[top of page]

IEU.IEU_WP_PROPERTIES_TL does not reference any database object

IEU.IEU_WP_PROPERTIES_TL is referenced by following:

APPS
SYNONYM - IEU_WP_PROPERTIES_TL

[top of page]

Table: IEU_WP_SECTIONS_B

Description: UWQ Work Panel Sections - B
Primary Key: IEU_WP_SECTIONS_B_PK
  1. SECTION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_WP_SECTIONS_TL.SECTION_ID IEU_WP_SECTIONS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_SECTIONS_B_U1 UNIQUE APPS_TS_SEED SECTION_ID
Columns
Name Datatype Length Mandatory Comments
SECTION_ID NUMBER (15) Y Primary Key - Uniquely identifies a Component.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SECTION_CODE VARCHAR2 (32) Y Section Code.

[top of page]

IEU.IEU_WP_SECTIONS_B does not reference any database object

IEU.IEU_WP_SECTIONS_B is referenced by following:

APPS
SYNONYM - IEU_WP_SECTIONS_B

[top of page]

Table: IEU_WP_SECTIONS_TL

Description: UWQ Work Panel Sections - TL
Primary Key: IEU_WP_SECTIONS_TL_PK
  1. SECTION_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_SECTIONS_TL.SECTION_ID IEU_WP_SECTIONS_B
Comments

UWQ Work Panel Sections - TL

Indexes
Index Type Tablespace Column
IEU_WP_SECTIONS_TL_U1 UNIQUE APPS_TS_SEED SECTION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SECTION_ID NUMBER (15) Y Section ID
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
SECTION_LABEL VARCHAR2 (128) Y Section Label.
SECTION_DESCRIPTION VARCHAR2 (500)
Section Description.

[top of page]

IEU.IEU_WP_SECTIONS_TL does not reference any database object

IEU.IEU_WP_SECTIONS_TL is referenced by following:

APPS
SYNONYM - IEU_WP_SECTIONS_TL

[top of page]

Table: IEU_WP_UI_COMPONENTS_B

Description: UWQ UI Components - B
Primary Key: IEU_WP_UI_COMPONENTS_B_PK
  1. UI_COMP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_WP_UI_COMPONENTS_TL.UI_COMP_ID IEU_WP_UI_COMPONENTS_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_UI_COMPONENTS_B_U1 UNIQUE APPS_TS_SEED UI_COMP_ID
Columns
Name Datatype Length Mandatory Comments
UI_COMP_ID NUMBER (15) Y Primary Key - Uniquely identifies a Component.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
UI_COMP_CATG_CODE VARCHAR2 (32) Y UI Component Category Code.
FORM_COMP_CODE VARCHAR2 (32)
UWQ Forms UI Component Code. This is used to map it dynamically at run-time to the appropriate Form component.
FORM_COMP_AVAIL_NO NUMBER (5)
This indicates the maximum number of Form UI components available, that can be used by the Application teams to specify for the parameters.
PROPERTY_CLASS VARCHAR2 (64)
Name of the Property Class used by the Component. In case of Forms, this may be for Information only.

[top of page]

IEU.IEU_WP_UI_COMPONENTS_B does not reference any database object

IEU.IEU_WP_UI_COMPONENTS_B is referenced by following:

APPS
SYNONYM - IEU_WP_UI_COMPONENTS_B

[top of page]

Table: IEU_WP_UI_COMPONENTS_TL

Description: UWQ UI Components - TL
Primary Key: IEU_WP_UI_COMPONENTS_TL_PK
  1. UI_COMP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_UI_COMPONENTS_TL.UI_COMP_ID IEU_WP_UI_COMPONENTS_B
Comments

UWQ UI Components. These can be attached to the Action-Parameters that need to be displayed on the UWQ Work-Panel.

Indexes
Index Type Tablespace Column
IEU_WP_UI_COMPONENTS_TL_U1 UNIQUE APPS_TS_SEED UI_COMP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
UI_COMP_ID NUMBER (15) Y UI Component ID
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
UI_COMP_LABEL VARCHAR2 (128) Y UI Component Label. This may be required to be displayed on UWQ-Panels Admin UI.
UI_COMP_DESC VARCHAR2 (500)
UI Component Description.

[top of page]

IEU.IEU_WP_UI_COMPONENTS_TL does not reference any database object

IEU.IEU_WP_UI_COMPONENTS_TL is referenced by following:

APPS
SYNONYM - IEU_WP_UI_COMPONENTS_TL

[top of page]

Table: IEU_WP_UI_COMP_CATG_B

Description: UWQ UI Component Categories - B
Primary Key: IEU_WP_UI_COMP_CATG_B_PK
  1. UI_COMP_CATG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEU_WP_UI_COMP_CATG_TL.UI_COMP_CATG_ID IEU_WP_UI_COMP_CATG_B
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_UI_COMP_CATG_B_U1 UNIQUE APPS_TS_SEED UI_COMP_CATG_ID
Columns
Name Datatype Length Mandatory Comments
UI_COMP_CATG_ID NUMBER (15) Y Primary Key - Uniquely identifies a Component Category.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
UI_COMP_CATG_CODE VARCHAR2 (32)
UI Component Category Code. This will be unique for the Component Categories defined.

[top of page]

IEU.IEU_WP_UI_COMP_CATG_B does not reference any database object

IEU.IEU_WP_UI_COMP_CATG_B is referenced by following:

APPS
SYNONYM - IEU_WP_UI_COMP_CATG_B

[top of page]

Table: IEU_WP_UI_COMP_CATG_TL

Description: UWQ UI Component Category - TL
Primary Key: IEU_WP_UI_COMP_CATG_TL_PK
  1. UI_COMP_CATG_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEU_WP_UI_COMP_CATG_TL.UI_COMP_CATG_ID IEU_WP_UI_COMP_CATG_B
Comments

UWQ UI Component Categories. These are the broad categories under which individual UI components can be grouped.

Indexes
Index Type Tablespace Column
IEU_WP_UI_COMP_CATG_TL_U1 UNIQUE APPS_TS_SEED UI_COMP_CATG_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
UI_COMP_CATG_ID NUMBER (15) Y UI Component Category Id
LANGUAGE VARCHAR2 (240) Y Language of the translation.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
SOURCE_LANG VARCHAR2 (240)
Source language of the translation.
UI_COMP_CATG_LABEL VARCHAR2 (128) Y UI Component Category Label. This may be required to be displayed on UWQ-Panels Admin UI.
UI_COMP_CATG_DESC VARCHAR2 (500)
UI Component Category Description.

[top of page]

IEU.IEU_WP_UI_COMP_CATG_TL does not reference any database object

IEU.IEU_WP_UI_COMP_CATG_TL is referenced by following:

APPS
SYNONYM - IEU_WP_UI_COMP_CATG_TL

[top of page]

Table: IEU_WP_UI_COMP_DATATYPES

Description: UI Component-Data Types mapping
Primary Key: IEU_WP_UI_COMP_DATATYPES_PK
  1. UI_COMP_DATATYPE_MAP_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
IEU_WP_UI_COMP_DATATYPES_U1 UNIQUE APPS_TS_SEED UI_COMP_DATATYPE_MAP_ID
Columns
Name Datatype Length Mandatory Comments
UI_COMP_DATATYPE_MAP_ID NUMBER (15) Y Primary Key - Uniquely identifies the UI component-Datatype mapping.
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
CREATED_BY NUMBER (15) Y Standard WHO columns.
CREATION_DATE DATE
Y Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO columns.
LAST_UPDATE_DATE DATE
Y Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
SECURITY_GROUP_ID NUMBER

Used in hosted environments.
UI_COMP_ID NUMBER (15) Y UI Component Id
DATA_TYPE VARCHAR2 (64) Y Indicates the Data Type supported by the UI component.

[top of page]

IEU.IEU_WP_UI_COMP_DATATYPES does not reference any database object

IEU.IEU_WP_UI_COMP_DATATYPES is referenced by following:

APPS
SYNONYM - IEU_WP_UI_COMP_DATATYPES

[top of page]

View: IEU_LOOKUPS

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y FND Lookup Type
LOOKUP_CODE VARCHAR2 (30) Y FND Lookup Code
MEANING VARCHAR2 (80) Y Meaning
DESCRIPTION VARCHAR2 (240)
Description
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active

[top of page]

APPS.IEU_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.IEU_LOOKUPS is referenced by following:

APPS
PACKAGE BODY - IEU_DIAG_AUDIT_TRACK_PVT

[top of page]

View: IEU_UWQ_BLENDED_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION CHAR (0)
Function to launch while getting work.
IEU_OBJECT_PARAMETERS CHAR (0)
Parameters to pass to the function.
IEU_MEDIA_TYPE_UUID VARCHAR2 (38) Y Media type of row.
IEU_PARAM_PK_COL CHAR (0)
Primary Key column
IEU_PARAM_PK_VALUE VARCHAR2 (1)
Primary Key value
IEU_DISPLAY_ORDER NUMBER

Display order for the queue.
RESOURCE_ID NUMBER (15) Y JTF resource ID that row belongs to.
RESOURCE_TYPE CHAR (13)
Resource type of the resource ID.
QUEUE_TYPE VARCHAR2 (1996) Y Type of queue.
QUEUE_NAME VARCHAR2 (500)
Name of queue (displayed to user).
QUEUE_COUNT NUMBER (10) Y Elements in queue (displayed to user).

[top of page]

APPS.IEU_UWQ_BLENDED_V references the following:

APPS
SYNONYM - IEU_UWQ_MEDIA_TYPES_B
SYNONYM - IEU_UWQ_MEDIA_TYPES_TL
SYNONYM - IEU_UWQ_SEL_MRT_DATA

APPS.IEU_UWQ_BLENDED_V is not referenced by any database object

[top of page]

View: IEU_UWQ_DISP_ORDER_AVAIL_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
AVAIL_NUM NUMBER

Available numbers to assign in display order LOV.

[top of page]

APPS.IEU_UWQ_DISP_ORDER_AVAIL_V references the following:

APPS
SYNONYM - IEU_UWQ_SEL_ENUMERATORS

APPS.IEU_UWQ_DISP_ORDER_AVAIL_V is not referenced by any database object

[top of page]

View: IEU_UWQ_ESC_MYOWN_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch when opening item.
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (13)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
ESCALATION_ID NUMBER
Y (see JTF Tasks schema).
ESCALATION_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
ESCALATION_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
ESCALATION_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
OPEN_DATE DATE

(see JTF Tasks schema).
TARGET_DATE DATE

(see JTF Tasks schema).
OWNER_TYPE_CODE VARCHAR2 (30) Y (see JTF Tasks schema).
OWNER_ID NUMBER
Y (see JTF Tasks schema).
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
CUST_ACCOUNT_NUMBER VARCHAR2 (0)
(see JTF Tasks schema).
ESCALATION_LEVEL VARCHAR2 (30)
(see JTF Tasks schema).
ESCALATION_LEVEL_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
REQUESTER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
OBJECT_NAME VARCHAR2 (30)
(see JTF Tasks schema).
OBJECT_CODE VARCHAR2 (30)
REF_DOC_ID NUMBER

(see JTF Tasks schema).
REF_DOC_NUMBER VARCHAR2 (80)
(see JTF Tasks schema).

[top of page]

APPS.IEU_UWQ_ESC_MYOWN_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - JTF_EC_UTIL
VIEW - JTF_ESC_UWQ_V
SYNONYM - JTF_OBJECTS_B
PACKAGE - JTF_TASK_UTL

APPS.IEU_UWQ_ESC_MYOWN_V is not referenced by any database object

[top of page]

View: IEU_UWQ_INBOUND_TEL_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION CHAR (0)
Function to launch while getting work.
IEU_OBJECT_PARAMETERS CHAR (0)
Parameters to pass to the function.
IEU_MEDIA_TYPE_UUID VARCHAR2 (38) Y Media type of row.
IEU_PARAM_PK_COL CHAR (10)
Primary Key column
IEU_PARAM_PK_VALUE VARCHAR2 (500)
Primary Key value
RESOURCE_ID NUMBER (15) Y JTF resource ID that row belongs to.
RESOURCE_TYPE CHAR (13)
Resource type of the resource ID.
QUEUE_TYPE VARCHAR2 (1996) Y Type of queue.
QUEUE_NAME VARCHAR2 (500)
Name of queue (displayed to user).
QUEUE_COUNT NUMBER (10) Y Elements in queue (displayed to user).

[top of page]

APPS.IEU_UWQ_INBOUND_TEL_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - IEU_UWQ_MEDIA_TYPES_B
SYNONYM - IEU_UWQ_MEDIA_TYPES_TL
SYNONYM - IEU_UWQ_SEL_MRT_DATA

APPS.IEU_UWQ_INBOUND_TEL_V is not referenced by any database object

[top of page]

View: IEU_UWQ_MACTION_DEFS_VL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

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

View of Action definitions used when accessing references in forms.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID of the row.
MACTION_DEF_ID NUMBER (15) Y ID of media action definition.
MACTION_DEF_KEY VARCHAR2 (32)
Unique Key for the Action.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
ACTION_PROC VARCHAR2 (200)
Action procedure.
ACTION_PROC_TYPE_CODE VARCHAR2 (1)
This is for different versions/types of Action(Foo) functions. The default is the one with the signature same as Media Action proc. 'E' - new signature for Non-Media Action functions.
APPLICATION_ID NUMBER (15) Y ID of application owning entry.
GLOBAL_FORM_PARAMS VARCHAR2 (500)
DO NOT USE (not supported).
MULTI_SELECT_FLAG VARCHAR2 (1)
The flag that indicates whether the Action is elligible in a Multi-Select mode.The valid values are: NULL/'N' - No (Default) 'Y' - Yes
MACTION_DEF_TYPE_FLAG VARCHAR2 (1)
Indicates whether this is the 'Media' Action vs. 'Non-Media' Action.Null - 'Media' Action, 'N' - 'Non-Media'
ACTION_USER_LABEL VARCHAR2 (1996) Y Action displayed to user.
ACTION_DESCRIPTION VARCHAR2 (1996)
Action description displayed to user.

[top of page]

APPS.IEU_UWQ_MACTION_DEFS_VL references the following:

APPS
SYNONYM - IEU_UWQ_MACTION_DEFS_B
SYNONYM - IEU_UWQ_MACTION_DEFS_TL

APPS.IEU_UWQ_MACTION_DEFS_VL is not referenced by any database object

[top of page]

View: IEU_UWQ_MEDIA_ACTIONS_VL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

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

View of media actions used when accessing references in forms.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID of the row.
MEDIA_ACTION_ID NUMBER (15) Y ID of media action.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
MEDIA_TYPE_ID NUMBER (15) Y ID of Media type.
MACTION_DEF_ID NUMBER (15) Y ID of media action definition.
APPLICATION_ID NUMBER (15) Y ID of application owning entry.
CLASSIFICATION VARCHAR2 (500)
Classification for action.
OTHER_PARAMS VARCHAR2 (500)
DO NOT USE (not supported).
ACTION_USER_LABEL VARCHAR2 (1996) Y Action displayed to user.
MEDIA_TYPE_NAME VARCHAR2 (1996) Y Media type displayed to user.

[top of page]

APPS.IEU_UWQ_MEDIA_ACTIONS_VL references the following:

APPS
SYNONYM - IEU_UWQ_MACTION_DEFS_TL
SYNONYM - IEU_UWQ_MEDIA_ACTIONS
SYNONYM - IEU_UWQ_MEDIA_TYPES_TL

APPS.IEU_UWQ_MEDIA_ACTIONS_VL is not referenced by any database object

[top of page]

View: IEU_UWQ_MEDIA_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION CHAR (0)
Function to launch for getting work
IEU_OBJECT_PARAMETERS CHAR (0)
Parameters to pass to the function.
IEU_MEDIA_TYPE_UUID VARCHAR2 (38) Y Media type of row.
IEU_PARAM_PK_COL CHAR (10)
Primary key column
IEU_PARAM_PK_VALUE NUMBER (10) Y Primary key value
IEU_DISPLAY_ORDER NUMBER (10)
Display order for the queue.
RESOURCE_ID NUMBER (15) Y JTF resource ID that row belongs to.
RESOURCE_TYPE CHAR (13)
Resource type of the resource ID.
QUEUE_TYPE VARCHAR2 (1996) Y Type of queue.
QUEUE_NAME VARCHAR2 (1996) Y Name of queue (displayed to user).
QUEUE_COUNT NUMBER (10)
Elements in queue (displayed to user).

[top of page]

APPS.IEU_UWQ_MEDIA_V references the following:

APPS
SYNONYM - IEU_UWQ_MEDIA_TYPES_B
SYNONYM - IEU_UWQ_MEDIA_TYPES_TL
SYNONYM - IEU_UWQ_SEL_RT_NODES

APPS.IEU_UWQ_MEDIA_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_GA_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch when opening item.
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y (See JTf Tasks Schema).
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_ID NUMBER

(See JTF Tasks Schema)
CUSTOMER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code
SOURCE_DOCUMENT_NAME VARCHAR2 (80)
(see JTF Tasks Schema).
DESCRIPTION VARCHAR2 (4000)
Task description, hidden column needed for work panel default value

[top of page]

APPS.IEU_UWQ_TASKS_GA_V references the following:

APPS
SYNONYM - HZ_TIMEZONES
SYNONYM - JTF_OBJECTS_B
SYNONYM - JTF_OBJECTS_TL
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_ALL_ASSIGNMENTS
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_TL
PACKAGE - JTF_TASK_UTL

APPS.IEU_UWQ_TASKS_GA_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_GO_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch when opening item.
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code
SOURCE_DOCUMENT_NAME VARCHAR2 (80)
(see JTF Tasks schema).
DESCRIPTION VARCHAR2 (4000)
Task description, hidden column needed for work panel default value

[top of page]

APPS.IEU_UWQ_TASKS_GO_V references the following:

APPS
SYNONYM - HZ_TIMEZONES
SYNONYM - JTF_OBJECTS_B
SYNONYM - JTF_OBJECTS_TL
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_TL
PACKAGE - JTF_TASK_UTL

APPS.IEU_UWQ_TASKS_GO_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_IA_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch when opening item.
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code
SOURCE_DOCUMENT_NAME VARCHAR2 (80)
(see JTf Tasks schema).
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
DESCRIPTION VARCHAR2 (4000)
Task description, hidden column needed for work panel default value

[top of page]

APPS.IEU_UWQ_TASKS_IA_V references the following:

APPS
SYNONYM - HZ_TIMEZONES
SYNONYM - JTF_OBJECTS_B
SYNONYM - JTF_OBJECTS_TL
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_ALL_ASSIGNMENTS
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_TL
PACKAGE - JTF_TASK_UTL

APPS.IEU_UWQ_TASKS_IA_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_IO_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch when opening item.
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code
SOURCE_DOCUMENT_NAME VARCHAR2 (80)
see JTF Tasks schema
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
DESCRIPTION VARCHAR2 (4000)
Task description, hidden column needed for work panel default value

[top of page]

APPS.IEU_UWQ_TASKS_IO_V references the following:

APPS
SYNONYM - HZ_TIMEZONES
SYNONYM - JTF_OBJECTS_B
SYNONYM - JTF_OBJECTS_TL
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_TL
PACKAGE - JTF_TASK_UTL

APPS.IEU_UWQ_TASKS_IO_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_MYOWN_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch when opening item.
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
CUSTOMER_ID NUMBER (15)
CUSTOMER_NAME VARCHAR2 (360)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
ESCALATION_LEVEL VARCHAR2 (30)
(see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
PRIMARY_PHONE VARCHAR2 (4000)
Primary Phone.
PRIMARY_EMAIL VARCHAR2 (2000)
Primary eMail
CREATION_DATE DATE
Y Creation Date
LAST_UPDATE_DATE DATE
Y Last Update Date
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code (Needed for Non-Media launch Action)
DESCRIPTION VARCHAR2 (4000)
Task description, hidden column needed for work panel default value
SOURCE_DOCUMENT_NAME VARCHAR2 (80)
(See JTF Tasks Schema).
OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

APPS.IEU_UWQ_TASKS_MYOWN_V references the following:

APPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_TIMEZONES
SYNONYM - JTF_OBJECTS_B
SYNONYM - JTF_OBJECTS_TL
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_CONTACTS
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_TL
PACKAGE - JTF_TASK_UWQ_PVT

APPS.IEU_UWQ_TASKS_MYOWN_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_NODE_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
NODE_LABEL VARCHAR2 (1996) Y Label for the tasks subnode.
COUNT NUMBER (10)
Count of items in the tasks subnode.
RESOURCE_ID NUMBER (15) Y JTF resource ID for the user.
RESOURCE_TYPE CHAR (13)
JTF resource type of the resource ID.
IEU_PARAM_PK_VALUE NUMBER (15) Y

[top of page]

APPS.IEU_UWQ_TASKS_NODE_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IEU_UWQ_SEL_RT_NODES
SYNONYM - JTF_RS_RESOURCE_EXTNS

APPS.IEU_UWQ_TASKS_NODE_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_TA_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch while opening work items
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code
SOURCE_DOCUMENT_NAME VARCHAR2 (80)
(See JTF Tasks Schema).
DESCRIPTION VARCHAR2 (4000)
Task description, hidden column needed for work panel default value

[top of page]

APPS.IEU_UWQ_TASKS_TA_V references the following:

APPS
SYNONYM - HZ_TIMEZONES
SYNONYM - JTF_OBJECTS_B
SYNONYM - JTF_OBJECTS_TL
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_ALL_ASSIGNMENTS
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_TL
PACKAGE - JTF_TASK_UTL

APPS.IEU_UWQ_TASKS_TA_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_TO_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch while opening work items
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
OBJECT_VERSION_NUMBER NUMBER
Y Standard column used by HTML utilities.
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code
SOURCE_DOCUMENT_NAME VARCHAR2 (80)
(see JTF Tasks schema)
DESCRIPTION VARCHAR2 (4000)
Task description, hidden column needed for work panel default value

[top of page]

APPS.IEU_UWQ_TASKS_TO_V references the following:

APPS
SYNONYM - HZ_TIMEZONES
SYNONYM - JTF_OBJECTS_B
SYNONYM - JTF_OBJECTS_TL
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_TL
PACKAGE - JTF_TASK_UTL

APPS.IEU_UWQ_TASKS_TO_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASKS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
Function to launch when opening item.
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to pass function when opening item.
IEU_MEDIA_TYPE_UUID CHAR (0)
Media type of row.
IEU_PARAM_PK_COL CHAR (16)
Indicates which column is the PK.
IEU_PARAM_PK_VALUE VARCHAR2 (40)
PK value.
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_NAME VARCHAR2 (80) Y (see JTF Tasks schema).
TASK_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_PRIORITY VARCHAR2 (30)
(see JTF Tasks schema).
PLANNED_START_DATE DATE

(see JTF Tasks schema).
PLANNED_END_DATE DATE

(see JTF Tasks schema).
SCHEDULED_START_DATE DATE

(see JTF Tasks schema).
SCHEDULED_END_DATE DATE

(see JTF Tasks schema).
ACTUAL_START_DATE DATE

(see JTF Tasks schema).
ACTUAL_END_DATE DATE

(see JTF Tasks schema).
SOURCE_OBJECT_TYPE VARCHAR2 (30) Y (see JTF Tasks schema).
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
(see JTF Tasks schema).
SOURCE_OBJECT_ID NUMBER

(see JTF Tasks schema).
OWNER_ID VARCHAR2 (0)
(see JTF Tasks schema).
OWNER_TYPE_CODE VARCHAR2 (0)
(see JTF Tasks schema).
OWNER VARCHAR2 (4000)
(see JTF Tasks schema).
CUSTOMER_NAME VARCHAR2 (360)
(see JTF Tasks schema).
CUST_ACCOUNT_NUMBER VARCHAR2 (0)
(see JTF Tasks schema).
GLOBAL_TIMEZONE_NAME VARCHAR2 (80)
(see JTF Tasks schema).
GMT_DEVIATION_HOURS NUMBER

(see JTF Tasks schema).
DURATION NUMBER

(see JTF Tasks schema).
DURATION_UOM VARCHAR2 (3)
(see JTF Tasks schema).
ESCALATION_LEVEL VARCHAR2 (0)
(see JTF Tasks schema).
ESCALATION_OWNER VARCHAR2 (0)
(see JTF Tasks schema).
OWNED_FLAG VARCHAR2 (30)
Indicator for an Owner/Assignee record.
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
CLOSED_FLAG CHAR (1)
Indicator for Closed/Open Task item
OWN_ASSIGN_LABEL VARCHAR2 (80) Y Label for Owned_Flag.
IEU_ACTION_OBJECT_CODE VARCHAR2 (30)
Action Object Code
ASSIGNEE_ROLE VARCHAR2 (30)
A new column introduced from JTF_TASKS schema as an Indicator for an Owner/Assignee record.

[top of page]

APPS.IEU_UWQ_TASKS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - JTF_TASK_UTL
VIEW - JTF_TASK_UWQ_V

APPS.IEU_UWQ_TASKS_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASK_GA_REF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y Group Member ID

[top of page]

APPS.IEU_UWQ_TASK_GA_REF_V references the following:

APPS
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASK_ALL_ASSIGNMENTS

APPS.IEU_UWQ_TASK_GA_REF_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASK_GO_REF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y Group Member ID

[top of page]

APPS.IEU_UWQ_TASK_GO_REF_V references the following:

APPS
SYNONYM - JTF_TASKS_B

APPS.IEU_UWQ_TASK_GO_REF_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASK_IA_REF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.

[top of page]

APPS.IEU_UWQ_TASK_IA_REF_V references the following:

APPS
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASK_ALL_ASSIGNMENTS

APPS.IEU_UWQ_TASK_IA_REF_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASK_IO_REF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
RESOURCE_TYPE VARCHAR2 (30) Y JTF resource TYPE of the resource ID.

[top of page]

APPS.IEU_UWQ_TASK_IO_REF_V references the following:

APPS
SYNONYM - JTF_TASKS_B

APPS.IEU_UWQ_TASK_IO_REF_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASK_TA_REF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y Group Member ID

[top of page]

APPS.IEU_UWQ_TASK_TA_REF_V references the following:

APPS
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASK_ALL_ASSIGNMENTS

APPS.IEU_UWQ_TASK_TA_REF_V is not referenced by any database object

[top of page]

View: IEU_UWQ_TASK_TO_REF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y (see JTF Tasks schema).
TASK_NUMBER VARCHAR2 (30) Y (see JTF Tasks schema).
TASK_STATUS_ID NUMBER
Y (see JTF Tasks schema).
TASK_TYPE_ID NUMBER
Y (see JTF Tasks schema).
RESOURCE_ID NUMBER
Y JTF resource ID that row belongs to.
OWNER_ID NUMBER
Y Group Member ID

[top of page]

APPS.IEU_UWQ_TASK_TO_REF_V references the following:

APPS
SYNONYM - JTF_TASKS_B

APPS.IEU_UWQ_TASK_TO_REF_V is not referenced by any database object

[top of page]

View: IEU_UWQ_WEB_CALLBACK_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION CHAR (0)
Function to launch while getting work.
IEU_OBJECT_PARAMETERS CHAR (0)
Parameters to pass to the function.
IEU_MEDIA_TYPE_UUID VARCHAR2 (38) Y Media type of row.
IEU_PARAM_PK_COL CHAR (10)
Primary Key column
IEU_PARAM_PK_VALUE VARCHAR2 (500)
Primary Key value
RESOURCE_ID NUMBER (15) Y JTF resource ID that row belongs to.
RESOURCE_TYPE CHAR (13)
Resource type of the resource ID.
QUEUE_TYPE VARCHAR2 (1996) Y Type of queue.
QUEUE_NAME VARCHAR2 (500)
Name of queue (displayed to user).
QUEUE_COUNT NUMBER (10) Y Elements in queue (displayed to user).

[top of page]

APPS.IEU_UWQ_WEB_CALLBACK_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - IEU_UWQ_MEDIA_TYPES_B
SYNONYM - IEU_UWQ_MEDIA_TYPES_TL
SYNONYM - IEU_UWQ_SEL_MRT_DATA

APPS.IEU_UWQ_WEB_CALLBACK_V is not referenced by any database object

[top of page]

View: IEU_WP_ACTION_PARAMS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

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

View of Action-Param maps.

Columns
Name Datatype Length Mandatory Comments
WP_ACTION_DEF_ID NUMBER (15) Y Action ID
PARAM_ID NUMBER (15) Y Parameter ID
PARAM_NAME VARCHAR2 (128) Y Action-Parameter name. This can be the actual paramtere name as being used in the PL/SQL procedure that handles the Action. This is passed along with it's value when the Action is called.
DATA_TYPE VARCHAR2 (64)
Indicates Data Type for the Action Parameter. Valid values are the FND Lookup codes for theFND Lookup Type as 'DATA_TYPES'.
PARAM_USER_LABEL VARCHAR2 (32) Y Parameter Label displayed to user.
PARAM_DESCRIPTION VARCHAR2 (500)
Parameter description displayed to user.

[top of page]

APPS.IEU_WP_ACTION_PARAMS_V references the following:

APPS
SYNONYM - IEU_WP_ACTION_PARAMS
SYNONYM - IEU_WP_PARAM_DEFS_B
SYNONYM - IEU_WP_PARAM_DEFS_TL

APPS.IEU_WP_ACTION_PARAMS_V is not referenced by any database object

[top of page]

View: IEU_WP_ACT_PARAM_SETS_VL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

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

View of Action-Param set definitions for forms, used for displaying Action-set labels as Actions in the UWQ Panels.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID of the row.
ACTION_PARAM_SET_ID NUMBER (15) Y Action Param Set ID
LAST_UPDATE_DATE DATE
Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
WP_ACTION_DEF_ID NUMBER (15) Y Action ID
ACTION_PARAM_SET_LABEL VARCHAR2 (128) Y Action displayed to user.
ACTION_PARAM_SET_DESC VARCHAR2 (500)
Action description displayed to user.

[top of page]

APPS.IEU_WP_ACT_PARAM_SETS_VL references the following:

APPS
SYNONYM - IEU_WP_ACT_PARAM_SETS_B
SYNONYM - IEU_WP_ACT_PARAM_SETS_TL

APPS.IEU_WP_ACT_PARAM_SETS_VL is not referenced by any database object

[top of page]

View: IEU_WP_TASK_OWNR_LOV_V

Comments
View Type

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

Resource list for task owner and assignees.

Columns
Name Datatype Length Mandatory Comments
IEU_LOV_COL1 VARCHAR2 (360)
LOV Column 1
IEU_LOV_COL2 VARCHAR2 (374)
LOV Column 2
IEU_LOV_COL3 VARCHAR2 (53)
LOV Column 3
IEU_LOV_COL4 VARCHAR2 (43)
LOV Column 4

[top of page]

APPS.IEU_WP_TASK_OWNR_LOV_V references the following:

APPS
VIEW - JTF_RS_GROUPS_VL
VIEW - JTF_RS_RESOURCE_EXTNS_VL

APPS.IEU_WP_TASK_OWNR_LOV_V is not referenced by any database object

[top of page]

View: IEU_WP_UI_COMPONENTS_VL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

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

View of UWQ UI Component definitionsthat can be used for associatimg with the Action-Parameters that are to be displayed on UWQ Work-Panel.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID of the row.
UI_COMP_ID NUMBER (15) Y UI Component ID
LAST_UPDATE_DATE DATE
Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
UI_COMP_CATG_CODE VARCHAR2 (32) Y UI Component Category Code.
FORM_COMP_CODE VARCHAR2 (32)
UWQ Forms UI Component Code. This is used to map it dynamically at run-time to the appropriate Form component.
FORM_COMP_AVAIL_NO NUMBER (5)
This indicates the maximum number of Form UI components available, that can be used by the Application teams to specify for the parameters.
PROPERTY_CLASS VARCHAR2 (64)
Name of the Property Class used by the Component. In case of Forms, this may be for Information only.
UI_COMP_LABEL VARCHAR2 (128) Y UI Component Label displayed to user.
UI_COMP_DESC VARCHAR2 (500)
UI Component description displayed to user.

[top of page]

APPS.IEU_WP_UI_COMPONENTS_VL references the following:

APPS
SYNONYM - IEU_WP_UI_COMPONENTS_B
SYNONYM - IEU_WP_UI_COMPONENTS_TL

APPS.IEU_WP_UI_COMPONENTS_VL is not referenced by any database object

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