VCS_RELATIONSHIPS_VL

Details

• Schema: FUSION

• Object owner: VCS

• Object type: VIEW

Columns

Name
RELATIONSHIP_ID RELATIONSHIP_NUMBER START_DATE END_DATE TO_NODE_ID FROM_NODE_ID ITEM_ID ITEM_ORG_ID RELATIONSHIP_TYPE_CODE DROP_SHIP_FLAG SOURCE_SYSTEM_CODE NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.RELATIONSHIP_ID, B.RELATIONSHIP_NUMBER, B.START_DATE, B.END_DATE, B.TO_NODE_ID, B.FROM_NODE_ID, B.ITEM_ID, B.ITEM_ORG_ID, B.RELATIONSHIP_TYPE_CODE, B.DROP_SHIP_FLAG, B.SOURCE_SYSTEM_CODE, T.NAME, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM VCS_RELATIONSHIPS_B B LEFT OUTER JOIN VCS_RELATIONSHIPS_TL T ON B.RELATIONSHIP_ID = T.RELATIONSHIP_ID AND T.LANGUAGE = USERENV('LANG')