[Home] [Help]
View: SO_CYCLE_ACTION_NAMES_V
View Text
SELECT CA.CYCLE_ACTION_ID
, CA.CYCLE_ID
, A.ACTION_ID
, A.NAME ACTION_NAME
, A.RESULT_COLUMN
, A.RESULT_TABLE
, A.ACTION_APPROVAL
, DECODE(A.RESULT_TABLE
, 'SO_LINES'
, '*'
, NULL) LINE_ACTION
FROM SO_ACTIONS A
, SO_CYCLE_ACTIONS CA
WHERE A.ACTION_ID = CA.ACTION_ID
Columns
| Name |
| CYCLE_ACTION_ID |
| CYCLE_ID |
| ACTION_ID |
| ACTION_NAME |
| RESULT_COLUMN |
| RESULT_TABLE |
| ACTION_APPROVAL |
| LINE_ACTION |