[Home] [Help] [Dependency Information]
Object Name: | IEU_UWQ_SEL_ENUMERATORS |
---|---|
Object Type: | TABLE |
Owner: | IEU |
FND Design Data: | IEU.IEU_UWQ_SEL_ENUMERATORS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
IEU.IEU_UWQ_SEL_ENUMERATORS does not reference any database object
IEU.IEU_UWQ_SEL_ENUMERATORS is referenced by following:
|
|
|