[Home] [Help]
View: OEFV_ACTION_RESULTS
Product: | OE - Order Entry |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ACT_RESULT.ACTION_ID
, ACT_RESULT.RESULT_ID
, ACTION.NAME
, RESULT.NAME
, '_DF:OE:SO_ACTION_RESULTS:ACT_RESULT'
, ACT_RESULT.LAST_UPDATE_DATE
, ACT_RESULT.LAST_UPDATED_BY
, ACT_RESULT.CREATION_DATE
, ACT_RESULT.CREATED_BY
FROM SO_ACTION_RESULTS ACT_RESULT
, SO_ACTIONS ACTION
, SO_RESULTS RESULT
WHERE ACTION.ACTION_ID = ACT_RESULT.ACTION_ID
AND RESULT.RESULT_ID = ACT_RESULT.RESULT_ID WITH READ ONLY
Columns
Name |
ACTION_NAME |
RESULT_NAME |
"_DF" |
ACTION_ID |
RESULT_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |