[Home] [Help]
View: IGS_PE_INTL_DEPD_V
Product: | IGS - Student System (Obsolete) |
Description: | Person Dependent Relationship for International Form |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PR.ROWID ROW_ID
, PR.RELATIONSHIP_ID
, PR.SUBJECT_ID
, PR.RELATIONSHIP_CODE
, L1.MEANING RELATIONSHIP_DESC
, PR.OBJECT_ID
, P.FULL_NAME
, P.BIRTH_DATE
, PR.CREATION_DATE
, PR.CREATED_BY
, PR.LAST_UPDATED_BY
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATE_LOGIN
FROM HZ_RELATIONSHIPS PR
, IGS_PE_PERSON_BASE_V P
, FND_LOOKUP_VALUES_VL L1
WHERE PR.OBJECT_ID = P.PERSON_ID
AND PR.RELATIONSHIP_CODE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND L1.VIEW_APPLICATION_ID = 222
AND L1.LOOKUP_CODE IN ('SPOUSE_OF'
, 'PARENT_OF')
AND PR.STATUS = 'A'
Columns
Name |
ROW_ID |
RELATIONSHIP_ID |
SUBJECT_ID |
RELATIONSHIP_CODE |
RELATIONSHIP_DESC |
OBJECT_ID |
FULL_NAME |
BIRTH_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |