DBA Data[Home] [Help]

VIEW: APPS.JTM_CS_INCIDENT_CYCLE_STEPS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.INCIDENT_CYCLE_STEPS_ID , B.INCIDENT_STATUS_ID , B.INCIDENT_TYPE_ID , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE FROM CS_INCIDENT_CYCLE_STEPS B , JTM_CS_INCI_CYCLE_STEPS_ACC ACC WHERE B.INCIDENT_CYCLE_STEPS_ID = ACC.INCIDENT_CYCLE_STEPS_ID
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.INCIDENT_CYCLE_STEPS_ID
, B.INCIDENT_STATUS_ID
, B.INCIDENT_TYPE_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
FROM CS_INCIDENT_CYCLE_STEPS B
, JTM_CS_INCI_CYCLE_STEPS_ACC ACC
WHERE B.INCIDENT_CYCLE_STEPS_ID = ACC.INCIDENT_CYCLE_STEPS_ID