DBA Data[Home] [Help]

VIEW: APPS.CSM_SR_ALLOWED_STATUSES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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