VIEW: APPS.CSM_SR_STATUS_GROUPS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID ,B.STATUS_GROUP_ID ,B.DEFAULT_INCIDENT_STATUS_ID ,B.TRANSITION_IND ,B.START_DATE ,B.END_DATE ,TL.GROUP_NAME ,TL.DESCRIPTION FROM CSM_SR_STATUS_GROUPS_ACC ACC, CS_SR_STATUS_GROUPS_B B, CS_SR_STATUS_GROUPS_TL TL WHERE B.STATUS_GROUP_ID = ACC.STATUS_GROUP_ID AND B.STATUS_GROUP_ID = TL.STATUS_GROUP_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.STATUS_GROUP_ID
, B.DEFAULT_INCIDENT_STATUS_ID
, B.TRANSITION_IND
, B.START_DATE
, B.END_DATE
, TL.GROUP_NAME
, TL.DESCRIPTION
FROM CSM_SR_STATUS_GROUPS_ACC ACC
, CS_SR_STATUS_GROUPS_B B
, CS_SR_STATUS_GROUPS_TL TL
WHERE B.STATUS_GROUP_ID = ACC.STATUS_GROUP_ID
AND B.STATUS_GROUP_ID = TL.STATUS_GROUP_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE