VIEW: APPS.CSM_SR_TYPE_MAPPING_V

Source

View Text - Preformatted

SELECT acc.ACCESS_ID, b.INCIDENT_TYPE_ID, b.RESPONSIBILITY_ID, b.START_DATE, b.END_DATE, b.STATUS_GROUP_ID, b.APPLICATION_ID, b.BUSINESS_USAGE FROM CSM_SR_TYPE_MAPPING_ACC acc, CS_SR_TYPE_MAPPING b WHERE acc.INCIDENT_TYPE_ID = b.INCIDENT_TYPE_ID AND acc.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID AND acc.USER_ID = asg_base.get_user_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.INCIDENT_TYPE_ID
, B.RESPONSIBILITY_ID
, B.START_DATE
, B.END_DATE
, B.STATUS_GROUP_ID
, B.APPLICATION_ID
, B.BUSINESS_USAGE
FROM CSM_SR_TYPE_MAPPING_ACC ACC
, CS_SR_TYPE_MAPPING B
WHERE ACC.INCIDENT_TYPE_ID = B.INCIDENT_TYPE_ID
AND ACC.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID