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

VIEW: APPS.OKS_ENT_REACT_TIME_L_V

Object Details
Object Name: OKS_ENT_REACT_TIME_L_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_ENT_REACT_TIME_L_V
Subobject Name:
Status: VALID

View Type

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


Lists all Reaction time detail informations. It says after how many hours/days/etc. the engineer should react to the problem explained by the customer.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REACTION_INTERVAL_ID NUMBER
Yes Reaction Time Interval Identifier (Rule Identifier)
TIME_VALUE_ID NUMBER
Yes Time Value Identifier
REACTION_ON VARCHAR2 (0)
React on
REACT_TUOM VARCHAR2 (30)
Unit Of Measure
REACT_WITHIN_TIME VARCHAR2 (0)
Duration
SUNDAY_REACT_RESOLVE_TIME NUMBER

Sunday React Resolve Time
MONDAY_REACT_RESOLVE_TIME NUMBER

Monday React Resolve Time
TUESDAY_REACT_RESOLVE_TIME NUMBER

Tuesday React Resolve Time
WEDNESDAY_REACT_RESOLVE_TIME NUMBER

Wednesday React Resolve Time
THURSDAY_REACT_RESOLVE_TIME NUMBER

Thursday React Resolve Time
FRIDAY_REACT_RESOLVE_TIME NUMBER

Friday React Resolve Time
SATURDAY_REACT_RESOLVE_TIME NUMBER

Saturday React Resolve Time
TIME_TYPE VARCHAR2 (30)
Time Type
Query Text

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


SELECT REACTION_INTERVAL_ID
,      TIME_VALUE_ID
,      REACTION_ON
,      REACT_TUOM
,      REACT_WITHIN_TIME
,      SUNDAY_REACT_RESOLVE_TIME
,      MONDAY_REACT_RESOLVE_TIME
,      TUESDAY_REACT_RESOLVE_TIME
,      WEDNESDAY_REACT_RESOLVE_TIME
,      THURSDAY_REACT_RESOLVE_TIME
,      FRIDAY_REACT_RESOLVE_TIME
,      SATURDAY_REACT_RESOLVE_TIME
,      TIME_TYPE
FROM APPS.OKS_ENT_REACT_TIME_L_V;

Dependencies

[top of page]

APPS.OKS_ENT_REACT_TIME_L_V references the following:

SchemaAPPS
SynonymOKS_ACTION_TIMES
SynonymOKS_ACTION_TIME_TYPES

APPS.OKS_ENT_REACT_TIME_L_V is not referenced by any database object