VIEW: APPS.JTM_CS_INCIDENT_STATUSES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.INCIDENT_STATUS_ID , B.DISPLAY_COLOR , B.RGB_COLOR , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.STATUS_CODE , B.CLOSE_FLAG , B.DISALLOW_REQUEST_UPDATE , B.DISALLOW_NEW_ACTION , B.DISALLOW_ACTION_UPDATE , B.DISALLOW_NEW_CHARGE , B.DISALLOW_AGENT_DISPATCH , B.DISALLOW_RMA , B.DISALLOW_CHARGE_UPDATE , B.DISALLOW_PRODUCT_UPDATE , TL.NAME , TL.LANGUAGE , B.VALID_IN_CREATE_FLAG FROM CS_INCIDENT_STATUSES_B B , CS_INCIDENT_STATUSES_TL TL , JTM_CS_INCIDENT_STATUSES_ACC ACC WHERE B.INCIDENT_STATUS_ID = TL.INCIDENT_STATUS_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND ACC.INCIDENT_STATUS_ID = B.INCIDENT_STATUS_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.INCIDENT_STATUS_ID
, B.DISPLAY_COLOR
, B.RGB_COLOR
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.STATUS_CODE
, B.CLOSE_FLAG
, B.DISALLOW_REQUEST_UPDATE
, B.DISALLOW_NEW_ACTION
, B.DISALLOW_ACTION_UPDATE
, B.DISALLOW_NEW_CHARGE
, B.DISALLOW_AGENT_DISPATCH
, B.DISALLOW_RMA
, B.DISALLOW_CHARGE_UPDATE
, B.DISALLOW_PRODUCT_UPDATE
, TL.NAME
, TL.LANGUAGE
, B.VALID_IN_CREATE_FLAG
FROM CS_INCIDENT_STATUSES_B B
, CS_INCIDENT_STATUSES_TL TL
, JTM_CS_INCIDENT_STATUSES_ACC ACC
WHERE B.INCIDENT_STATUS_ID = TL.INCIDENT_STATUS_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND ACC.INCIDENT_STATUS_ID = B.INCIDENT_STATUS_ID