MSC_PLAN_ARCHIVE_VERSIONS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID ARCHIVE_ID ARCHIVE_TYPE LAST_UPDATE_DATE ARCHIVE_NAME

Query

SQL_Statement
select mpv.plan_id , mpv.archive_id , mpv.archive_type, mpv.last_update_date, decode (mpv.archive_name , null ,mpd.compile_designator , mpv.archive_name ) || ' - ' ||mpv.archive_version || ' - '|| to_char (mpv.creation_date, 'yyyy/mm/dd') archive_name from msc_plan_archive_versions mpv , msc_plan_definitions mpd where mpv.plan_id = mpd.plan_id and mpv.is_valid =0