How to generate a full listing of Request Group programs

I'm trying to take a seated request group and break it's programs into smaller request groups.  How do you generate a listing of programs in a request group that uses the type of "Application"?  I've tried various SQL's pulling all programs associated with an application but I cannot seem to get a listing that corresponds with what the users are seeing.  We are using EBS R12, the specific request group I'm trying to dissect is Cost Management - SLA , application = Bills of Material.