VIEW: APPS.OKS_COV_ACTION_TIMES_HV

Source

View Text - Preformatted

SELECT cleb.rowid row_id ,cleb.id id ,cleb.object_version_number object_version_number ,cleb.cle_id bus_process_cle_id ,cleb.lse_id lse_id ,cleb.line_number line_number ,cleb.dnz_chr_id dnz_chr_id ,oksl.incident_severity_id incident_severity_id1 ,oksl.pdf_id process_def_id ,oksl.work_thru_yn work_thru_yn ,oksl.react_active_yn active_yn ,oksl.react_time_name reaction_time_name ,act.action_type_code action_type_code ,acy.uom_code uom_code ,acy.sun_duration sun_duration ,acy.mon_duration mon_duration ,acy.tue_duration tue_duration ,acy.wed_duration wed_duration ,acy.thu_duration thu_duration ,acy.fri_duration fri_duration ,acy.sat_duration sat_duration ,cleb.attribute_category attribute_category ,cleb.attribute1 attribute1 ,cleb.attribute2 attribute2 ,cleb.attribute3 attribute3 ,cleb.attribute4 attribute4 ,cleb.attribute5 attribute5 ,cleb.attribute6 attribute6 ,cleb.attribute7 attribute7 ,cleb.attribute8 attribute8 ,cleb.attribute9 attribute9 ,cleb.attribute10 attribute10 ,cleb.attribute11 attribute11 ,cleb.attribute12 attribute12 ,cleb.attribute13 attribute13 ,cleb.attribute14 attribute14 ,cleb.attribute15 attribute15 ,cleb.created_by created_by ,cleb.creation_date creation_date ,cleb.last_updated_by last_updated_by ,cleb.last_update_date last_update_date ,cleb.last_update_login last_update_login ,cleb.major_version major_version FROM OKC_K_LINES_BH CLEB ,OKS_K_LINES_HV OKSL ,OKS_ACTION_TIME_TYPES_H ACT ,OKS_ACTION_TIMES_H ACY WHERE cleb.lse_id in (4,17,22) AND oksl.cle_id = cleb.id AND act.cle_id = cleb.id AND acy.cov_action_type_id = act.id AND CLEB.major_version = OKSL.major_version AND CLEB.major_version = ACT.major_version and ACT.major_version = ACY.major_version

View Text - HTML Formatted

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLEB.CLE_ID BUS_PROCESS_CLE_ID
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, OKSL.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID1
, OKSL.PDF_ID PROCESS_DEF_ID
, OKSL.WORK_THRU_YN WORK_THRU_YN
, OKSL.REACT_ACTIVE_YN ACTIVE_YN
, OKSL.REACT_TIME_NAME REACTION_TIME_NAME
, ACT.ACTION_TYPE_CODE ACTION_TYPE_CODE
, ACY.UOM_CODE UOM_CODE
, ACY.SUN_DURATION SUN_DURATION
, ACY.MON_DURATION MON_DURATION
, ACY.TUE_DURATION TUE_DURATION
, ACY.WED_DURATION WED_DURATION
, ACY.THU_DURATION THU_DURATION
, ACY.FRI_DURATION FRI_DURATION
, ACY.SAT_DURATION SAT_DURATION
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CLEB.MAJOR_VERSION MAJOR_VERSION
FROM OKC_K_LINES_BH CLEB
, OKS_K_LINES_HV OKSL
, OKS_ACTION_TIME_TYPES_H ACT
, OKS_ACTION_TIMES_H ACY
WHERE CLEB.LSE_ID IN (4
, 17
, 22)
AND OKSL.CLE_ID = CLEB.ID
AND ACT.CLE_ID = CLEB.ID
AND ACY.COV_ACTION_TYPE_ID = ACT.ID
AND CLEB.MAJOR_VERSION = OKSL.MAJOR_VERSION
AND CLEB.MAJOR_VERSION = ACT.MAJOR_VERSION
AND ACT.MAJOR_VERSION = ACY.MAJOR_VERSION