[Home] [Help] [Dependency Information]
Object Name: | IEX_WORK_ITEM_DET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORK_ITEM_ID | NUMBER | (25) | Yes | |
WORK_ITEM_TEMPLATE_ID | NUMBER | (25) | Yes | |
CATEGORY_TYPE | VARCHAR2 | (30) | (SEND LETTER,CALL,VISIT) CURRENT CATEGORY types | |
STATUS_CODE | VARCHAR2 | (30) | ||
WORKFLOW_ITEM_TYPE | VARCHAR2 | (60) | ||
WORK_TYPE | VARCHAR2 | (30) | Work Type Currently Auto/Manual | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
COMPETENCE_ID | NUMBER | (25) | ||
OPTIONAL_YN | VARCHAR2 | (5) | ||
OPTION_WAIT_TIME | NUMBER | |||
OPTION_WAIT_TIME_UOM | VARCHAR2 | (60) | ||
PRE_EXECUTION_WAIT | NUMBER | |||
POST_EXECUTION_WAIT | NUMBER | |||
EXECUTION_TIME_UOM | VARCHAR2 | (240) | ||
PRE_EXECUTION_TIME_UOM | VARCHAR2 | (240) | ||
FULFIL_TEMP_ID | NUMBER | |||
XDO_TEMPLATE_ID | NUMBER | |||
NOTIFY_YN | VARCHAR2 | (3) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard HTML front end column | |
WKITEM_TEMPLATE_NAME | VARCHAR2 | (240) | Yes | Stores actual note text. Typically will hold the entire note, or up to 2000 characters if the note is very long. |
SCHEDULE_START | DATE | |||
SCHEDULE_END | DATE | |||
EXECUTION_START | DATE | |||
EXECUTION_END | DATE | |||
ESCALTED_YN | VARCHAR2 | (1) | ||
ESCALATE_YN | VARCHAR2 | (6) | ||
ESCALATE_WAIT_TIME | NUMBER | |||
ESCALATE_WAIT_TIME_UOM | VARCHAR2 | (60) | ||
CUSTOM_WORKFLOW_TYPE | VARCHAR2 | (240) | ||
STRATEGY_ID | NUMBER | (25) | Yes | |
SOURCE_NAME | VARCHAR2 | (360) |
Cut, paste (and edit) the following text to query this object:
SELECT WORK_ITEM_ID
, WORK_ITEM_TEMPLATE_ID
, CATEGORY_TYPE
, STATUS_CODE
, WORKFLOW_ITEM_TYPE
, WORK_TYPE
, LAST_UPDATE_DATE
, COMPETENCE_ID
, OPTIONAL_YN
, OPTION_WAIT_TIME
, OPTION_WAIT_TIME_UOM
, PRE_EXECUTION_WAIT
, POST_EXECUTION_WAIT
, EXECUTION_TIME_UOM
, PRE_EXECUTION_TIME_UOM
, FULFIL_TEMP_ID
, XDO_TEMPLATE_ID
, NOTIFY_YN
, OBJECT_VERSION_NUMBER
, WKITEM_TEMPLATE_NAME
, SCHEDULE_START
, SCHEDULE_END
, EXECUTION_START
, EXECUTION_END
, ESCALTED_YN
, ESCALATE_YN
, ESCALATE_WAIT_TIME
, ESCALATE_WAIT_TIME_UOM
, CUSTOM_WORKFLOW_TYPE
, STRATEGY_ID
, SOURCE_NAME
FROM APPS.IEX_WORK_ITEM_DET_V;
APPS.IEX_WORK_ITEM_DET_V is not referenced by any database object
|
|
|