VCS_DOCUMENT_DEFINITIONS_VL

Details

• Schema: FUSION

• Object owner: VCS

• Object type: VIEW

Columns

Name
DOCUMENT_ID DOCUMENT_TYPE_CODE STATUS_CODE COLLAB_OBJECT_CODE CUSTOMER_LVL_CODE ORGANIZATION_LVL_CODE ITEM_LVL_CODE ITEM_RESOLUTION_CODE ITEM_HIERARCHY_ID ITEM_HIERARCHY_LVL NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.DOCUMENT_ID, B.DOCUMENT_TYPE_CODE, B.STATUS_CODE, B.COLLAB_OBJECT_CODE, B.CUSTOMER_LVL_CODE, B.ORGANIZATION_LVL_CODE, B.ITEM_LVL_CODE, B.ITEM_RESOLUTION_CODE, B.ITEM_HIERARCHY_ID, B.ITEM_HIERARCHY_LVL, T.NAME, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM VCS_DOCUMENT_DEFINITIONS_B B INNER JOIN VCS_DOCUMENT_DEFINITIONS_TL T ON B.DOCUMENT_ID = T.DOCUMENT_ID AND T.LANGUAGE = USERENV('LANG')