DBA Data[Home] [Help]

VIEW: APPS.OKS_ENT_REACT_TIME_L_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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