Query to Find The Request Group Name For a Concurrent Program
SELECT
RG.APPLICATION_ID "Request Group Application ID",
RG.REQUEST_GROUP_ID "Request Group - Group ID",
RG.REQUEST_GROUP_NAME,
RG.DESCRIPTION,
rgu.unit_application_id,
rgu.request_group_id "Request Group Unit - Group ID",
rgu.request_unit_id,cp.concurrent_program_id,
cp.concurrent_program_name,
cpt.user_concurrent_program_name,
DECODE(rgu.request_unit_type,
'P',
'Program',
'S',
'Set',
rgu.request_unit_type) "Unit Type"
FROM
fnd_request_groups rg,
fnd_request_group_units rgu,
fnd_concurrent_programs cp,
FND_CONCURRENT_PROGRAMS_TL CPT
WHERE rg.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND cpt.user_concurrent_program_name =:p_conc_prog_name;
D1A13514
ReplyDeleteForum
Forum
Forum
Forum
Forum
Forum
Forum
Forum
Forum
3722DFC5
ReplyDeleteMuratpaşa
Çubuk
Side
Çatalca
Karesi
Şile
İnegöl
Şahinbey
Erciş
146508E8
ReplyDeleteAkyaka
Dinar
Erdek
Silivri
Ağva
Reyhanlı
Finike
Birecik
Cizre
Konak
ReplyDeleteAltındağ
Çatalca
Gölcük
Darıca
Narlıdere
Seferihisar
Körfez
Dilovası