SELECT ACC.ACCESS_ID , B.INSTANCE_STATUS_ID , B.NAME , B.DESCRIPTION , B.TERMINATED_FLAG , B.STATUS_CHANGE_ALLOWED_FLAG , B.INCIDENT_ALLOWED_FLAG , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE FROM CSI_INSTANCE_STATUSES B , CSM_INSTANCE_STATUSES_ACC ACC WHERE B.INSTANCE_STATUS_ID = ACC.INSTANCE_STATUS_ID
SELECT ACC.ACCESS_ID
, B.INSTANCE_STATUS_ID
, B.NAME
, B.DESCRIPTION
, B.TERMINATED_FLAG
, B.STATUS_CHANGE_ALLOWED_FLAG
, B.INCIDENT_ALLOWED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
FROM CSI_INSTANCE_STATUSES B
, CSM_INSTANCE_STATUSES_ACC ACC
WHERE B.INSTANCE_STATUS_ID = ACC.INSTANCE_STATUS_ID
|
|
|