# -----------------------------------------------------
# Get Resp Name
# -----------------------------------------------------
RESP_NAME=`sqlplus -s $FCP_LOGIN << !
set term off
set head off
set pages 0
set feedback off
SELECT RESP.responsibility_name
FROM fnd_responsibility_vl RESP
,fnd_concurrent_requests REQ
WHERE RESP.responsibility_id = REQ.responsibility_id
AND REQ.request_id = $FCP_REQID
AND rownum = 1
/
!
`
RESP_APPL_SHORT_NAME=`sqlplus -s $FCP_LOGIN << !
set term off
set head off
set pages 0
set feedback off
SELECT FAPP.application_short_name
FROM fnd_application FAPP
,fnd_concurrent_requests REQ
WHERE FAPP.application_id = REQ.responsibility_application_id
AND REQ.request_id = $FCP_REQID
AND rownum = 1
/
!
`
No comments:
Post a Comment