View: IGS_PE_PRIVACY_REL_V

Product:	IGS - Student System
Description:	IGS_PE_PRIVACY_REL_V describes the privacy relationships codes
Implementation/DBA Data:	APPS.IGS_PE_PRIVACY_REL_V

View Text

SELECT R.ROWID ROW_ID
, L.MEANING
, R.RELATIONSHIP_CODE
, R.SUBJECT_ID RELATED_FROM_ID
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
FROM FND_LOOKUP_VALUES L
, HZ_RELATIONSHIPS R
WHERE L.LOOKUP_CODE = R.RELATIONSHIP_CODE
AND L.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND L.LANGUAGE = USERENV('LANG')
AND L.VIEW_APPLICATION_ID = 222
AND L.SECURITY_GROUP_ID = 0
AND R.STATUS ='A' UNION ALL SELECT ROWID ROW_ID
, MEANING
, LOOKUP_CODE
, TO_NUMBER(NULL) RELATED_FROM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'PERSON_PRIVACY_RELEASE'
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 8405
AND SECURITY_GROUP_ID = 0

Columns