VIEW: APPS.IGS_PE_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT PR.ROWID ROW_ID, PR.RELATIONSHIP_ID PARTY_RELATIONSHIP_ID, PR.PARTY_ID PARTY_ID, PR.SUBJECT_ID SUBJECT_ID, PR.OBJECT_ID OBJECT_ID, P.PARTY_NUMBER OBJECT_ID_NUMBER, P.PARTY_TYPE OBJECT_ID_TYPE, P.PARTY_NAME NAME, PR.RELATIONSHIP_TYPE PARTY_RELATIONSHIP_TYPE, L1.MEANING PARTY_RELATIONSHIP_TYP_MEANING, PR.RELATIONSHIP_CODE RELATIONSHIP_CODE, PR.DIRECTIONAL_FLAG RECIPROCAL_FLAG, PR.COMMENTS COMMENTS, PR.START_DATE START_DATE, PR.END_DATE END_DATE, PR.CONTENT_SOURCE_TYPE, PR.STATUS STATUS, 'Y' TRUE_ROW, PR.OBJECT_VERSION_NUMBER, PR.CREATED_BY, PR.CREATION_DATE, PR.LAST_UPDATED_BY, PR.LAST_UPDATE_DATE, PR.LAST_UPDATE_LOGIN, PR.ATTRIBUTE_CATEGORY, PR.ATTRIBUTE1, PR.ATTRIBUTE2, PR.ATTRIBUTE3, PR.ATTRIBUTE4, PR.ATTRIBUTE5, PR.ATTRIBUTE6, PR.ATTRIBUTE7, PR.ATTRIBUTE8, PR.ATTRIBUTE9, PR.ATTRIBUTE10, PR.ATTRIBUTE11, PR.ATTRIBUTE12, PR.ATTRIBUTE13, PR.ATTRIBUTE14, PR.ATTRIBUTE15, PR.ATTRIBUTE16, PR.ATTRIBUTE17, PR.ATTRIBUTE18, PR.ATTRIBUTE19, PR.ATTRIBUTE20, PR.GLOBAL_ATTRIBUTE_CATEGORY, PR.GLOBAL_ATTRIBUTE1, PR.GLOBAL_ATTRIBUTE2, PR.GLOBAL_ATTRIBUTE3, PR.GLOBAL_ATTRIBUTE4, PR.GLOBAL_ATTRIBUTE5, PR.GLOBAL_ATTRIBUTE6, PR.GLOBAL_ATTRIBUTE7, PR.GLOBAL_ATTRIBUTE8, PR.GLOBAL_ATTRIBUTE9, PR.GLOBAL_ATTRIBUTE10, PR.GLOBAL_ATTRIBUTE11, PR.GLOBAL_ATTRIBUTE12, PR.GLOBAL_ATTRIBUTE13, PR.GLOBAL_ATTRIBUTE14, PR.GLOBAL_ATTRIBUTE15, PR.GLOBAL_ATTRIBUTE16, PR.GLOBAL_ATTRIBUTE17, PR.GLOBAL_ATTRIBUTE18, PR.GLOBAL_ATTRIBUTE19, PR.GLOBAL_ATTRIBUTE20 FROM HZ_RELATIONSHIPS PR, HZ_PARTIES P, FND_LOOKUP_VALUES L1 WHERE PR.OBJECT_ID =P.PARTY_ID AND PR.RELATIONSHIP_CODE = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE' AND L1.VIEW_APPLICATION_ID = 222 AND L1.LANGUAGE = USERENV('LANG') AND PR.STATUS = 'A' AND L1.SECURITY_GROUP_ID = 0

View Text - HTML Formatted

SELECT PR.ROWID ROW_ID
, PR.RELATIONSHIP_ID PARTY_RELATIONSHIP_ID
, PR.PARTY_ID PARTY_ID
, PR.SUBJECT_ID SUBJECT_ID
, PR.OBJECT_ID OBJECT_ID
, P.PARTY_NUMBER OBJECT_ID_NUMBER
, P.PARTY_TYPE OBJECT_ID_TYPE
, P.PARTY_NAME NAME
, PR.RELATIONSHIP_TYPE PARTY_RELATIONSHIP_TYPE
, L1.MEANING PARTY_RELATIONSHIP_TYP_MEANING
, PR.RELATIONSHIP_CODE RELATIONSHIP_CODE
, PR.DIRECTIONAL_FLAG RECIPROCAL_FLAG
, PR.COMMENTS COMMENTS
, PR.START_DATE START_DATE
, PR.END_DATE END_DATE
, PR.CONTENT_SOURCE_TYPE
, PR.STATUS STATUS
, 'Y' TRUE_ROW
, PR.OBJECT_VERSION_NUMBER
, PR.CREATED_BY
, PR.CREATION_DATE
, PR.LAST_UPDATED_BY
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATE_LOGIN
, PR.ATTRIBUTE_CATEGORY
, PR.ATTRIBUTE1
, PR.ATTRIBUTE2
, PR.ATTRIBUTE3
, PR.ATTRIBUTE4
, PR.ATTRIBUTE5
, PR.ATTRIBUTE6
, PR.ATTRIBUTE7
, PR.ATTRIBUTE8
, PR.ATTRIBUTE9
, PR.ATTRIBUTE10
, PR.ATTRIBUTE11
, PR.ATTRIBUTE12
, PR.ATTRIBUTE13
, PR.ATTRIBUTE14
, PR.ATTRIBUTE15
, PR.ATTRIBUTE16
, PR.ATTRIBUTE17
, PR.ATTRIBUTE18
, PR.ATTRIBUTE19
, PR.ATTRIBUTE20
, PR.GLOBAL_ATTRIBUTE_CATEGORY
, PR.GLOBAL_ATTRIBUTE1
, PR.GLOBAL_ATTRIBUTE2
, PR.GLOBAL_ATTRIBUTE3
, PR.GLOBAL_ATTRIBUTE4
, PR.GLOBAL_ATTRIBUTE5
, PR.GLOBAL_ATTRIBUTE6
, PR.GLOBAL_ATTRIBUTE7
, PR.GLOBAL_ATTRIBUTE8
, PR.GLOBAL_ATTRIBUTE9
, PR.GLOBAL_ATTRIBUTE10
, PR.GLOBAL_ATTRIBUTE11
, PR.GLOBAL_ATTRIBUTE12
, PR.GLOBAL_ATTRIBUTE13
, PR.GLOBAL_ATTRIBUTE14
, PR.GLOBAL_ATTRIBUTE15
, PR.GLOBAL_ATTRIBUTE16
, PR.GLOBAL_ATTRIBUTE17
, PR.GLOBAL_ATTRIBUTE18
, PR.GLOBAL_ATTRIBUTE19
, PR.GLOBAL_ATTRIBUTE20
FROM HZ_RELATIONSHIPS PR
, HZ_PARTIES P
, FND_LOOKUP_VALUES L1
WHERE PR.OBJECT_ID =P.PARTY_ID
AND PR.RELATIONSHIP_CODE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND L1.VIEW_APPLICATION_ID = 222
AND L1.LANGUAGE = USERENV('LANG')
AND PR.STATUS = 'A'
AND L1.SECURITY_GROUP_ID = 0