[Home] [Help] [Dependency Information]
Object Name: | OKS_ENT_REACT_TIME_L_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_ENT_REACT_TIME_L_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.OKS_ENT_REACT_TIME_L_V is not referenced by any database object
|
|
|