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]

VIEW: APPS.IEX_WORK_ITEM_DET_V

Object Details

Object Name:	IEX_WORK_ITEM_DET_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_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)

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

Dependencies

[top of page]

APPS.IEX_WORK_ITEM_DET_V references the following:

APPS: IEX_STRATEGY_WORK_ITEMS; IEX_STRY_TEMP_WORK_ITEMS_VL; JTF_RS_RESOURCE_EXTNS

APPS.IEX_WORK_ITEM_DET_V is not referenced by any database object