Concurrent program running between particular date and their incompatible programs

SELECT distinct FU.USER_NAME,
papf.full_name,
FCR.REQUEST_ID,
FCR.ACTUAL_START_DATE,
FCR.ACTUAL_COMPLETION_DATE,
round( ((FCR.ACTUAL_COMPLETION_DATE-FCR.ACTUAL_START_DATE)*24*60),2 )RUN_TIME_Mins,
FCR.IS_SUB_REQUEST,
fcr.parent_request_id,
FCR.HAS_SUB_REQUEST,
FCPT.USER_CONCURRENT_PROGRAM_NAME,
B.USER_CONCURRENT_QUEUE_NAME MANAGER,
FCPT2.USER_CONCURRENT_PROGRAM_NAME INCOMPATIBLE_TO,
fcs.incompatibility_type
FROM APPS.FND_CONCURRENT_REQUESTS FCR,
APPS.FND_USER FU,
APPS.PER_ALL_PEOPLE_F PAPF,
APPS.FND_CONCURRENT_PROCESSES a,
APPS.FND_CONCURRENT_QUEUES_VL B,

APPS.FND_CONCURRENT_PROGRAMS_TL FCPT,
APPS.FND_CONCURRENT_PROGRAMS_TL FCPT2,
APPS.FND_CONCURRENT_PROGRAM_SERIAL FCS
where FCR.ACTUAL_START_DATE >=:P_START_DATE
AND fcr.ACTUAL_COMPLETION_DATE <=:p_completion_date
AND FCR.REQUESTED_BY =FU.USER_ID
AND FU.USER_ID =PAPF.PERSON_ID
and FCR.REQUESTED_BY =PAPF.PERSON_ID
and a.CONCURRENT_QUEUE_ID = B.CONCURRENT_QUEUE_ID
and a.CONCURRENT_PROCESS_ID = FCR.CONTROLLING_MANAGER
and FCPT.CONCURRENT_PROGRAM_ID =FCR.CONCURRENT_PROGRAM_ID
and FCS.RUNNING_CONCURRENT_PROGRAM_ID=FCPT.CONCURRENT_PROGRAM_ID
and FCS.TO_RUN_CONCURRENT_PROGRAM_ID=FCPT2.CONCURRENT_PROGRAM_ID
and FCPT.LANGUAGE=’US’
and fcpt2.language=’US’
AND fcr.REQUEST_ID = FCR.REQUEST_ID

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s