VIEW: APPS.IGSFV_PRIVACY_DETAILS

Source

View Text - Preformatted

SELECT PPL.DATA_GROUP, PPL.LVL, '_LA:PPL.ACTION:IGS_LOOKUP_VALUES:PERSON_PRIVACY_ACTION:MEANING', '_LA:PPL.WHOM:IGS_LOOKUP_VALUES:PARTY_RELATIONS_TYPE:MEANING', PPL.START_DATE, PPL.END_DATE, GEN.NOTE_TEXT, PDG.DESCRIPTION, HZP.PARTY_NUMBER, PPL.PRIVACY_LEVEL_ID, PPL.PERSON_ID, PPL.DATA_GROUP_ID, PPL.REF_NOTES_ID, PPL.CREATION_DATE, PPL.CREATED_BY, PPL.LAST_UPDATED_BY, PPL.LAST_UPDATE_DATE FROM IGS_PE_PRIV_LEVEL PPL, HZ_PARTIES HZP, IGS_PE_DATA_GROUPS_ALL PDG, IGS_GE_NOTE GEN WHERE PPL.PERSON_ID=HZP.PARTY_ID AND PPL.DATA_GROUP_ID=PDG.DATA_GROUP_ID AND GEN.REFERENCE_NUMBER(+)=PPL.REF_NOTES_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PPL.DATA_GROUP
, PPL.LVL
, '_LA:PPL.ACTION:IGS_LOOKUP_VALUES:PERSON_PRIVACY_ACTION:MEANING'
, '_LA:PPL.WHOM:IGS_LOOKUP_VALUES:PARTY_RELATIONS_TYPE:MEANING'
, PPL.START_DATE
, PPL.END_DATE
, GEN.NOTE_TEXT
, PDG.DESCRIPTION
, HZP.PARTY_NUMBER
, PPL.PRIVACY_LEVEL_ID
, PPL.PERSON_ID
, PPL.DATA_GROUP_ID
, PPL.REF_NOTES_ID
, PPL.CREATION_DATE
, PPL.CREATED_BY
, PPL.LAST_UPDATED_BY
, PPL.LAST_UPDATE_DATE
FROM IGS_PE_PRIV_LEVEL PPL
, HZ_PARTIES HZP
, IGS_PE_DATA_GROUPS_ALL PDG
, IGS_GE_NOTE GEN
WHERE PPL.PERSON_ID=HZP.PARTY_ID
AND PPL.DATA_GROUP_ID=PDG.DATA_GROUP_ID
AND GEN.REFERENCE_NUMBER(+)=PPL.REF_NOTES_ID WITH READ ONLY