VIEW: APPS.IGSFV_ORG_STRUCTURE_NOTES

Source

View Text - Preformatted

SELECT ONT.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER, ONT.ORG_STRUCTURE_TYPE, ONT.ORG_NOTE_SEQUENCE, ONT.ORG_NOTE_TYPE, ONT.START_DATE EFFECTIVE_START_DATE, ONT.END_DATE EFFECTIVE_END_DATE, ONT.NOTE_TEXT NOTES, DECODE(ONT.ORG_STRUCTURE_TYPE,'LOCATION',LOC.DESCRIPTION,HP.PARTY_NAME) ORG_STRUCTURE_NAME, '_LA:ONT.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING' , ONY.NOTE_TYPE_DESCRIPTION ORG_NOTE_TYPE_DESC, ONT.CREATED_BY, ONT.CREATION_DATE, ONT.LAST_UPDATED_BY, ONT.LAST_UPDATE_DATE FROM IGS_OR_ORG_NOTES ONT, IGS_OR_ORG_NOTE_TYPE ONY, HZ_PARTIES HP, IGS_AD_LOCATION_ALL LOC, IGS_PE_HZ_PARTIES IHP WHERE ONT.ORG_STRUCTURE_ID =IHP.OSS_ORG_UNIT_CD(+) AND IHP.PARTY_ID = HP.PARTY_ID(+) AND ONT.ORG_STRUCTURE_ID = LOC.LOCATION_CD(+) AND ONT.ORG_NOTE_TYPE = ONY.ORG_NOTES_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT ONT.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER
, ONT.ORG_STRUCTURE_TYPE
, ONT.ORG_NOTE_SEQUENCE
, ONT.ORG_NOTE_TYPE
, ONT.START_DATE EFFECTIVE_START_DATE
, ONT.END_DATE EFFECTIVE_END_DATE
, ONT.NOTE_TEXT NOTES
, DECODE(ONT.ORG_STRUCTURE_TYPE
, 'LOCATION'
, LOC.DESCRIPTION
, HP.PARTY_NAME) ORG_STRUCTURE_NAME
, '_LA:ONT.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING'
, ONY.NOTE_TYPE_DESCRIPTION ORG_NOTE_TYPE_DESC
, ONT.CREATED_BY
, ONT.CREATION_DATE
, ONT.LAST_UPDATED_BY
, ONT.LAST_UPDATE_DATE
FROM IGS_OR_ORG_NOTES ONT
, IGS_OR_ORG_NOTE_TYPE ONY
, HZ_PARTIES HP
, IGS_AD_LOCATION_ALL LOC
, IGS_PE_HZ_PARTIES IHP
WHERE ONT.ORG_STRUCTURE_ID =IHP.OSS_ORG_UNIT_CD(+)
AND IHP.PARTY_ID = HP.PARTY_ID(+)
AND ONT.ORG_STRUCTURE_ID = LOC.LOCATION_CD(+)
AND ONT.ORG_NOTE_TYPE = ONY.ORG_NOTES_TYPE WITH READ ONLY