[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 |