[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 |