Scheduled Request Query

SELECT DISTINCT FU.USER_NAME,
  --FU.DESCRIPTION,
  FRL.RESPONSIBILITY_NAME,
  FCR.REQUEST_ID,
  FCS.PROGRAM,
  FCPT.USER_CONCURRENT_PROGRAM_NAME,
  FCP.CONCURRENT_PROGRAM_NAME,
  FCS.ARGUMENT_TEXT,
  FCR.PHASE_CODE,
  (SELECT FL.MEANING
  FROM APPS.FND_LOOKUPS FL
  WHERE LOOKUP_TYPE='CP_PHASE_CODE'
  AND LOOKUP_CODE  =FCR.PHASE_CODE
  ) PHASE,
  FCR.STATUS_CODE,
  (SELECT MEANING
  FROM APPS.FND_LOOKUPS
  WHERE LOOKUP_TYPE='CP_STATUS_CODE'
  AND LOOKUP_CODE  =FCR.STATUS_CODE
  ) STATUS,
  FCR.REQUEST_DATE,
  FCR.REQUESTED_START_DATE,
  TO_DATE(FCR.REQUESTED_START_DATE,'DD-MM-RRRR HH24:MI:SS') START_DATE,
  DECODE(FCR.RESUBMIT_INTERVAL,NULL,'-',FCR.RESUBMIT_INTERVAL) RESUBMIT_INTERVAL,
  FCR.RESUBMIT_INTERVAL
  ||' '
  ||FCR.RESUBMIT_INTERVAL_UNIT_CODE RESUBMIT_INTERVAL,
  NVL2(FCR.RESUBMIT_INTERVAL,'PERIODICALLY',NVL2(FCR.RELEASE_CLASS_ID, 'ON SPECIFIC DAYS','ONCE')) SCHEDULE_TYPE
FROM FND_CONCURRENT_REQUESTS FCR,
  FND_USER FU,
  FND_CONCURRENT_PROGRAMS_TL FCPT,
  FND_CONCURRENT_PROGRAMS FCP,
  FND_CONC_REQ_SUMMARY_V FCS,
  FND_RESPONSIBILITY_TL FRL
WHERE FCR.REQUESTED_BY         =FU.USER_ID
AND FCR.CONCURRENT_PROGRAM_ID  =FCPT.CONCURRENT_PROGRAM_ID
AND FCPT.CONCURRENT_PROGRAM_ID = FCP.CONCURRENT_PROGRAM_ID
AND FCR.REQUEST_ID             = FCS.REQUEST_ID
AND FCR.RESPONSIBILITY_ID      =FRL.RESPONSIBILITY_ID
AND FU.USER_NAME LIKE 'SYSADMIN'				-- THIS IS TO ENTER THE USER NAME AND THE TO FETCH THE PROGRAMS RUNNED BY HIM
  --AND FCR.REQUESTED_START_DATE    <= SYSDATE 	-- THIS USED TO FETCH RECORDS ACCORDING TO LOGICAL OPERATION OF SYSDATE
  --AND FCR.REQUEST_DATE > :ENTER_DATE 			-- THIS IS USED FOR MANUAL ENTRY OF DATE
AND FCR.PHASE_CODE = 'P'
ORDER BY REQUEST_DATE DESC;
/
select * from FND_USER;