Oracle System Analyst
Search This Blog
Saturday, December 18, 2010
Number of Scheduled process by requestor
Number of Scheduled process by requestor :
requestor
,
count(
*
)
FROM
WHERE
PHASE_CODE
STATUS_CODE
group
=
'P'
AND
IN
(
'I'
,
'Q'
)
by
requestor
order
by
count(
*
)
desc
SELECT
FND_CONC_REQ_SUMMARY_V
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment