Search This Blog

Saturday, January 26, 2008

Find concurrent program & Request set attached to a responsibility

I have a concurrent program which I want to submit .. but here is the problem. I dont know which responsibility this program is attached to. No wonder .. below is the query that can be used to find the list of responsibilities to which the programs is attached to.

Query to find concurrent program

    select frt.responsibility_name, frg.request_group_name,
    frgu.request_unit_type,frgu.request_unit_id,
    fcpt.user_concurrent_program_name
    From fnd_Responsibility fr, fnd_responsibility_tl frt,
    fnd_request_groups frg, fnd_request_group_units frgu,
    fnd_concurrent_programs_tl fcpt
    where frt.responsibility_id = fr.responsibility_id
    and frg.request_group_id = fr.request_group_id
    and frgu.request_group_id = frg.request_group_id
    and fcpt.concurrent_program_id = frgu.request_unit_id
    and frt.language = USERENV('LANG')
    and fcpt.language = USERENV('LANG')
    and fcpt.user_concurrent_program_name = :conc_prg_name
    order by 1,2,3,4


Query to find Request Set
    select frt.responsibility_name, frg.request_group_name,
    frgu.request_unit_type,frgu.request_unit_id,
    fcpt.user_request_set_name
    From apps.fnd_Responsibility fr, apps.fnd_responsibility_tl frt,
    apps.fnd_request_groups frg, apps.fnd_request_group_units frgu,
    apps.fnd_request_Sets_tl fcpt
    where frt.responsibility_id = fr.responsibility_id
    and frg.request_group_id = fr.request_group_id
    and frgu.request_group_id = frg.request_group_id
    and fcpt.request_set_id = frgu.request_unit_id
    and frt.language = USERENV('LANG')
    and fcpt.language = USERENV('LANG')
    and fcpt.user_request_set_name = :request_set_name
    order by 1,2,3,4


Related Post:
Query to get Concurrent Program name and its Parameter

9 Comments:

Srinivas Prasad said...

Thanks Suresh this has been useful for me

Suresh Vaishya said...

Appreciate your feedback.

Suresh

yd said...

This was usefull to me
Thank you

Anonymous said...

This has been a great help.
Your effort is very much appreciated.
Thank you Suresh!

Anonymous said...

Thanks Suresh. This was of great help this morning. Sam

Anonymous said...

Thanks a lot. It helped.

CA Neetal Jain said...

Thanks a lot,very useful

godfrey ogondi said...

This was very help full good work

Sridevi Koduru (Oracleappstechnical.com) said...
This comment has been removed by a blog administrator.

Copyright (c) All rights reserved. Presented by Suresh Vaishya