IRC_DESC_VERSION_LATEST

Details

Schema: FUSION
Object owner: IRC
Object type: VIEW

Columns

Name
DESC_VERSION_ID DESCRIPTION_ID VERSION_START_DATE STATUS_CODE MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESCRIPTION SHORT_DESCRIPTION TXT_DESCRIPTION QUALIFICATIONS RESPONSIBILITIES

Name

DESC_VERSION_ID

DESCRIPTION_ID

VERSION_START_DATE

STATUS_CODE

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DESCRIPTION

SHORT_DESCRIPTION

TXT_DESCRIPTION

QUALIFICATIONS

RESPONSIBILITIES

Query

SQL_Statement
SELECT V.DESC_VERSION_ID DESC_VERSION_ID, V.DESCRIPTION_ID DESCRIPTION_ID, V.VERSION_START_DATE VERSION_START_DATE, V.STATUS_CODE STATUS_CODE, V.MODULE_ID MODULE_ID, V.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, V.CREATED_BY CREATED_BY, V.CREATION_DATE CREATION_DATE, V.LAST_UPDATED_BY LAST_UPDATED_BY, V.LAST_UPDATE_DATE LAST_UPDATE_DATE, V.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, V.DESCRIPTION DESCRIPTION, V.SHORT_DESCRIPTION SHORT_DESCRIPTION, V.TXT_DESCRIPTION TXT_DESCRIPTION, V.QUALIFICATIONS QUALIFICATIONS, V.RESPONSIBILITIES RESPONSIBILITIES FROM IRC_DESC_VERSIONS_VL V WHERE V.DESC_VERSION_ID = ((SELECT DESC_VERSION_ID FROM (SELECT DESC_VERSION_ID, ROW_NUMBER() OVER (PARTITION BY DESCRIPTION_ID ORDER BY VERSION_START_DATE DESC) AS rn FROM IRC_DESC_VERSIONS_VL WHERE DESCRIPTION_ID = V.DESCRIPTION_ID AND STATUS_CODE = 'ORA_ACTIVE' AND NOT VERSION_START_DATE > SYSDATE) orderedVersions WHERE orderedVersions.rn = 1))

SQL_Statement

SELECT

V.DESC_VERSION_ID DESC_VERSION_ID,

V.DESCRIPTION_ID DESCRIPTION_ID,

V.VERSION_START_DATE VERSION_START_DATE,

V.STATUS_CODE STATUS_CODE,

V.MODULE_ID MODULE_ID,

V.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

V.CREATED_BY CREATED_BY,

V.CREATION_DATE CREATION_DATE,

V.LAST_UPDATED_BY LAST_UPDATED_BY,

V.LAST_UPDATE_DATE LAST_UPDATE_DATE,

V.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

V.DESCRIPTION DESCRIPTION,

V.SHORT_DESCRIPTION SHORT_DESCRIPTION,

V.TXT_DESCRIPTION TXT_DESCRIPTION,

V.QUALIFICATIONS QUALIFICATIONS,

V.RESPONSIBILITIES RESPONSIBILITIES

FROM

IRC_DESC_VERSIONS_VL V

WHERE

V.DESC_VERSION_ID = ((SELECT DESC_VERSION_ID FROM (SELECT DESC_VERSION_ID, ROW_NUMBER() OVER (PARTITION BY DESCRIPTION_ID ORDER BY VERSION_START_DATE DESC) AS rn FROM IRC_DESC_VERSIONS_VL

WHERE DESCRIPTION_ID = V.DESCRIPTION_ID AND STATUS_CODE = 'ORA_ACTIVE' AND NOT VERSION_START_DATE > SYSDATE) orderedVersions WHERE orderedVersions.rn = 1))