-查看EBS用戶的所有職責(zé)：

成都創(chuàng)新互聯(lián)公司服務(wù)項(xiàng)目包括西安網(wǎng)站建設(shè)、西安網(wǎng)站制作、西安網(wǎng)頁制作以及西安網(wǎng)絡(luò)營銷策劃等。多年來，我們專注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術(shù)優(yōu)勢(shì)、行業(yè)經(jīng)驗(yàn)、深度合作伙伴關(guān)系等，向廣大中小型企業(yè)、政府機(jī)構(gòu)等提供互聯(lián)網(wǎng)行業(yè)的解決方案，西安網(wǎng)站推廣取得了明顯的社會(huì)效益與經(jīng)濟(jì)效益。目前，我們服務(wù)的客戶以成都為中心已經(jīng)輻射到西安省份的部分城市，未來相信會(huì)繼續(xù)擴(kuò)大服務(wù)區(qū)域并繼續(xù)獲得客戶的支持與信任！

SELECT frt.responsibility_name, furg.END_DATE
  FROM fnd_user_resp_groups  furg,
       fnd_responsibility    fr,
       fnd_responsibility_tl frt,
       fnd_user              fu
 where fu.user_name = '&username'
   and fu.user_id=furg.user_id
   and furg.RESPONSIBILITY_ID = fr.responsibility_id
   and frt.responsibility_id=fr.responsibility_id
   --and furg.END_DATE is not null
 order by 1

----現(xiàn)有的請(qǐng)求時(shí)間排序

SELECT fcr.request_id request_id,
       TRUNC(((fcr.actual_completion_date - fcr.actual_start_date) /
             (1 / 24)) * 60) exec_time,
       fcr.actual_start_date start_date,
       fcp.concurrent_program_name conc_prog,
       fcpt.user_concurrent_program_name user_conc_prog
  FROM fnd_concurrent_programs    fcp,
       fnd_concurrent_programs_tl fcpt,
       fnd_concurrent_requests    fcr
 WHERE TRUNC(((fcr.actual_completion_date - fcr.actual_start_date) /
             (1 / 24)) * 60) > NVL('&min', 45)
   and fcr.concurrent_program_id = fcp.concurrent_program_id
   and fcr.program_application_id = fcp.application_id
   and fcr.concurrent_program_id = fcpt.concurrent_program_id
   and fcr.program_application_id = fcpt.application_id
   and fcpt.language = USERENV('Lang')
 ORDER BY TRUNC(((fcr.actual_completion_date - fcr.actual_start_date) /
                (1 / 24)) * 60) desc;

--查詢各個(gè)模塊的版本

select a.oracle_id,
       a.last_update_date,
       a.product_version,
       a.patch_level,
       decode(a.status,
              'I',
              'Installed',
              'S',
              'Shared',
              'N',
              'Not Installed',
              a.status) Status,
       a.industry,
       b.application_name,
       c.application_short_name
  from fnd_product_installations a, fnd_application_tl b, fnd_application c
 where a.application_id = b.application_id
   and a.application_id = c.application_id
   and b.language = 'US'
 order by c.application_short_name;

--檢查定時(shí)任務(wù)

select
        fcr.request_id,
        fcr.parent_request_id,
        fu.user_name requestor,
        to_char(fcr.requested_start_date, 'MON-DD-YYYY HH24:MM:SS') START_DATE,
        fr.responsibility_key responsibility,
        fcp.concurrent_program_name,
        fcpt.user_concurrent_program_name,
        decode(fcr.status_code,
               'A', 'Waiting',
               'B', 'Resuming',
               'C', 'Normal',
               'D', 'Cancelled',
               'E', 'Error',
               'F', 'Scheduled',
               'G', 'Warning',
               'H', 'On Hold',
               'I', 'Normal',
               'M', 'No Manager',
               'Q', 'Standby',
               'R', 'Normal',
               'S', 'Suspended',
               'T', 'Terminating',
               'U', 'Disabled',
               'W', 'Paused',
               'X', 'Terminated',
               'Z', 'Waiting') status,
        decode(fcr.phase_code,
               'C', 'Completed',
               'I', 'Inactive',
               'P', 'Pending',
               'R', 'Running') phase,
        fcr.completion_text
from
        fnd_concurrent_requests fcr,
        fnd_concurrent_programs fcp,
        fnd_concurrent_programs_tl fcpt,
        fnd_user fu,
        fnd_responsibility fr
where
        fcr.status_code in ('Q', 'I') and
        fcr.hold_flag = 'N' and
        fcr.requested_start_date > sysdate and
        fu.user_id = fcr.requested_by and
        fcr.concurrent_program_id = fcp.concurrent_program_id and
        fcr.concurrent_program_id = fcpt.concurrent_program_id and
        fcr.responsibility_id = fr.responsibility_id
order by
        fcr.requested_start_date,  fcr.request_id;

--查看用戶登錄情況

SELECT user_name username,
       description name,
       to_char(b.first_connect, 'MM/DD/RR HH24:MI') firstconnect,
       to_char(b.last_connect, 'MM/DD/RR HH24:MI') lastconnect
  FROM apps.fnd_user a,
       (SELECT MIN(first_connect) first_connect,
               MAX(last_connect) last_connect,
               last_updated_by user_id
          FROM apps.icx_sessions
         GROUP BY last_updated_by) b
 WHERE a.user_id = b.user_id
   AND last_connect > SYSDATE - 3 / 12
 ORDER BY 4 DESC

名稱欄目：oracleEBSdbaSQLscripts
URL地址：http://www.rwnh.cn/article26/ippecg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供標(biāo)簽優(yōu)化、靜態(tài)網(wǎng)站、App開發(fā)、營銷型網(wǎng)站建設(shè)、定制開發(fā)、網(wǎng)站設(shè)計(jì)公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)