Thursday, August 21, 2014

Get Responsibility Name and Resp Application Short Name in Shell




# -----------------------------------------------------
# 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