eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IEU.IEU_UWQ_SEL_ENUMERATORS

Object Details

Object Name:	IEU_UWQ_SEL_ENUMERATORS
Object Type:	TABLE
Owner:	IEU
FND Design Data:	IEU.IEU_UWQ_SEL_ENUMERATORS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

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

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEU_UWQ_SEL_ENUMERATORS_U1	NORMAL	UNIQUE	APPS_TS_SEED	ENUM_TYPE_UUID
IEU_UWQ_SEL_ENUMERATORS_U2	NORMAL	UNIQUE	APPS_TS_SEED	SEL_ENUM_ID
IEU_UWQ_SEL_ENUMERATORS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	MEDIA_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SEL_ENUM_ID	NUMBER	(15)	Yes	Uniquely identifies a node enumerator.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO columns.
CREATION_DATE	DATE		Yes	Standard WHO columns.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO columns.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO columns.
ENUM_PROC	VARCHAR2	(256)		Fully qualified enumeration function.
ENUM_TYPE_UUID	VARCHAR2	(38)	Yes	Universally unique identifier of the enumeration type.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard column used by HTML utilities.
APPLICATION_ID	NUMBER		Yes	Identifies the application owning the data.
WORK_Q_LABEL_LU_TYPE	VARCHAR2	(30)	Yes	Lookup Type for a Label that can be displayed on UIs to identify the work type.
WORK_Q_LABEL_LU_CODE	VARCHAR2	(30)	Yes	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.

Query Text

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


SELECT SEL_ENUM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ENUM_PROC
,      ENUM_TYPE_UUID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      WORK_Q_LABEL_LU_TYPE
,      WORK_Q_LABEL_LU_CODE
,      WORK_Q_ENABLE_PROFILE_OPTION
,      WORK_Q_ORDER_PROFILE_OPTION
,      WORK_Q_ORDER_SYSTEM_DEFAULT
,      WORK_Q_VIEW_FOR_PRIMARY_NODE
,      REFRESH_PROC
,      WORK_Q_VIEW_EXTRA_WHERE
,      MEDIA_TYPE_ID
,      DEFAULT_RES_CAT_ID
,      RES_CAT_PROFILE_OPT
,      NOT_FOR_MYWORK_FLAG
,      NOT_VALID_FLAG
,      WORK_Q_REGISTER_TYPE
,      ACTION_PROC
,      ACTION_PROC_TYPE_CODE
,      ACTION_OBJECT_CODE
,      WORK_PANEL_REGISTERED_FLAG
FROM IEU.IEU_UWQ_SEL_ENUMERATORS;

Dependencies

[top of page]

IEU.IEU_UWQ_SEL_ENUMERATORS does not reference any database object

IEU.IEU_UWQ_SEL_ENUMERATORS is referenced by following:

APPS: IEU_UWQ_SEL_ENUMERATORS