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.JTF_ESC_UWQ_V

Object Details

Object Name:	JTF_ESC_UWQ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_ESC_UWQ_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains escalation details to be displayed in Universal Work Queue.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ESCALATION_ID	NUMBER		Yes	Unique Id for escalation
ESCALATION_NUMBER	VARCHAR2	(30)	Yes	Task Number
ESCALATION_NAME	VARCHAR2	(4000)		Escalation name
ESCALATION_STATUS	VARCHAR2	(30)	Yes	Name of the escalation status
OPEN_DATE	DATE			Escalation open date
TARGET_DATE	DATE			Escalation Target Date
CLOSE_DATE	DATE			Escalation Close Date
OWNER_TYPE_CODE	VARCHAR2	(30)	Yes	Resource type identifier of escalation owner
OWNER_ID	NUMBER		Yes	Id of the escalation owner
OWNER	VARCHAR2	(4000)		Owner of the escalation
CUSTOMER_NAME	VARCHAR2	(4000)		Customer associated with the escalation
CUST_ACCOUNT_NUMBER	VARCHAR2	(0)		Customer account number
ESCALATION_LEVEL_NAME	VARCHAR2	(80)	Yes	Name of escalation level
ESCALATION_LEVEL	VARCHAR2	(30)		Escalation level
REQUESTER_NAME	VARCHAR2	(4000)		Name of resource requesting the escalation
RESOURCE_ID	NUMBER		Yes	Resource Id of requester
RESOURCE_TYPE	VARCHAR2	(30)	Yes	Resource type of requester
REF_DOC_NUMBER	VARCHAR2	(80)		Object Number
REF_DOC_ID	NUMBER			Object Id
OBJECT_CODE	VARCHAR2	(30)		Object code for reference document
OBJECT_NAME	VARCHAR2	(30)		Object name for reference document
OBJECT_PARAMETERS	VARCHAR2	(2000)		Object parameters for reference document
OBJECT_FUNCTION	VARCHAR2	(30)		Object function for reference document

Query Text

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


SELECT ESCALATION_ID
,      ESCALATION_NUMBER
,      ESCALATION_NAME
,      ESCALATION_STATUS
,      OPEN_DATE
,      TARGET_DATE
,      CLOSE_DATE
,      OWNER_TYPE_CODE
,      OWNER_ID
,      OWNER
,      CUSTOMER_NAME
,      CUST_ACCOUNT_NUMBER
,      ESCALATION_LEVEL_NAME
,      ESCALATION_LEVEL
,      REQUESTER_NAME
,      RESOURCE_ID
,      RESOURCE_TYPE
,      REF_DOC_NUMBER
,      REF_DOC_ID
,      OBJECT_CODE
,      OBJECT_NAME
,      OBJECT_PARAMETERS
,      OBJECT_FUNCTION
FROM APPS.JTF_ESC_UWQ_V;

Dependencies

[top of page]

APPS.JTF_ESC_UWQ_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_EC_UTIL - show dependent code; JTF_OBJECTS_B; JTF_OBJECTS_TL; JTF_TASKS_B; JTF_TASKS_TL; JTF_TASK_REFERENCES_B; JTF_TASK_STATUSES_B; JTF_TASK_STATUSES_TL; JTF_TASK_UTL - show dependent code

APPS.JTF_ESC_UWQ_V is referenced by following:

APPS: IEU_UWQ_ESC_MYOWN_V