ORACLE APP EBS R12 – CONCORRENTE VS RESPOSSABILIDADE

Consulta para checar todas as responsabilidades onde um dado concorrente esta disponível.

 

select b.responsibility_name

,c.request_group_name

,ie.concurrent_program_name

,f.description

from APPS.FND_RESPONSIBILITY         a

, APPS.FND_RESPONSIBILITY_TL      b

, APPS.FND_REQUEST_GROUPS         c

, APPS.FND_REQUEST_GROUP_UNITS    d

, APPS.FND_CONCURRENT_PROGRAMS    ie

, APPS.FND_CONCURRENT_PROGRAMS_TL f

where a.application_id          = b.application_id

and a.responsibility_id       = b.responsibility_id

and a.application_id          = c.application_id

and a.request_group_id        = c.request_group_id

and c.application_id          = d.application_id

and c.request_group_id        = d.request_group_id

and d.request_unit_id         = ie.concurrent_program_id

and ie.application_id          = f.application_id

and ie.concurrent_program_id   = f.concurrent_program_id

and upper(f.user_concurrent_program_name) Like upper(‘%NOME DO CONCORRENTE%’)

 

Deixe uma resposta

Pular para a barra de ferramentas