Useful Oracle Apps Queries
Below are a list of SQL Queries that will be useful during your day to day activities. 1. Concurrent Programs Assigned to a Request Group SELECT fcpv.concurrent_program_name SHORT_NAME ,fcpv.user_concurrent_program_name CONC_PROG_NAME ,frg.request_group_name REQ_GROUP_NAME FROM fnd_concurrent_programs_vl fcpv ,fnd_request_groups frg ,fnd_request_group_units frgu WHERE fcpv.concurrent_program_id = frgu.request_unit_id AND fcpv.enabled_flag = ‘Y’ AND frgu.request_group_id = frg.request_group_id AND frg.request_group_name = ‘&request_group_name’; […]
XML Publisher Report from XML Data Template
How to develop a xml publisher report without using a rdf or sql or pl/sql concurrent program. We can do the same using xml data template as well.
This blog explains a simple xml publisher report developed using the xml data template.