Tuesday, 30 September 2014

apps Concurrent programs

SELECT
    frg.request_group_name,
    frg.description,
    cp.concurrent_program_id,
    cp.concurrent_program_name,
    cpt.user_concurrent_program_name,
    frv.responsibility_name
FROM
    fnd_request_groups              frg,
    fnd_request_group_units       frgu,
    fnd_concurrent_programs      cp,
    fnd_concurrent_programs_tl   cpt,
    fnd_responsibility_vl              frv
WHERE
        frg.request_group_id                     = frgu.request_group_id
    AND frgu.request_unit_id                      = cp.concurrent_program_id
    AND cp.concurrent_program_id              = cpt.concurrent_program_id
    AND frv.request_group_id                      = frg.request_group_id(+)
    AND frg.request_group_name                LIKE  'All Reports'
    AND frg.description                              = 'All Purchasing SRS Reports'
    AND cpt.user_concurrent_program_name LIKE 'Account Analysis Report%'

No comments:

Post a Comment