VIEW: APPS.IGS_PE_PRIVACY_REL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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