ECC Service, Service Notes

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: cs-srnote
Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
select * from (select /*+ leading(srd.PROF srd.inc ) cardinality(srd.inc 1000) */  ECC_SPEC_ID,  SOURCE_TYPE, SOURCE_ID, SOURCE_NUMBER, INCIDENT_ID,
			    JTF_NOTE_ID, NOTES, NOTE_TYPE, NOTE_TYPE_MEANING, NOTE_STATUS, NOTE_STATUS_MEANING,last_update_Date,
          note_language, incident_type_id, incident_owner_id, owner_group_id FROM
			    CS_ECC_NOTES_DETAILS_V cd where note_language in ('US'))
			    PIVOT (
			    MAX(SOURCE_TYPE) AS SOURCE_TYPE,
			    MAX(NOTES) AS NOTES,
			    MAX(NOTE_TYPE_MEANING) AS NOTE_TYPE_MEANING,
			    MAX(NOTE_STATUS_MEANING) AS NOTE_STATUS_MEANING
			    for NOTE_LANGUAGE in ('US' "US"))
) x
where
2=2