Friday, October 26, 2012

To get list of responsibilities.





SELECT (SELECT application_short_name
FROM fnd_application fa
WHERE fa.application_id = frt.application_id) application,
frt.responsibility_id, frt.responsibility_name
FROM apps.fnd_responsibility_tl frt;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect