View: OEFV_ACTIONS

View Text

SELECT ACTION.NAME
, LOOKUP.MEANING /* ACTION_LEVEL = RESULT_TABLE */
, LOOKUP2.MEANING /* ACTION_APPROVAL */
, ACTION.DESCRIPTION
, '_DF:OE:SO_ACTIONS:ACTION'
, RESULT.NAME
, ACTION.ACTION_ID
, ACTION.PASSING_RESULT_ID
, ACTION.LAST_UPDATE_DATE
, ACTION.LAST_UPDATED_BY
, ACTION.CREATION_DATE
, ACTION.CREATED_BY
FROM SO_ACTIONS ACTION
, SO_RESULTS RESULT
, SO_LOOKUPS LOOKUP
, FND_LOOKUPS LOOKUP2
WHERE ACTION.PASSING_RESULT_ID = RESULT.RESULT_ID(+)
AND LOOKUP.LOOKUP_TYPE = 'SO_ACTION_LEVEL'
AND LOOKUP.LOOKUP_CODE = ACTION.RESULT_TABLE
AND LOOKUP2.LOOKUP_TYPE = 'YES_NO'
AND LOOKUP2.LOOKUP_CODE = ACTION.ACTION_APPROVAL WITH READ ONLY

Columns