VIEW: APPS.IGS_PE_PRIV_LEVEL_V

Source

View Text - Preformatted

SELECT PL.ROWID ROW_ID, PL.PRIVACY_LEVEL_ID, PL.PERSON_ID, PE.PERSON_NUMBER, PL.DATA_GROUP_ID, DG.DATA_GROUP, DG.LVL, PL.ACTION, LK1.MEANING ACTION_MEANING, PL.WHOM, LK2.MEANING WHOM_MEANING, PL.REF_NOTES_ID, PL.START_DATE, PL.END_DATE, PL.CREATED_BY, PL.CREATION_DATE, PL.LAST_UPDATED_BY, PL.LAST_UPDATE_DATE, PL.LAST_UPDATE_LOGIN FROM IGS_PE_PRIV_LEVEL PL, IGS_PE_DATA_GROUPS DG, IGS_LOOKUP_VALUES LK1, FND_LOOKUP_VALUES LK2, IGS_PE_PERSON_BASE_V PE WHERE PL.DATA_GROUP_ID = DG.DATA_GROUP_ID AND PL.PERSON_ID=PE.PERSON_ID AND PL.ACTION = LK1.LOOKUP_CODE AND LK1.LOOKUP_TYPE = 'PERSON_PRIVACY_ACTION' AND PL.WHOM = LK2.LOOKUP_CODE AND LK2.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE' AND LK2.LANGUAGE= USERENV ('LANG') AND LK2.VIEW_APPLICATION_ID = 222 AND LK2.SECURITY_GROUP_ID = 0 UNION ALL SELECT PL.ROWID ROW_ID, PL.PRIVACY_LEVEL_ID, PL.PERSON_ID, PE.PERSON_NUMBER, PL.DATA_GROUP_ID, DG.DATA_GROUP, DG.LVL, PL.ACTION, LK1.MEANING ACTION_MEANING, PL.WHOM, LK2.MEANING WHOM_MEANING, PL.REF_NOTES_ID, PL.START_DATE, PL.END_DATE, PL.CREATED_BY, PL.CREATION_DATE, PL.LAST_UPDATED_BY, PL.LAST_UPDATE_DATE, PL.LAST_UPDATE_LOGIN FROM IGS_PE_PRIV_LEVEL PL, IGS_PE_DATA_GROUPS DG, IGS_LOOKUP_VALUES LK1, FND_LOOKUP_VALUES LK2, IGS_PE_PERSON_BASE_V PE WHERE PL.DATA_GROUP_ID = DG.DATA_GROUP_ID AND PL.PERSON_ID= PE.PERSON_ID AND PL.ACTION = LK1.LOOKUP_CODE AND LK1.LOOKUP_TYPE = 'PERSON_PRIVACY_ACTION' AND PL.WHOM = LK2.LOOKUP_CODE AND LK2.LOOKUP_TYPE = 'PERSON_PRIVACY_RELEASE' AND LK2.LANGUAGE= USERENV ('LANG') AND LK2.VIEW_APPLICATION_ID = 8405 AND LK2.SECURITY_GROUP_ID = 0

View Text - HTML Formatted

SELECT PL.ROWID ROW_ID
, PL.PRIVACY_LEVEL_ID
, PL.PERSON_ID
, PE.PERSON_NUMBER
, PL.DATA_GROUP_ID
, DG.DATA_GROUP
, DG.LVL
, PL.ACTION
, LK1.MEANING ACTION_MEANING
, PL.WHOM
, LK2.MEANING WHOM_MEANING
, PL.REF_NOTES_ID
, PL.START_DATE
, PL.END_DATE
, PL.CREATED_BY
, PL.CREATION_DATE
, PL.LAST_UPDATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATE_LOGIN
FROM IGS_PE_PRIV_LEVEL PL
, IGS_PE_DATA_GROUPS DG
, IGS_LOOKUP_VALUES LK1
, FND_LOOKUP_VALUES LK2
, IGS_PE_PERSON_BASE_V PE
WHERE PL.DATA_GROUP_ID = DG.DATA_GROUP_ID
AND PL.PERSON_ID=PE.PERSON_ID
AND PL.ACTION = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'PERSON_PRIVACY_ACTION'
AND PL.WHOM = LK2.LOOKUP_CODE
AND LK2.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND LK2.LANGUAGE= USERENV ('LANG')
AND LK2.VIEW_APPLICATION_ID = 222
AND LK2.SECURITY_GROUP_ID = 0 UNION ALL SELECT PL.ROWID ROW_ID
, PL.PRIVACY_LEVEL_ID
, PL.PERSON_ID
, PE.PERSON_NUMBER
, PL.DATA_GROUP_ID
, DG.DATA_GROUP
, DG.LVL
, PL.ACTION
, LK1.MEANING ACTION_MEANING
, PL.WHOM
, LK2.MEANING WHOM_MEANING
, PL.REF_NOTES_ID
, PL.START_DATE
, PL.END_DATE
, PL.CREATED_BY
, PL.CREATION_DATE
, PL.LAST_UPDATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATE_LOGIN
FROM IGS_PE_PRIV_LEVEL PL
, IGS_PE_DATA_GROUPS DG
, IGS_LOOKUP_VALUES LK1
, FND_LOOKUP_VALUES LK2
, IGS_PE_PERSON_BASE_V PE
WHERE PL.DATA_GROUP_ID = DG.DATA_GROUP_ID
AND PL.PERSON_ID= PE.PERSON_ID
AND PL.ACTION = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'PERSON_PRIVACY_ACTION'
AND PL.WHOM = LK2.LOOKUP_CODE
AND LK2.LOOKUP_TYPE = 'PERSON_PRIVACY_RELEASE'
AND LK2.LANGUAGE= USERENV ('LANG')
AND LK2.VIEW_APPLICATION_ID = 8405
AND LK2.SECURITY_GROUP_ID = 0