SELECT * FROM apps.
fnd_concurrent_programs_vl WHERE
user_concurrent_program_name='Netgear CEP Prosupport Envelope for Creating Sales
Order';
SELECT * FROM apps.fnd_concurrent_programs_vl WHERE
user_concurrent_program_name='Netgear CEP Generate License for ProSupport Sales
Order Lines';
CONCURRENT_PROGRAM_ID= 545789 XXNTGRCEPENVLICGEN
SELECT * FROM apps.fnd_concurrent_requests WHERE CONCURRENT_PROGRAM_ID= 545789
SELECT * FROM apps.FND_RESPONSIBILITY_TL WHERE RESPONSIBILITY_ID IN
(50657,50653);
Order Management Super User -International
Order Management Super User -US
SELECT e.responsibility_name, c.user_concurrent_program_name,
a.request_group_name
FROM
apps.FND_REQUEST_GROUPS a,
apps.FND_REQUEST_GROUP_UNITS b,
apps.fnd_concurrent_programs_tl c,
apps.FND_RESPONSIBILITY_VL d,
apps.FND_RESPONSIBILITY_tL e
WHERE a.request_group_id = b.request_group_id
AND c.user_concurrent_program_name ='Netgear CEP Prosupport Envelope for Creating
Sales Order'
AND d.REQUEST_GROUP_ID = a.REQUEST_GROUP_ID
AND d.responsibility_id = e.responsibility_id
AND b.request_unit_id = c.concurrent_program_id;
SELECT e.responsibility_name, c.user_concurrent_program_name, a.request_group_name
FROM
apps.FND_REQUEST_GROUPS a,
apps.FND_REQUEST_GROUP_UNITS b,
apps.fnd_concurrent_programs_tl c,
apps.FND_RESPONSIBILITY_VL d,
apps.FND_RESPONSIBILITY_tL e
WHERE a.request_group_id = b.request_group_id
AND c.user_concurrent_program_name ='Netgear CEP Generate License for ProSupport
Sales Order Lines'
AND d.REQUEST_GROUP_ID = a.REQUEST_GROUP_ID
AND d.responsibility_id = e.responsibility_id
AND b.request_unit_id = c.concurrent_program_id;
SELECT fl.meaning
, fu.user_name
, fu.description
, fu.end_date
, NVL(fu.email_address, 'n/a') email_address
, fcr.request_id
, fcr.number_of_copies
, fcr.printer
, fcr.request_date
, fcr.requested_start_date
, fcp.description
, fcr.argument_text
, frt.responsibility_name
FROM apps.fnd_concurrent_requests fcr
, apps.fnd_user fu
, apps.fnd_lookups fl
, apps.fnd_concurrent_programs_vl fcp
, apps.fnd_responsibility_tl frt
WHERE fcr.requested_by = fu.user_id
AND fl.lookup_type = 'CP_STATUS_CODE'
AND fcr.status_code = fl.lookup_code
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.responsibility_id = frt.responsibility_id
AND fcr.phase_code = 'P'
-- AND fcp.user_concurrent_program_name ='Netgear CEP Generate License for
ProSupport Sales Order Lines';
AND fcp.user_concurrent_program_name ='Netgear CEP Prosupport Envelope for
Creating Sales Order';
SELECT * FROM apps.fnd_concurrent_requests WHERE request_id=60426723;
SELECT * FROM apps.FND_RESPONSIBILITY_TL WHERE RESPONSIBILITY_ID IN
(21623);
Order Management
Super User
60420623
60404835 60404905
