1. Tables and Views for SCM
  2. ACN_REQ_VERSION_VL

ACN_REQ_VERSION_VL

Details

  • Schema: FUSION

  • Object owner: ACN

  • Object type: VIEW

Columns

Name

REQUIREMENT_VERSION_ID

OBJECT_VERSION_NUMBER

REQUIREMENT_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

VERSION_NUMBER

STATUS

PRODUCT

TOTAL_ESTIMATES

STRUCTURE_UPDATE_DATE

DESCRIPTION

Query

SQL_Statement

SELECT

ACN_REQ_VERSION_B.REQUIREMENT_VERSION_ID REQUIREMENT_VERSION_ID,

ACN_REQ_VERSION_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ACN_REQ_VERSION_B.REQUIREMENT_ID REQUIREMENT_ID,

ACN_REQ_VERSION_B.CREATED_BY CREATED_BY,

ACN_REQ_VERSION_B.CREATION_DATE CREATION_DATE,

ACN_REQ_VERSION_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ACN_REQ_VERSION_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ACN_REQ_VERSION_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ACN_REQ_VERSION_B.VERSION_NUMBER VERSION_NUMBER,

ACN_REQ_VERSION_B.STATUS STATUS,

ACN_REQ_VERSION_B.PRODUCT PRODUCT,

ACN_REQ_VERSION_B.TOTAL_ESTIMATES TOTAL_ESTIMATES,

ACN_REQ_VERSION_B.STRUCTURE_UPDATE_DATE,

ACN_REQ_VERSION_TL.DESCRIPTION DESCRIPTION

FROM

ACN_REQ_VERSION_B,

ACN_REQ_VERSION_TL

WHERE

ACN_REQ_VERSION_B.REQUIREMENT_VERSION_ID = ACN_REQ_VERSION_TL.REQUIREMENT_VERSION_ID AND ACN_REQ_VERSION_TL.LANGUAGE = USERENV('LANG')