Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to find the Responsbility Name
Need to find the Responsbility Name [message #176742] Fri, 09 June 2006 06:57 Go to next message
yram
Messages: 75
Registered: February 2001
Member
Pls do give me a query to find a responsbility name, when my input is report name ...

Regards
Yram

Report message to a moderator

Re: Need to find the Responsbility Name [message #176764 is a reply to message #176742] Fri, 09 June 2006 08:35 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Hi,
A concurrent request can be included in a request group.
A request group is assign to a responsibility.
Is that enough to write your query ?

Report message to a moderator

Re: Need to find the Responsbility Name [message #178158 is a reply to message #176742] Mon, 19 June 2006 14:53 Go to previous messageGo to next message
vchitiyala
Messages: 4
Registered: June 2006
Location: Tulsa, OK
Junior Member
Maybe this query will help:

SELECT frt.responsibility_name responsibility,
rg.request_group_name request_group,
fat.application_name application,
fcpt.user_concurrent_program_name concurrent_program,
fcp.concurrent_program_name short_name
FROM fnd_request_groups rg,
fnd_request_group_units rgu,
fnd_concurrent_programs_tl fcpt,
fnd_concurrent_programs fcp,
fnd_responsibility_tl frt,
fnd_responsibility fr,
fnd_application_tl fat
WHERE rg.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = fcpt.concurrent_program_id
AND fcpt.concurrent_program_id = fcp.concurrent_program_id
AND rg.request_group_id = fr.request_group_id
AND fr.responsibility_id = frt.responsibility_id
AND rg.application_id = fat.application_id
AND fcp.concurrent_program_name LIKE '%GLASREP%'
ORDER BY fcp.concurrent_program_name

Report message to a moderator

Re: Need to find the Responsbility Name [message #178356 is a reply to message #178158] Tue, 20 June 2006 15:09 Go to previous message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Not sure, you really need fnd_concurrent_programs_tl and fnd_responsibility_tl. You will have duplicates records if many languages are used (due to translation on responsibility and program name). I you need translation, then used standard views which will give only one result for the active language.
Not all jointures are used:
FND_REQUEST_GROUP_UNITS (unit_application_id and request_unit_id)
FND_CONCURRENT_PROGRAMS (application_id and concurrent_program_id)

FND_REQUEST_GROUP_UNITS (application_id and request_group_id)
FND_REQUEST_GROUPS (application_id and request_group_id)

FND_RESPONSIBILITY (group_application_id and request_group_id)
FND_REQUEST_GROUPS (application_id and request_group_id)

Report message to a moderator

Previous Topic: report
Next Topic: Forms personization
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 04:32:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.