VIEW: AR.HZ_RELATIONSHIPS#

Source

View Text - Preformatted

select RELATIONSHIP_ID RELATIONSHIP_ID, SUBJECT_ID SUBJECT_ID, SUBJECT_TYPE SUBJECT_TYPE, SUBJECT_TABLE_NAME SUBJECT_TABLE_NAME, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_TABLE_NAME OBJECT_TABLE_NAME, PARTY_ID PARTY_ID, RELATIONSHIP_CODE RELATIONSHIP_CODE, DIRECTIONAL_FLAG DIRECTIONAL_FLAG, COMMENTS COMMENTS, START_DATE START_DATE, END_DATE END_DATE, STATUS STATUS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WH_UPDATE_DATE WH_UPDATE_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE, RELATIONSHIP_TYPE RELATIONSHIP_TYPE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY_MODULE CREATED_BY_MODULE, APPLICATION_ID APPLICATION_ID, ADDITIONAL_INFORMATION1 ADDITIONAL_INFORMATION1, ADDITIONAL_INFORMATION2 ADDITIONAL_INFORMATION2, ADDITIONAL_INFORMATION3 ADDITIONAL_INFORMATION3, ADDITIONAL_INFORMATION4 ADDITIONAL_INFORMATION4, ADDITIONAL_INFORMATION5 ADDITIONAL_INFORMATION5, ADDITIONAL_INFORMATION6 ADDITIONAL_INFORMATION6, ADDITIONAL_INFORMATION7 ADDITIONAL_INFORMATION7, ADDITIONAL_INFORMATION8 ADDITIONAL_INFORMATION8, ADDITIONAL_INFORMATION9 ADDITIONAL_INFORMATION9, ADDITIONAL_INFORMATION10 ADDITIONAL_INFORMATION10, ADDITIONAL_INFORMATION11 ADDITIONAL_INFORMATION11, ADDITIONAL_INFORMATION12 ADDITIONAL_INFORMATION12, ADDITIONAL_INFORMATION13 ADDITIONAL_INFORMATION13, ADDITIONAL_INFORMATION14 ADDITIONAL_INFORMATION14, ADDITIONAL_INFORMATION15 ADDITIONAL_INFORMATION15, ADDITIONAL_INFORMATION16 ADDITIONAL_INFORMATION16, ADDITIONAL_INFORMATION17 ADDITIONAL_INFORMATION17, ADDITIONAL_INFORMATION18 ADDITIONAL_INFORMATION18, ADDITIONAL_INFORMATION19 ADDITIONAL_INFORMATION19, ADDITIONAL_INFORMATION20 ADDITIONAL_INFORMATION20, ADDITIONAL_INFORMATION21 ADDITIONAL_INFORMATION21, ADDITIONAL_INFORMATION22 ADDITIONAL_INFORMATION22, ADDITIONAL_INFORMATION23 ADDITIONAL_INFORMATION23, ADDITIONAL_INFORMATION24 ADDITIONAL_INFORMATION24, ADDITIONAL_INFORMATION25 ADDITIONAL_INFORMATION25, ADDITIONAL_INFORMATION26 ADDITIONAL_INFORMATION26, ADDITIONAL_INFORMATION27 ADDITIONAL_INFORMATION27, ADDITIONAL_INFORMATION28 ADDITIONAL_INFORMATION28, ADDITIONAL_INFORMATION29 ADDITIONAL_INFORMATION29, ADDITIONAL_INFORMATION30 ADDITIONAL_INFORMATION30, DIRECTION_CODE DIRECTION_CODE, PERCENTAGE_OWNERSHIP PERCENTAGE_OWNERSHIP, ACTUAL_CONTENT_SOURCE ACTUAL_CONTENT_SOURCE from "AR"."HZ_RELATIONSHIPS"

View Text - HTML Formatted

SELECT RELATIONSHIP_ID RELATIONSHIP_ID
, SUBJECT_ID SUBJECT_ID
, SUBJECT_TYPE SUBJECT_TYPE
, SUBJECT_TABLE_NAME SUBJECT_TABLE_NAME
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_TABLE_NAME OBJECT_TABLE_NAME
, PARTY_ID PARTY_ID
, RELATIONSHIP_CODE RELATIONSHIP_CODE
, DIRECTIONAL_FLAG DIRECTIONAL_FLAG
, COMMENTS COMMENTS
, START_DATE START_DATE
, END_DATE END_DATE
, STATUS STATUS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WH_UPDATE_DATE WH_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE
, RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE CREATED_BY_MODULE
, APPLICATION_ID APPLICATION_ID
, ADDITIONAL_INFORMATION1 ADDITIONAL_INFORMATION1
, ADDITIONAL_INFORMATION2 ADDITIONAL_INFORMATION2
, ADDITIONAL_INFORMATION3 ADDITIONAL_INFORMATION3
, ADDITIONAL_INFORMATION4 ADDITIONAL_INFORMATION4
, ADDITIONAL_INFORMATION5 ADDITIONAL_INFORMATION5
, ADDITIONAL_INFORMATION6 ADDITIONAL_INFORMATION6
, ADDITIONAL_INFORMATION7 ADDITIONAL_INFORMATION7
, ADDITIONAL_INFORMATION8 ADDITIONAL_INFORMATION8
, ADDITIONAL_INFORMATION9 ADDITIONAL_INFORMATION9
, ADDITIONAL_INFORMATION10 ADDITIONAL_INFORMATION10
, ADDITIONAL_INFORMATION11 ADDITIONAL_INFORMATION11
, ADDITIONAL_INFORMATION12 ADDITIONAL_INFORMATION12
, ADDITIONAL_INFORMATION13 ADDITIONAL_INFORMATION13
, ADDITIONAL_INFORMATION14 ADDITIONAL_INFORMATION14
, ADDITIONAL_INFORMATION15 ADDITIONAL_INFORMATION15
, ADDITIONAL_INFORMATION16 ADDITIONAL_INFORMATION16
, ADDITIONAL_INFORMATION17 ADDITIONAL_INFORMATION17
, ADDITIONAL_INFORMATION18 ADDITIONAL_INFORMATION18
, ADDITIONAL_INFORMATION19 ADDITIONAL_INFORMATION19
, ADDITIONAL_INFORMATION20 ADDITIONAL_INFORMATION20
, ADDITIONAL_INFORMATION21 ADDITIONAL_INFORMATION21
, ADDITIONAL_INFORMATION22 ADDITIONAL_INFORMATION22
, ADDITIONAL_INFORMATION23 ADDITIONAL_INFORMATION23
, ADDITIONAL_INFORMATION24 ADDITIONAL_INFORMATION24
, ADDITIONAL_INFORMATION25 ADDITIONAL_INFORMATION25
, ADDITIONAL_INFORMATION26 ADDITIONAL_INFORMATION26
, ADDITIONAL_INFORMATION27 ADDITIONAL_INFORMATION27
, ADDITIONAL_INFORMATION28 ADDITIONAL_INFORMATION28
, ADDITIONAL_INFORMATION29 ADDITIONAL_INFORMATION29
, ADDITIONAL_INFORMATION30 ADDITIONAL_INFORMATION30
, DIRECTION_CODE DIRECTION_CODE
, PERCENTAGE_OWNERSHIP PERCENTAGE_OWNERSHIP
, ACTUAL_CONTENT_SOURCE ACTUAL_CONTENT_SOURCE
FROM "AR"."HZ_RELATIONSHIPS"