VIEW: APPS.IEX_DUNN_ERR_PREV_REQ_IDS_V

Source

View Text - Preformatted

SELECT DUN.REQUEST_ID REQUEST_ID, DECODE(DUN.DUNNING_MODE, 'DRAFT', ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')) DUNNING_MODE, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DUNNING_MODE',DECODE(DUN.DUNNING_MODE, 'DRAFT',(DECODE(DUN.CONFIRMATION_MODE,NULL,'DRAFT','CONFIRMED','FINAL')) ,'FINAL')) CONFIRMATION_MODE, FU.USER_NAME USER_NAME, CON.REQUEST_DATE REQUEST_DATE FROM IEX_DUNNINGS DUN, FND_CONCURRENT_REQUESTS CON, FND_USER FU WHERE DUN.REQUEST_ID=CON.REQUEST_ID AND CON.REQUESTED_BY = FU.USER_ID AND DUN.DUNNING_ID = (SELECT MIN(D.DUNNING_ID) FROM IEX_DUNNINGS D WHERE D.REQUEST_ID = DUN.REQUEST_ID)

View Text - HTML Formatted

SELECT DUN.REQUEST_ID REQUEST_ID
, DECODE(DUN.DUNNING_MODE
, 'DRAFT'
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, 'Y')
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, 'N')) DUNNING_MODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DUNNING_MODE'
, DECODE(DUN.DUNNING_MODE
, 'DRAFT'
, (DECODE(DUN.CONFIRMATION_MODE
, NULL
, 'DRAFT'
, 'CONFIRMED'
, 'FINAL'))
, 'FINAL')) CONFIRMATION_MODE
, FU.USER_NAME USER_NAME
, CON.REQUEST_DATE REQUEST_DATE
FROM IEX_DUNNINGS DUN
, FND_CONCURRENT_REQUESTS CON
, FND_USER FU
WHERE DUN.REQUEST_ID=CON.REQUEST_ID
AND CON.REQUESTED_BY = FU.USER_ID
AND DUN.DUNNING_ID = (SELECT MIN(D.DUNNING_ID)
FROM IEX_DUNNINGS D
WHERE D.REQUEST_ID = DUN.REQUEST_ID)