VIEW: APPS.JTM_CS_INCIDENT_TYPES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.INCIDENT_TYPE_ID , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.PARENT_INCIDENT_TYPE_ID , B.BUSINESS_PROCESS_ID , B.WEIGHT , TL.NAME , TL.LANGUAGE FROM CS_INCIDENT_TYPES_B B , CS_INCIDENT_TYPES_TL TL , JTM_CS_INCIDENT_TYPES_ACC ACC WHERE B.INCIDENT_TYPE_ID = TL.INCIDENT_TYPE_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND ACC.INCIDENT_TYPE_ID = B.INCIDENT_TYPE_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.INCIDENT_TYPE_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.PARENT_INCIDENT_TYPE_ID
, B.BUSINESS_PROCESS_ID
, B.WEIGHT
, TL.NAME
, TL.LANGUAGE
FROM CS_INCIDENT_TYPES_B B
, CS_INCIDENT_TYPES_TL TL
, JTM_CS_INCIDENT_TYPES_ACC ACC
WHERE B.INCIDENT_TYPE_ID = TL.INCIDENT_TYPE_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND ACC.INCIDENT_TYPE_ID = B.INCIDENT_TYPE_ID