You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Audit Data for Custom Fields on Service Requests

in Reporting & Analytics for Fusion Service 1 comment

Hi,
we currently have the following query:

SELECT DISTINCT
SR.SR_NUMBER,
CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE,
OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDENTE,
(SELECT MEANING FROM FND_LOOKUP_VALUES_VL WHERE LOOKUP_TYPE = 'ORA_SVC_SR_STATUS_CD' AND LOOKUP_CODE = BI.STATUS_CD) AS STATO_ATTUALE,
(SELECT MEANING FROM FND_LOOKUP_VALUES_VL WHERE LOOKUP_TYPE = 'ORA_SVC_SR_STATUS_CD' AND LOOKUP_CODE = BI.OLD_STATUS_CD) AS STATO_PRECEDENTE,
QUEUE.QUEUE_NAME AS UFFICIO_ATTUALE,
OLD_QUEUE.QUEUE_NAME AS UFFICIO_PRECEDENTE,
TO_CHAR(BI.AUDIT_START_DATE, 'DD/MM/YYYY HH24:MI:SS') AS DATA

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!