View: FND_SVC_COMP_REQUESTS_V

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

View Text

SELECT CR.COMPONENT_ID
, CR.COMPONENT_REQUEST_ID
, CR.CREATED_BY
, CR.EVENT_DATE
, EV.DISPLAY_NAME EVENT_DISPLAY_NAME
, CR.EVENT_FREQUENCY
, CR.EVENT_NAME
, CR.EVENT_PARAMS
, WAJ.FAILURES
, WAJ.INTERVAL
, CR.JOB_ID
, WAJ.LAST_DATE
, WAJ.NEXT_DATE
, CR.OBJECT_VERSION_NUMBER
, CR.REQUESTED_BY_USER
, WAJ.THIS_DATE
, WAJ.WHAT
FROM FND_SVC_COMP_REQUESTS CR
, WF_EVENTS_VL EV
, WF_ALL_JOBS WAJ
WHERE CR.EVENT_NAME = EV.NAME
AND CR.JOB_ID = WAJ.JOB

Columns