VIEW: PA.PA_OBJECT_RELATIONSHIPS#

Source

View Text - Preformatted

select OBJECT_RELATIONSHIP_ID OBJECT_RELATIONSHIP_ID, OBJECT_TYPE_FROM OBJECT_TYPE_FROM, OBJECT_ID_FROM1 OBJECT_ID_FROM1, OBJECT_TYPE_TO OBJECT_TYPE_TO, OBJECT_ID_TO1 OBJECT_ID_TO1, RELATIONSHIP_TYPE RELATIONSHIP_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_ID_FROM2 OBJECT_ID_FROM2, OBJECT_ID_FROM3 OBJECT_ID_FROM3, OBJECT_ID_FROM4 OBJECT_ID_FROM4, OBJECT_ID_FROM5 OBJECT_ID_FROM5, OBJECT_ID_TO2 OBJECT_ID_TO2, OBJECT_ID_TO3 OBJECT_ID_TO3, OBJECT_ID_TO4 OBJECT_ID_TO4, OBJECT_ID_TO5 OBJECT_ID_TO5, RELATIONSHIP_SUBTYPE RELATIONSHIP_SUBTYPE, LAG_DAY LAG_DAY, IMPORTED_LAG IMPORTED_LAG, PRIORITY PRIORITY, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, PM_PRODUCT_CODE PM_PRODUCT_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WEIGHTING_PERCENTAGE WEIGHTING_PERCENTAGE, COMMENTS COMMENTS, STATUS_CODE STATUS_CODE from "PA"."PA_OBJECT_RELATIONSHIPS"

View Text - HTML Formatted

SELECT OBJECT_RELATIONSHIP_ID OBJECT_RELATIONSHIP_ID
, OBJECT_TYPE_FROM OBJECT_TYPE_FROM
, OBJECT_ID_FROM1 OBJECT_ID_FROM1
, OBJECT_TYPE_TO OBJECT_TYPE_TO
, OBJECT_ID_TO1 OBJECT_ID_TO1
, RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_ID_FROM2 OBJECT_ID_FROM2
, OBJECT_ID_FROM3 OBJECT_ID_FROM3
, OBJECT_ID_FROM4 OBJECT_ID_FROM4
, OBJECT_ID_FROM5 OBJECT_ID_FROM5
, OBJECT_ID_TO2 OBJECT_ID_TO2
, OBJECT_ID_TO3 OBJECT_ID_TO3
, OBJECT_ID_TO4 OBJECT_ID_TO4
, OBJECT_ID_TO5 OBJECT_ID_TO5
, RELATIONSHIP_SUBTYPE RELATIONSHIP_SUBTYPE
, LAG_DAY LAG_DAY
, IMPORTED_LAG IMPORTED_LAG
, PRIORITY PRIORITY
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WEIGHTING_PERCENTAGE WEIGHTING_PERCENTAGE
, COMMENTS COMMENTS
, STATUS_CODE STATUS_CODE
FROM "PA"."PA_OBJECT_RELATIONSHIPS"