SELECT DISTINCT frt.responsibility_name, fmt.user_menu_name FROM apps.fnd_responsibility_tl frt, apps.fnd_responsibility fr, ...
Showing posts with label Useful Queries. Show all posts
Showing posts with label Useful Queries. Show all posts
Tuesday, July 15, 2014
Request Group assigned to Responsibilty
SELECT responsibility_name responsibility,request_group_name,frg.description FROM fnd_request_groups frg, fnd_responsibility_vl frv WHERE ...
Responsibility Assigned to Users
SELECT DISTINCT u.user_id ,SUBSTR (u.user_name, 1, 30) user_name ...
List of Responsibilities in an Instance
SELECT (SELECT application_short_name
FROM fnd_application fa
WHERE fa.application_id = frt.application_id) application,
frt.responsibility_id, frt.responsibility_name
FROM...
Tuesday, July 1, 2014
SQL query to find out Drop Ship Sales Order, Line, Requisition and Purchase order
select h.order_number,l.line_number SO_Line_number, ph.segment1
PO_Number,pl.line_num PO_Line_Number,
ph.authorization_status,ph.closed_date,ph.closed_code,
prh.interface_source_code,
prh.segment1...
SQL Query to find sales order lines whose workflow is Purged
Select Line_Id, flow_status_code,ordered_quantity,shipped_quantity, fulfilled_flag, invoice_interface_status_code
From Oe_Order_Lines_All l
where open_flag = 'Y'
And not Exists
(Select 1 From Wf_Items...
Monday, June 9, 2014
Query to find responsibilities to which a Concurrent program is assigned
SELECT DISTINCT *
FROM apps.fnd_responsibility_tl
WHERE responsibility_id IN
(SELECT responsibility_id
FROM apps.fnd_responsibility_vl
WHERE request_group_id IN
(SELECT...
Query to find out Responsibilities assigned to a user
SELECT UNIQUE u.user_id, SUBSTR (u.user_name, 1, 30) user_name, u.DESCRIPTION,
SUBSTR (r.responsibility_name, 1, 60) responsiblity,
SUBSTR (a.application_name, 1, 50) application
FROM fnd_user u,
fnd_user_resp_groups...
Script To List The Values Of A Profile Option At All Levels
--Script To List The Values Of A Profile Option At All Levels (Doc ID 803587.1)
SELECT fpo.profile_option_id, fpot.profile_option_name profile_short_name
, substr(fpot.user_profile_option_name,1,60)...
SQL Query To find out File Version
select sub.filename, sub.version
from (
select adf.filename filename,
afv.version version,
rank()over(partition by adf.filename
order by afv.version_segment1...
Subscribe to:
Posts (Atom)