السلام عليكم ورحمة الله

كيف الحال اخواني

كثير ممن يتعاملون مع الابس يحتاجون الى تنفيذ بعض السكربتات

قررت ان ابدأ موضوع نتشارك فيما بيننا حول بعض الاكواد التي من الممكن ان تفيد و تسهل من العمل تحت منصة الابس

سأبدأ انا باول كود واتمنى منكم المشاركة

للحصول على ما نملكه من مسؤوليات Responsiplities

SELECT (SELECT application_short_name

FROM fnd_application fa

WHERE fa.application_id = frt.application_id) application,

frt.responsibility_id, frt.responsibility_name

FROM apps.fnd_responsibility_tl frt;

لايجاد القوائم المرتبطة بالمسؤوليات
Menu & responsibilites

SELECT DISTINCT a.responsibility_name, c.user_menu_name

FROM apps.fnd_responsibility_tl a,

apps.fnd_responsibility b,

apps.fnd_menus_tl c,

apps.fnd_menus d,

apps.fnd_application_tl e,

apps.fnd_application f

WHERE a.responsibility_id(+) = b.responsibility_id

AND a.responsibility_id = ‘20538’

AND b.menu_id = c.menu_id

AND b.menu_id = d.menu_id

AND e.application_id = f.application_id

AND f.application_id = b.application_id

AND a.LANGUAGE = 'US'; 

Submenu And Function Listing

Purpose
To get submenus and Function attached to this Main menu.


Description
By using this query user can check function and submenus attached to that specific menu


Parameters
User_menu_name Which user can get from query of section Menu Listing


Query

SELECT c.prompt, c.description

FROM apps.fnd_menus_tl a, fnd_menu_entries_tl c

WHERE a.menu_id = c.menu_id AND a.user_menu_name = 'F4 UK PAY Navigator'; 

User And Assigned Responsibility Listing

Purpose
To get assigned responsibility to a user.


Description
User wants to check responsibility attached to a specific user


Parameters
None



Query

SELECT UNIQUE u.user_id, SUBSTR (u.user_name, 1, 30) user_name,

SUBSTR (r.responsibility_name, 1, 60) responsiblity,

SUBSTR (a.application_name, 1, 50) application

FROM fnd_user u,

fnd_user_resp_groups g,

fnd_application_tl a,

fnd_responsibility_tl r

WHERE g.user_id(+) = u.user_id

AND g.responsibility_application_id = a.application_id

AND a.application_id = r.application_id

AND g.responsibility_id = r.responsibility_id

ORDER BY SUBSTR (user_name, 1, 30),

SUBSTR (a.application_name, 1, 50),

SUBSTR (r.responsibility_name, 1, 60);

بارك الله فيك على المجهود المبدول