SVC_BI_OBJECT_LINKS_V

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
BI_LINK_ID LINK_ID LINK_OBJ_VER_NUM LINK_TYPE_ID LINK_TYPE_OBJ_VER_NUM LINK_TYPE_CD SOURCE_OBJECT_REFERENCE SOURCE_OBJECT_TYPE_CD SOURCE_OBJECT_ID TARGET_OBJECT_REFERENCE TARGET_OBJECT_TYPE_CD TARGET_OBJECT_ID

Query

SQL_Statement

select ol.link_id bi_link_id, ol.link_id, ol.object_version_number link_obj_ver_num, olt.link_type_id, olt.object_version_number link_type_obj_ver_num, olt.outward_cd link_type_cd, ol.source_object_reference, ol.source_object_type_cd, ol.source_object_id, ol.target_object_reference, ol.target_object_type_cd, ol.target_object_id from svc_object_links ol, svc_object_link_types olt where ol.link_type_number = olt.link_type_number union all select 0-ol.link_id bi_link_id, ol.link_id, ol.object_version_number, olt.link_type_id, olt.object_version_number, olt.inward_cd, ol.target_object_reference, ol.target_object_type_cd, ol.target_object_id, ol.source_object_reference, ol.source_object_type_cd, ol.source_object_id from svc_object_links ol, svc_object_link_types olt where ol.link_type_number = olt.link_type_number