Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_PE_RELATIONSHIPS_V |
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