View: FND_CONC_REQ_OUTPUTS_V

Product:	FND - Application Object Library
Description:	FND_CONC_REQ_OUTPUTS_V
Implementation/DBA Data:	APPS.FND_CONC_REQ_OUTPUTS_V

View Text

SELECT R.REQUEST_ID
, R.PHASE_CODE
, R.STATUS_CODE
, A.ACTION_TYPE ACTION_TYPE
, DECODE(NVL(A.ACTION_TYPE
, 0)
, 6
, O.FILE_NODE_NAME
, R.OUTFILE_NODE_NAME)
, DECODE(NVL(A.ACTION_TYPE
, 0)
, 6
, O.FILE_NAME
, R.OUTFILE_NAME)
, DECODE(NVL(A.ACTION_TYPE
, 0)
, 6
, O.FILE_SIZE
, R.OFILE_SIZE)
, DECODE(NVL(A.ACTION_TYPE
, 0)
, 6
, O.FILE_TYPE
, R.OUTPUT_FILE_TYPE)
, DECODE(NVL(A.ACTION_TYPE
, 0)
, 6
, O.FILE_CREATION_DATE
, R.ACTUAL_COMPLETION_DATE)
, R.SAVE_OUTPUT_FLAG
FROM FND_CONCURRENT_REQUESTS R
, FND_CONC_PP_ACTIONS A
, FND_CONC_REQ_OUTPUTS O
WHERE R.REQUEST_ID = A.CONCURRENT_REQUEST_ID (+)
AND A.ACTION_TYPE(+) = 6
AND A.CONCURRENT_REQUEST_ID = O.CONCURRENT_REQUEST_ID (+)
AND A.ACTION_TYPE= O.ACTION_TYPE (+)

Columns