Friday 16 August 2013

Query to findout Request Set name form CP?

SELECT frst.user_request_set_name request_set,frst.description description,frsst.user_stage_name stage_name,frsst.description stage_descriptionFROM apps.fnd_request_sets_tl frst,apps.fnd_request_set_stages_tl frsstWHERE frst.application_id =frsst.set_application_idAND frst.request_set_id = frsst.request_set_idAND frsst.user_stage_name like '%Program_name%'

No comments:

Post a Comment