Edi Yanto (何 萬 新)

SELECT frv.responsibility_name name, frv.start_date, frv.end_date
FROM apps.fnd_user_resp_groups furg,
apps.fnd_responsibility_vl frv,
apps.fnd_user fu
WHERE furg.user_id = fu.user_id
AND fu.user_id = (SELECT user_id
FROM fnd_user
WHERE user_name = UPPER(:p_user_name))
AND furg.responsibility_id = frv.responsibility_id
AND furg.responsibility_application_id = frv.application_id

SELECT DECODE (multi_org_flag,
‘Y’, ‘Multi-Org Enabled’,
‘Multi-Org Disabled’
)
FROM fnd_product_groups;

SELECT DISTINCT RPAD (ad.bug_number, 11) “Bug Number”,
RPAD (app.patch_name, 11) “Patch Name”,
RPAD (TRUNC (apr.end_date), 12) “End Date”,
RPAD (aprb.applied_flag, 4) “Applied?”
FROM ad_bugs ad,
ad_patch_run_bugs aprb,
ad_patch_runs apr,
ad_patch_drivers apd,
ad_applied_patches app
WHERE ad.bug_id = aprb.bug_id
AND aprb.patch_run_id = apr.patch_run_id
AND apr.patch_driver_id = apd.patch_driver_id
AND apd.applied_patch_id = app.applied_patch_id
AND ad.bug_number = nvl(:p_bug_number,ad.bug_number)
ORDER BY 1 DESC;