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

VIEW: APPS.IEX_WORK_ITEM_DET_HIS_V

Object Details
Object Name: IEX_WORK_ITEM_DET_HIS_V
Object Type: VIEW
Owner: APPS
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
WORK_ITEM_ID NUMBER (25) Yes Work Item Id
WORK_ITEM_TEMPLATE_ID NUMBER (25) Yes Work Item Template Id
CATEGORY_TYPE VARCHAR2 (30)
(SEND LETTER,CALL,VISIT) CURRENT CATEGORY types
STATUS_CODE VARCHAR2 (30)
Stategy Status
WORKFLOW_ITEM_TYPE VARCHAR2 (60)
Work Flow type associated to work flow work item
WORK_TYPE VARCHAR2 (30)
Work Type Currently Auto/Manual
LAST_UPDATE_DATE DATE
Yes Standard who column - date when this row was created.
COMPETENCE_ID NUMBER (25)
Skill associated to this work item.
OPTIONAL_YN VARCHAR2 (5)
Is this Work Item Optional? Yes/No
OPTION_WAIT_TIME NUMBER

How long will the strategy wait before it skips this work item?
OPTION_WAIT_TIME_UOM VARCHAR2 (60)
Unit of measure for optional wait time(Minutes/Hours/Days/Months/Years)
PRE_EXECUTION_WAIT NUMBER

How long will the strategy wait until it executes this work item?
POST_EXECUTION_WAIT NUMBER

How long will the strategy wait until it executes this work item?
EXECUTION_TIME_UOM VARCHAR2 (240)
Unit of Measurement for Execution time(Minutes/Hours/Days/Months/Years)
PRE_EXECUTION_TIME_UOM VARCHAR2 (240)
Unit of Measurement for Pre-wait time(Minutes/Hours/Days/Months/Years)
FULFIL_TEMP_ID NUMBER

Fulfillment template ID of Dunning letter for automatic work item
XDO_TEMPLATE_ID NUMBER

XML publisher template ID of Dunning letter for automatic work item
NOTIFY_YN VARCHAR2 (3)
Notify the assignee when work item is created - Yes/No.
OBJECT_VERSION_NUMBER NUMBER
Yes Standard HTML front end column
WKITEM_TEMPLATE_NAME VARCHAR2 (240) Yes Work Item Template Name
SCHEDULE_START DATE

Scheduled Start Date of Work Item
SCHEDULE_END DATE

Scheduled End Date of Work Item
EXECUTION_START DATE

Actual Start Date of Work Item
EXECUTION_END DATE

Actual End Date of Work Item
ESCALTED_YN VARCHAR2 (1)
Is thr Work item Esclated? Yes/No
ESCALATE_YN VARCHAR2 (6)
Escalate this Work Item Yes/No
ESCALATE_WAIT_TIME NUMBER

How long will the strategy wait before it escalates this work item?
ESCALATE_WAIT_TIME_UOM VARCHAR2 (60)
Unit of Measure for escalate wait time(Minutes/Hours/Days/Months/Years)
CUSTOM_WORKFLOW_TYPE VARCHAR2 (240)
Custom Work Flow type associated to work flow work item
STRATEGY_ID NUMBER (25) Yes Strategy Id
SOURCE_NAME VARCHAR2 (360)
Strategy Name
Query Text

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_HIS_V;

Dependencies

[top of page]

APPS.IEX_WORK_ITEM_DET_HIS_V references the following:

SchemaAPPS
SynonymIEX_STRATEGY_WORK_ITEM_HIS
ViewIEX_STRY_TEMP_WORK_ITEMS_VL
SynonymJTF_RS_RESOURCE_EXTNS

APPS.IEX_WORK_ITEM_DET_HIS_V is not referenced by any database object