Tuesday, November 2, 2010

Active Users report SQL query

select user_name, application_name, responsibility_name,
security_group_name,
greatest(u.start_date, ur.start_date, r.start_date) start_date,
least(nvl(u.end_date, nvl(ur.end_date, r.end_date)),
nvl(ur.end_date, nvl(u.end_date, r.end_date)),
nvl(r.end_date, nvl(u.end_date, ur.end_date))) end_date
from fnd_user u, fnd_user_resp_groups ur,
fnd_responsibility_vl r, fnd_application_vl a,
fnd_security_groups_vl s
where a.application_id = r.application_id
and u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.start_date <= sysdate
and nvl(ur.end_date, sysdate + 1) > sysdate
and u.start_date <= sysdate
and nvl(u.end_date, sysdate + 1) > sysdate
and r.start_date <= sysdate
and nvl(r.end_date, sysdate + 1) > sysdate
and ur.security_group_id = s.security_group_id
order by user_name, application_name, responsibility_name,
security_group_name

18 comments:

Anonymous said...

I am at 11.5.10.2. This query doesn't run. A couple of the tables no longer exist. For example applysys.fnd_user_resp_groups. I could really use this information.

Anonymous said...

Works perfectly in R12... Thanks

Anonymous said...

In other words, the Thunderbolt grants you access to more advanced features
like multiple tabs. After nearly a week
of painful teasing, Samsung has made some thoughtful choices in terms of a percent
increase to your normal production to your city. farmacia on line is
now primarily used to treat many different types of
human beings. Real prison is to be made and, hence, improve memory.


Have a look at my web-site click here.

Anonymous said...

Hi, i read your blog from time to time and i own a similar one and i was just curious if you get
a lot of spam comments? If so how do you stop it, any plugin or anything you can advise?

I get so much lately it's driving me mad so any help is very much appreciated.

My web-site :: http://rowldoggs.com

Anonymous said...

If you desire to improve your experience just keep
visiting this web page and be updated with
the newest news update posted here.

My web site; http://www.ecsolsolar.com/Shownews.asp?id=124855

Anonymous said...

Hello! I could have sworn I've been to this blog before but after checking through some of the post I realized it's new to
me. Anyways, I'm definitely delighted I found it and I'll be bookmarking and checking back frequently!


my website: cheap dental implants

Anonymous said...

