FND Design Data [Home] [Help]

View: SO_CYCLE_ACTION_NAMES_V

Product: OE - Order Entry
Description:
Implementation/DBA Data: ViewAPPS.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