SELECT ACC.ACCESS_ID ,B.ALLOWED_STATUS_ID ,B.STATUS_GROUP_ID ,B.INCIDENT_STATUS_ID ,B.START_DATE ,B.END_DATE from CS_SR_ALLOWED_STATUSES B ,CSM_SR_ALLOWED_STATUSES_ACC ACC WHERE B.ALLOWED_STATUS_ID = ACC.ALLOWED_STATUS_ID
SELECT ACC.ACCESS_ID
, B.ALLOWED_STATUS_ID
, B.STATUS_GROUP_ID
, B.INCIDENT_STATUS_ID
, B.START_DATE
, B.END_DATE
FROM CS_SR_ALLOWED_STATUSES B
, CSM_SR_ALLOWED_STATUSES_ACC ACC
WHERE B.ALLOWED_STATUS_ID = ACC.ALLOWED_STATUS_ID
|
|
|