VIEW: APPS.CSM_COV_ACTION_TIMES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.ID, B.OBJECT_VERSION_NUMBER, B.BUS_PROCESS_CLE_ID, B.LSE_ID, B.LINE_NUMBER, B.DNZ_CHR_ID, B.INCIDENT_SEVERITY_ID1, B.PROCESS_DEF_ID, B.WORK_THRU_YN, B.ACTIVE_YN, B.REACTION_TIME_NAME, B.ACTION_TYPE_CODE, B.UOM_CODE, B.SUN_DURATION, B.MON_DURATION, B.TUE_DURATION, B.WED_DURATION, B.THU_DURATION, B.FRI_DURATION, B.SAT_DURATION, ACC.JTOT_OBJECT1_CODE AS OBJECT_CODE, ACC.OBJECT1_ID1 AS BUSINESS_PROCESS_ID, ACC.CONTRACT_SERVICE_ID FROM OKS_COV_ACTION_TIMES_V B, CSM_COV_ACTION_TIMES_ACC ACC WHERE B.ID = ACC.ID AND B.INCIDENT_SEVERITY_ID1 = ACC.INCIDENT_SEVERITY_ID1 AND B.ACTION_TYPE_CODE = ACC.ACTION_TYPE_CODE AND ACC.USER_ID =ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.ID
, B.OBJECT_VERSION_NUMBER
, B.BUS_PROCESS_CLE_ID
, B.LSE_ID
, B.LINE_NUMBER
, B.DNZ_CHR_ID
, B.INCIDENT_SEVERITY_ID1
, B.PROCESS_DEF_ID
, B.WORK_THRU_YN
, B.ACTIVE_YN
, B.REACTION_TIME_NAME
, B.ACTION_TYPE_CODE
, B.UOM_CODE
, B.SUN_DURATION
, B.MON_DURATION
, B.TUE_DURATION
, B.WED_DURATION
, B.THU_DURATION
, B.FRI_DURATION
, B.SAT_DURATION
, ACC.JTOT_OBJECT1_CODE AS OBJECT_CODE
, ACC.OBJECT1_ID1 AS BUSINESS_PROCESS_ID
, ACC.CONTRACT_SERVICE_ID
FROM OKS_COV_ACTION_TIMES_V B
, CSM_COV_ACTION_TIMES_ACC ACC
WHERE B.ID = ACC.ID
AND B.INCIDENT_SEVERITY_ID1 = ACC.INCIDENT_SEVERITY_ID1
AND B.ACTION_TYPE_CODE = ACC.ACTION_TYPE_CODE
AND ACC.USER_ID =ASG_BASE.GET_USER_ID