VIEW: APPS.EDR_INTER_EVENT_TEST_EVENTS_V

Source

View Text - Preformatted

SELECT testscenarios.TEST_SCENARIO_ID, testscenarios.TEST_SCENARIO, testscenarios.TEST_SCENARIO_INSTANCE, tests.INTER_EVENT_TEST_ID, tests.EVENT_NAME, events.DISPLAY_NAME EVENT_DISPLAY_NAME , tests.EVENT_RAISE_TYPE , tests.EVENT_RAISE_MODE , tests.EVENT_EXECUTION_ORDER , tests.RELATED_EVENT_NAME , relevents.DISPLAY_NAME RELATED_EVENT_DISPLAY_NAME, tests.ATTRIBUTE_CATEGORY, tests.ATTRIBUTE1, tests.ATTRIBUTE2, tests.ATTRIBUTE3, tests.ATTRIBUTE4, tests.ATTRIBUTE5, tests.ATTRIBUTE6, tests.ATTRIBUTE7, tests.ATTRIBUTE8, tests.ATTRIBUTE9, tests.ATTRIBUTE10, tests.ATTRIBUTE11, tests.ATTRIBUTE12, tests.ATTRIBUTE13, tests.ATTRIBUTE14, tests.ATTRIBUTE15, tests.ATTRIBUTE16, tests.ATTRIBUTE17, tests.ATTRIBUTE18, tests.ATTRIBUTE19, tests.ATTRIBUTE20, tests.ATTRIBUTE21, tests.ATTRIBUTE22, tests.ATTRIBUTE23, tests.ATTRIBUTE24, tests.ATTRIBUTE25, tests.ATTRIBUTE26, tests.ATTRIBUTE27, tests.ATTRIBUTE28, tests.ATTRIBUTE29, tests.ATTRIBUTE30 FROM EDR_INTER_EVENT_TEST_SCENARIOS testscenarios, EDR_INTER_EVENT_TEST_EVENTS tests, WF_EVENTS_VL events, WF_EVENTS_VL relevents WHERE testscenarios.TEST_SCENARIO_ID = tests.TEST_SCENARIO_ID AND tests.EVENT_NAME = events.NAME AND tests.RELATED_EVENT_NAME = relevents.NAME(+)

View Text - HTML Formatted

SELECT TESTSCENARIOS.TEST_SCENARIO_ID
, TESTSCENARIOS.TEST_SCENARIO
, TESTSCENARIOS.TEST_SCENARIO_INSTANCE
, TESTS.INTER_EVENT_TEST_ID
, TESTS.EVENT_NAME
, EVENTS.DISPLAY_NAME EVENT_DISPLAY_NAME
, TESTS.EVENT_RAISE_TYPE
, TESTS.EVENT_RAISE_MODE
, TESTS.EVENT_EXECUTION_ORDER
, TESTS.RELATED_EVENT_NAME
, RELEVENTS.DISPLAY_NAME RELATED_EVENT_DISPLAY_NAME
, TESTS.ATTRIBUTE_CATEGORY
, TESTS.ATTRIBUTE1
, TESTS.ATTRIBUTE2
, TESTS.ATTRIBUTE3
, TESTS.ATTRIBUTE4
, TESTS.ATTRIBUTE5
, TESTS.ATTRIBUTE6
, TESTS.ATTRIBUTE7
, TESTS.ATTRIBUTE8
, TESTS.ATTRIBUTE9
, TESTS.ATTRIBUTE10
, TESTS.ATTRIBUTE11
, TESTS.ATTRIBUTE12
, TESTS.ATTRIBUTE13
, TESTS.ATTRIBUTE14
, TESTS.ATTRIBUTE15
, TESTS.ATTRIBUTE16
, TESTS.ATTRIBUTE17
, TESTS.ATTRIBUTE18
, TESTS.ATTRIBUTE19
, TESTS.ATTRIBUTE20
, TESTS.ATTRIBUTE21
, TESTS.ATTRIBUTE22
, TESTS.ATTRIBUTE23
, TESTS.ATTRIBUTE24
, TESTS.ATTRIBUTE25
, TESTS.ATTRIBUTE26
, TESTS.ATTRIBUTE27
, TESTS.ATTRIBUTE28
, TESTS.ATTRIBUTE29
, TESTS.ATTRIBUTE30
FROM EDR_INTER_EVENT_TEST_SCENARIOS TESTSCENARIOS
, EDR_INTER_EVENT_TEST_EVENTS TESTS
, WF_EVENTS_VL EVENTS
, WF_EVENTS_VL RELEVENTS
WHERE TESTSCENARIOS.TEST_SCENARIO_ID = TESTS.TEST_SCENARIO_ID
AND TESTS.EVENT_NAME = EVENTS.NAME
AND TESTS.RELATED_EVENT_NAME = RELEVENTS.NAME(+)