PJF_SOV_VERSIONS_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

SOV_VERSION_ID PROJECT_ID VERSION_NUMBER STATUS_CODE CURRENCY_CODE ATTRIBUTE_CATEGORY ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LANGUAGE VERSION_DESCRIPTION SOURCE_LANG

Query

SQL_Statement

select SVB.SOV_VERSION_ID, SVB.PROJECT_ID, SVB.VERSION_NUMBER, SVB.STATUS_CODE, SVB.CURRENCY_CODE, SVB.ATTRIBUTE_CATEGORY, SVB.ATTRIBUTE_NUMBER1, SVB.ATTRIBUTE_NUMBER2, SVB.ATTRIBUTE_NUMBER3, SVB.ATTRIBUTE_NUMBER4, SVB.ATTRIBUTE_NUMBER5, SVB.ATTRIBUTE_NUMBER6, SVB.ATTRIBUTE_NUMBER7, SVB.ATTRIBUTE_NUMBER8, SVB.ATTRIBUTE_NUMBER9, SVB.ATTRIBUTE_NUMBER10, SVB.ATTRIBUTE_CHAR1, SVB.ATTRIBUTE_CHAR2, SVB.ATTRIBUTE_CHAR3, SVB.ATTRIBUTE_CHAR4, SVB.ATTRIBUTE_CHAR5, SVB.ATTRIBUTE_CHAR6, SVB.ATTRIBUTE_CHAR7, SVB.ATTRIBUTE_CHAR8, SVB.ATTRIBUTE_CHAR9, SVB.ATTRIBUTE_CHAR10, SVB.ATTRIBUTE_DATE1, SVB.ATTRIBUTE_DATE2, SVB.ATTRIBUTE_DATE3, SVB.ATTRIBUTE_DATE4, SVB.ATTRIBUTE_DATE5, SVB.OBJECT_VERSION_NUMBER, SVB.CREATED_BY, SVB.CREATION_DATE, SVB.LAST_UPDATED_BY, SVB.LAST_UPDATE_DATE, SVB.LAST_UPDATE_LOGIN, SVTL.LANGUAGE, SVTL.VERSION_DESCRIPTION, SVTL.SOURCE_LANG from pjf_sov_versions_b SVB, pjf_sov_versions_tl SVTL where SVB.SOV_VERSION_ID = SVTL.SOV_VERSION_ID and SVTL.LANGUAGE = userenv('LANG')