Product: | OKS - Service Contracts |
---|---|
Description: | Lists all Reaction time detail informations. |
Implementation/DBA Data: | APPS.OKS_ENT_REACT_TIME_L_V |
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