Wednesday, 24 August 2011

SQL Query to find out the Resposibility and Request Group assigned to Concurrent program

*PURPOSE: To list out Responsibilities & Request Group assigned to Conc Prgm*
*PARAMETERS: Concurrent program Name                                                          *

SELECT fcpt.user_concurrent_program_name,
FROM fnd_request_group_units frgu,
  fnd_concurrent_programs fcp,
  fnd_concurrent_programs_tl fcpt,
  fnd_request_groups frg,
  fnd_executables fe,
  fnd_responsibility fr,
  fnd_responsibility_tl frt
WHERE frgu.request_unit_id    = fcp.concurrent_program_id
AND frgu.request_group_id     = frg.request_group_id
AND fe.executable_id          = fcp.executable_id
AND fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.user_concurrent_program_name = '&Conc_Prgm_Name'
AND frg.request_group_id = fr.request_group_id
AND fr.responsibility_id = frt.responsibility_id;

1 comment:

  1. Thank you for sharing the ones most vital weblog submission internet web websites for delivered about information please test the net internet site
    Oracle Fusion procurement Training
    Oracle Fusion Cloud procurement Training