SELECT ACC.ACCESS_ID , B.INCIDENT_CYCLE_STEPS_ID , B.INCIDENT_STATUS_ID , B.INCIDENT_TYPE_ID , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE FROM CS_INCIDENT_CYCLE_STEPS B , JTM_CS_INCI_CYCLE_STEPS_ACC ACC WHERE B.INCIDENT_CYCLE_STEPS_ID = ACC.INCIDENT_CYCLE_STEPS_ID
SELECT ACC.ACCESS_ID
, B.INCIDENT_CYCLE_STEPS_ID
, B.INCIDENT_STATUS_ID
, B.INCIDENT_TYPE_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
FROM CS_INCIDENT_CYCLE_STEPS B
, JTM_CS_INCI_CYCLE_STEPS_ACC ACC
WHERE B.INCIDENT_CYCLE_STEPS_ID = ACC.INCIDENT_CYCLE_STEPS_ID
|
|
|