TMACUL

CA SC::. Query select your request and details.

Blog Post created by TMACUL Champion on Jan 9, 2017


select request.request_id, subdet.offering_id, subdet.id,
offer.offering_name ,
item.form_elem_name, item.form_elem_value
from usm_request as request
inner join usm_subscription_detail as subdet on subdet.request_id = request.request_id
inner join usm_offering as offer on offer.offering_id = subdet.offering_id
inner join usm_request_item_form as item on item.subscription_detail_id = subdet.id
where request.request_id = 10207

 

Outcomes