EGO_RESPONSE_V

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
RESPONSE_CODE RESPONSE

Query

SQL_Statement
SELECT lookup.lookup_code AS response_code, decode(lookup.lookup_code, 'ASSIGNED','PENDING', 'ACQUIRED','PENDING', 'EGO_DELEGATED','PENDING', 'APPROVED','APPROVED', 'REJECTED','REJECTED') AS response FROM fnd_lookup_values_vl lookup WHERE lookup_type='ORA_EGO_RW_APPROVER_ACTION'