View: OKS_ENT_REACT_TIME_L_V

Product:	OKS - Service Contracts
Description:	Lists all Reaction time detail informations.
Implementation/DBA Data:	APPS.OKS_ENT_REACT_TIME_L_V

View Text

SELECT ACT.ID REACTION_INTERVAL_ID
, ACM.ID TIME_VALUE_ID
, NULL REACTION_ON
, ACM.UOM_CODE REACT_TUOM
, NULL REACT_WITHIN_TIME
, SUN_DURATION SUNDAY_REACT_RESOLVE_TIME
, MON_DURATION MONDAY_REACT_RESOLVE_TIME
, TUE_DURATION TUESDAY_REACT_RESOLVE_TIME
, WED_DURATION WEDNESDAY_REACT_RESOLVE_TIME
, THU_DURATION THURSDAY_REACT_RESOLVE_TIME
, FRI_DURATION FRIDAY_REACT_RESOLVE_TIME
, SAT_DURATION SATURDAY_REACT_RESOLVE_TIME
, ACT.ACTION_TYPE_CODE TIME_TYPE
FROM OKS_ACTION_TIME_TYPES ACT
, OKS_ACTION_TIMES ACM
WHERE ACT.ID = ACM.COV_ACTION_TYPE_ID

Columns