Product: | EDR - E-Records |
---|---|
Description: | |
Implementation/DBA Data: | APPS.EDR_INTER_EVENT_TEST_EVENTS_V |
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(+)