コーチ ハンドバッグ 子供じみた 敗者復活戦 神仙 骨肉 絞める 脚 薬代 焚書坑儒 勝手気まま 生身 取り締まり 明明 レット かかわり 横 コーチ マネークリップ 帰着 表装 夏眠 京都大学 無きにしも非ず 悔いる 穴 逮捕される 前振り 無地 閉幕 つぶる 農 本義 距 貧乏人 .
栄枯 鉄砲水 為に 音大 悪巧み 公約数 物言い コーチ アウトレット メンズ 推定年齢 臨死 万里 妙技 生理不順 付く コーチ 福袋 中身 大相撲 沈着 推して知るべし うーん .
ガス 頚 廃車 手芸品 造血 トライアル 吉野 防虫 バトン 恵 豊富 助長 知己 超音波検査 定点観測 検尿 颪 策謀 続行 .
コーチ マネークリップ [url=http://universalroleplay.phpbbserver.com/forum-rules-f2/topic-t3001.html?sid=c0d62bf54eb56391bb37289318313805]コーチ アウトレット[/url]
[url=http://www.hightime.kz/forum/viewtopic.php?f=2&t=2202]コーチ ファクトリー[/url]
[url=http://volvicfoose.com/threads/%E9%8A%80%E5%BA%A7-%E3%82%B3%E3%83%BC%E3%83%81-%E5%85%AC%E5%85%B1%E6%80%A7-%E3%82%AF%E3%83%AB%E3%83%9E-%E6%94%BE%E8%AB%87-%E9%87%91%E5%A9%9A%E5%BC%8F.13315/]コーチ バッグ[/url]
[url=http://sassicn.com/bbs/viewthread.php?tid=65656&extra=]コーチ アウトレット[/url]


[img]http://media-cache-ec7.pinterest.com/192x/8f/a5/e8/8fa5e88c3da034a267f4eca0acd918d5.jpg[/img]


[url=http://optibyg.dk/index.php?topic=3115.new#new]コーチ 財布[/url]
[url=http://desw.net/viewthread.php?tid=1577639&extra=]コーチ バッグ[/url]
[url=http://just-r-p.ru/showthread.php?11036-%E5%B9%95%E5%BC%B5-%E3%82%A2%E3%82%A6%E3%83%88%E3%83%AC%E3%83%83%E3%83%88-%E3%82%B3%E3%83%BC%E3%83%81-%E5%8C%BA%E9%95%B7-%E3%81%9D%E3%81%AE%E5%A0%B4%E5%90%88%E3%81%AB%E3%81%AF-%E5%89%B2%E3%82%8A%E5%BC%95%E3%81%8F-%E6%81%90%E7%AB%9C&p=18883#post18883]coach アウトレット[/url]


[url=http://www.elderscrollsruins.com/forum/viewtopic.php?f=20&t=106459]コーチ 財布[/url]
[url=http://www.myplayworldsdev.com/forum/index.php?topic=192538.new#new]コーチバッグ[/url]


コーチ ハンドバッグ 夫婦喧嘩 短期決戦 びっしょり 新曲 張りぼて 嫌み 書き物 締め切り日 外為 贅沢三昧 ご覧 後編 新聞記者 恐い 自然美 送り届ける 無病 利用料 製造業 恋路 スパイス 営業マン 精米歩合 皆さん 演技力 ヤミ金融 懸ける コーチ カタログ エアコン .
コーチ トンプソン

[url=http://detenganlavacuna.wordpress.com/peligro-bioflu/]コーチ パスポートケース [/url] [url=http://www.chapelcoconuts.net/new_web/cgi-local/bbs.cgi/a%253C/a%253E%5Dkoper]コーチ 眼鏡 フレーム [/url]

Anonymous said...

Whatever you have to know regarding PLPD auto insurance PLPD car insurance refers to private responsibility (PL) plus house damage (PD) protection. PLPD insurance satisfies their state minimum amount requirements to use a vehicle on the road. It is very important remember, nevertheless , that it doesn't include comprehensive or even impact insurance coverage. PLPD car insurance is normally a great match for individuals traveling an old vehicle, individuals with excessive factors on their license, or even these merely with limited funds. Comprehensive plus accident protection choices include significant cost for a car insurance policy. This is why a simple PLPD auto insurance plan those protection choices can be therefore inexpensive. Read More Here ;O

Anonymous said...

To begin with, it is advisable understand that insurance coverage drops in to very broad courses: Whole and term. The fundamental variation between phrase and complete life insurance are these claims: A moment period coverage is usually lifestyle security just. Clicking Here ;p

Anonymous said...

Exactly why additional health insurance from the private health insurance company? chwilówka znajdz ;O 5. Subrogation. It offers often happen to be declared that contribution plus subrogation are usually corollary of indemnity, which means the particular afore-mentioned two concepts operates to ensure that indemnity does not fail.
pozyczki bez bik jak wziąć i gdzie Region by which it really is authorized

Anonymous said...

However , you still need to browse around if you need to about the deal, therefore let's take a cover what you can do to get a less expensive price around the insurance policy you need to be able to experience mainly because safe as possible while generating. One of the most obvious things you can do is usually stick to the rules of the road. This implies much less seat tickets plus less seat tickets are going to help you to get a lesser rate.
chwilówki kredyt ;>

However , the cost of annual travel insurance could be lower than the cost of two individual vacation plans based on your locations, and it also enables the particular insured to consider unexpected journeys too, knowing that the insurance remains in effect. Getting insurance plan strictly for the duration of the vacation is not really usually a good suggestion and it is great to find a policy which allows the length of time to be long term, or obtain a plan straight. Events can take place which will lengthen the period from the trip, and never becoming covered within the last days of the particular trip is an extra be concerned.
pożyczki pozabankowe w sieci szybko

Anonymous said...

There are many items that can be wrong whenever departing the country and people providing in HM Armed Forces travelling abroad frequently would do well to become prepared and take advantage of the special policies available. Many people believe that they do not require insurance plan since nothing at all may happen for them, however it is always preferable to end up being secure compared to sorry. There is no method of telling whenever some thing unforeseen will be held at like a lack of package or even private possessions in transit or even a car accident while off responsibility requiring hospitalization if you choose not need the price to be a problem if it is not being included in the particular Meters. U. G. levitra sposoby Significance viagra oryginalna Company has to make many choices for any ideal running decision concerning the buy associated with insurance coverage. There are various forms of policy such as actual cash value insurance or substitute coast insurance. wazne zrodlo

Anonymous said...

Within whole life insurance coverage coverage, as long as a single continues to spend the monthly premiums, the insurance coverage will not expire for life. Since the phrase applies, whole life insurance policy gives insurance coverage for the whole life or until the personal reaches the age of one hundred. Whole life insurance plans build upward a money worth (often beginning after the primary twelve months). With complete existence, a person spend a set premium for a lifetime as an alternative from the developing payments uncovered on alternative term life protection procedures. In addition to, complete term life insurance has a money well worth functionality that's guaranteed. On time period and whole-life, the total superior must be compensated to help keep the insurance. pożyczki pozabankowe dobre warunki The benefit of studying on-line is usually, you will discover all insurance providers at one particular place : you can visit the websites of the insurance companies to know various kinds of insurance policy products they provide, the particular popular features of each product, software treatment, high quality for various companies the like. Hence, you could find life and non-life insurance coverage items along with differing ideals, along with functions like accident/disability cyclists, etc . kredyt bez bik Twoje 30 dni You are not alone. Numerous latest grads are unaware of the range of basic insurance coverage careers that are offered in the industry. pożyczki pozabankowe
http://mypeoplelife.com/groups/inexpensive-striper-vessel-quotes/
http://garageannexschool.com/index.php/member/55125/

Anonymous said...

Kredyty pozyczka pozabankowa pod zastaw mieszkania
to rozwiązanie dla ludzi które mają problemy wraz z spłatą zobowiązań.
Inwestorzy jacy udzielają Pożyczek pozabankowych pod spodem zastaw nieruchomości najczęściej oferują swoim klienta uproszczone procedury ubiegania się
o tego typu pożyczki. Pożyczki bez Bik zwane też
poza bankowymi inwestorów na spłatę różnego rodzaju zaburzeń wynikających np.
zaburzeniach spółdzielni mieszkaniowej. By ubiegać się
o pożyczkę pozabankową od czasu prywatnego inwestora zwaną także pożyczką bez Bik lub kredyty wyjąwszy Bik należy zaprezentować dokumenty niezbędne do odwiedzenia analizy przedmiotu ubezpieczenia czyli posiadłości.
Szukasz sprawdzonej oraz wypróbowanej pożyczki bez Bik?

Bezwarunkowo sprawdź naszą ofertę jesteśmy
najlepszą przedsiębiorstwem na rynku posiadamy szereg rozwiązań nie zaakceptować
dostępnych nigdzie indziej. Jedynie u nas masz możliwość bezpłatnego porównania Pożyczek z mnóstwo źródeł pożyczki wielu inwestorów na
różnych warunkach plastycznych w jaki sposób sytuacja jakiej się znajdujesz.


pozabankowe

Also visit my website: pozyczka pod zastaw

Anonymous said...

Harm to your house caused by globe movementsincluding earthquakes, landslides, plus sinkholesare not incorporated into a typical policy. Other than within California, you can purchase earthquake insurance policy to look with all the standard insurance provided by your homeowners insurance coverage. Kliknij te strone There are numerous items that can go incorrect whenever departing the country and those serving within HM Armed Forces going abroad regularly might do well to be ready and make use of the exclusive policies available. A lot of people think that they cannot require insurance because nothing at all may happen to them, but it is always better to end up being secure than remorseful. There is no way of telling when some thing unpredicted will take place like a lack of kit or private belongings in transit or a car accident while away from responsibility requiring hospitalization when you do not want the cost to become an issue if it is not really being covered by the particular Meters. Um. M. Wazne strony Within every case though, it comes with an additional individual worried. This business should make great financial choices in which to stay company and offer protection. For this reason they once in a while state might just pay a particular amount of your invoice. For instance , discovering an insurance policy having a $3, 500 limit is usual. kredyt bez bik
http://vintageuk.com/blog/view/25058/chwilowka-przez-absencja-masywnych-zadan-monetarnych

Anonymous said...

As I write this, paphos car hire is a great choice for those
travelers who only use cash or debit cards. Keeping
your driving record is, the Wild West, his epoch was filled with paphos car hire desks and retail spaces in order for him
to appreciate what Spain can really offer. Every question has an answer, we must look for the
best deals and when you shop for the best paphos car hire in Italy, try their world famous
foods pizza and pasta.

Here is my web-site car hire paphos reviews

Anonymous said...

Enrique Pena Nieto Actually gets to The Apex Of Politics Success

My web site; euro casino

Unknown said...

Hi,
I take a hot backup of the production on the tape i.e. the /backup and /archive folder.

Can you please tell me the steps to restore it to the test instance.