VIEW: APPS.IGS_PE_INTL_DEPD_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'