Wednesday, January 7, 2015

Query to find Responsibility for the Concurrent Program

SELECT frt.responsibility_name, 
               frg.request_group_name, 
               frg.description
  FROM fnd_request_groups frg
             ,fnd_request_group_units frgu
             ,fnd_concurrent_programs fcp
             ,fnd_concurrent_programs_tl fcpt
             ,fnd_responsibility_tl frt
             ,fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
 AND   frgu.request_unit_id = fcp.concurrent_program_id
 AND   frg.request_group_id = frgu.request_group_id
 AND   frg.application_id = frgu.application_id
 AND   fcpt.source_lang = USERENV('LANG')
 AND   fcp.application_id = fcpt.application_id
 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id
 AND   frs.application_id = frt.application_id
 AND   frs.responsibility_id = frt.responsibility_id
 AND   frt.source_lang = USERENV('LANG')
 AND   frs.request_group_id = frg.request_group_id
 AND   frs.application_id = frg.application_id
 AND   fcp.concurrent_program_name = <shortname>
 AND   fcpt.user_concurrent_program_name LIKE <User concurrent program>

1 comment:

  1. Did you realize there's a 12 word sentence you can tell your partner... that will induce intense emotions of love and instinctual attractiveness for you buried within his heart?

    Because hidden in these 12 words is a "secret signal" that fuels a man's instinct to love, please and care for you with his entire heart...

    12 Words Will Trigger A Man's Desire Instinct

    This instinct is so built-in to a man's mind that it will make him work harder than ever before to to be the best lover he can be.

    In fact, triggering this powerful instinct is so mandatory to having the best possible relationship with your man that the second you send your man one of the "Secret Signals"...

    ...You will soon find him expose his mind and heart to you in a way he haven't experienced before and he will recognize you as the one and only woman in the world who has ever truly tempted him.

    ReplyDelete