Friday, November 1, 2019

Find Oracle R12 active responsibility access with Employee Name

select
    e.user_id,
        (select full_name from
            apps.per_all_people_f papf
            where employee_number=(select distinct user_name from apps.fnd_user where user_id=a.user_id)
            and sysdate between papf.effective_start_date and papf.effective_end_date) full_name,
  fu.user_name,fu.start_date,fu.end_date,
  b.application_id,b.RESPONSIBILITY_KEY,c.RESPONSIBILITY_NAME
    from
        apps.fnd_application fap,
        apps.FND_USER_RESP_GROUPS a,
            apps.FND_RESPONSIBILITY b,            
            apps.FND_RESPONSIBILITY_VL c,
            apps.FND_RESPONSIBILITY_tl d,
            apps.FND_USER_RESP_GROUPs_direct e,
            apps.fnd_user fu
        where
            fap.application_id=b.application_id
         and  a.responsibility_id=b.responsibility_id        
         and c.RESPONSIBILITY_KEY=b.RESPONSIBILITY_KEY
         and b.responsibility_id=d.responsibility_id
         and b.responsibility_id=e.responsibility_id
         and e.user_id=a.user_id
         and a.user_id=fu.user_id
--         and c.RESPONSIBILITY_NAME like 'Application%'        
         and fu.user_name=:employee_number 
--         and a.user_id=:User_id

Find all Oracle R12 responsibility access by Query

SELECT fuser.user_name User_Name,
       frt.responsibility_name  Responsibility_Name,
       furgd.start_date            Start_Date,
       furgd.end_date              End_Date,
       fresp.responsibility_key    Responsibility_Key,
       fapp.application_short_name Application_Short_Name
    FROM apps.fnd_user_resp_groups_direct furgd,
       apps.fnd_user                    fuser,
       apps.fnd_responsibility          fresp,
       apps.fnd_responsibility_tl       frt,
       apps.fnd_application             fapp,
       apps.fnd_application_tl          fat
 WHERE 1 = 1
   AND furgd.user_id = fuser.user_id
   AND furgd.responsibility_id = frt.responsibility_id
   AND fresp.responsibility_id = frt.responsibility_id
   AND fapp.application_id = fat.application_id
   AND fresp.application_id = fat.application_id
   AND frt.language = USERENV('LANG')
   AND UPPER(fuser.user_name) = UPPER('&Enter_User_Name')
--AND (furgd.end_date IS NULL OR furgd.end_date >= TRUNC(SYSDATE))
 ORDER BY frt.responsibility_name;

Wednesday, February 3, 2010

Sunday, December 14, 2008

ek rater kotha

goto rater kotha bolsi, goto rat bolte 2008 december 13 er ses somoy r 14 er suru. ami ekti mess e thaki. Office ses kore ekti misil e jog dilam er por basay firlam. tokhon rat 9.30 or 10.00 ta baje. basay fire dekhi bua asenai tai khub kosto laglo karon khawadawar jonno ekhon nijekei rannna korte hobe. hat muk due fresh holam tarpor culay caul coriye dilam. ami abar besh bhalo bhat ranna korte pari. amar bhat ranna korte mar galte hoy na. minite 20 er modde bhat ranna hoye gelo tarpor suru holo dim(egg) bhaja. khati sorisar oil die dim bajlam. ektu test korlam dekhlam besh moja hoice.Eid er chutir por basay aschi khawar pani(water) nai tai pani futanor jonno harite kore pani culay coriye dilam. dim bhaja dia bhat khawa suru korlam er modde pani futece. pani to matro futano hoylo tai pani khete parlam na. Pani khawar jonne moge kore ekmog pani nie fen er niche bicanar upor danda(cold) hoyar jonne raklam. r ami bichanay suye suye boi porte laglam kohhon je gumie gachi ter paini. onek rat hotat gum benge galo. ami onuvov korlam amar pacha r lungi donotai vija. chinta korte laglam ami ki bicanay hisu kore lilam naki. tapor mone holo ami to r choto bacca noi je amar bicanay hisu hoye jabe. tapor abar bhabte laglam tahole ki holo bichana kivabe vijlo. hat nartei hate mog laglo. tokhon bujte parlam j moger pani danda hoy amar bicana sikto hoyece kintu amar gola vije nai.