VIEW: APPS.SO_CYCLE_ACTION_NAMES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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