select status_code,phase_code from fnd_concurrent_requests where request_id=&1;
select fcr.CONCURRENT_PROGRAM_ID,fcp.CONCURRENT_PROGRAM_NAME from
fnd_concurrent_requests fcr , fnd_concurrent_programs fcp
where
1=1
and fcr.CONCURRENT_PROGRAM_ID=fcp.CONCURRENT_PROGRAM_ID
and fcp.CONCURRENT_PROGRAM_NAME like '%OSC%AR%'
select CONCURRENT_PROGRAM_NAME from fnd_concurrent_programs where CONCURRENT_PROGRAM_NAME like '%OSC%AR%H%'
select * from fnd_concurrent_programs_tl where USER_CONCURRENT_PROGRAM_NAME like '%OSC%Dynomax%On%'
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('Q','I')
AND requested_start_date > SYSDATE
AND hold_flag = 'N'
AND CONCURRENT_PROGRAM_ID=90353
select request_id,phase_code , status_code from fnd_concurrent_requests
WHERE status_code IN ('Q','I')
AND requested_start_date > SYSDATE
AND hold_flag = 'N'
AND CONCURRENT_PROGRAM_ID=90353;
No comments:
Post a Comment