EGP_PHASES_VL

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
PHASE_SEQ PHASE_CODE PHASE_NAME PHASE_TYPE START_DATE END_DATE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT EGP_PHASES_B.phase_seq, EGP_PHASES_B.phase_code, EGP_PHASES_TL.phase_name, EGP_PHASES_B.phase_type, EGP_PHASES_B.start_date, EGP_PHASES_B.end_date, EGP_PHASES_B.object_version_number, EGP_PHASES_B.created_by, EGP_PHASES_B.creation_date, EGP_PHASES_B.last_updated_by, EGP_PHASES_B.last_update_date, EGP_PHASES_B.last_update_login FROM EGP_PHASES_B, EGP_PHASES_TL WHERE EGP_PHASES_B.phase_code = EGP_PHASES_TL.phase_code AND EGP_PHASES_TL.LANGUAGE = USERENV('LANG')