Version : 10609

DB : MSSQL / PGSQL

OUTPUT:

Query:

select servicedefinition.serviceid as "Service Category Id",

servicedefinition.name as "Service Category",
servicedefinition.description as "Service category Description",

requesttemplate_list.templatename as "Service Name",

requesttemplate_list.COMMENTS as "Service Description",

cdef.categoryname "Category",
subcdef.name "subcategory",
itemdef.name "Item",

requesttemplate_list.templateid "Template ID" from servicedefinition

left join requesttemplate_list on servicedefinition.serviceid = requesttemplate_list.parent_service

left join servicetempaccmapping sta on requesttemplate_list.templateid = sta.templateid

left join accountdefinition adef on sta.accountid=adef.org_id

left join reqtempaccountmapping reqtem on requesttemplate_list.templateid = reqtem.templateid

left join accountdefinition reqtemadef on reqtem.accountid=adef.org_id

left join sladefinition on sta.slaid = sladefinition.slaid

left join requesttemplate_fields rtf on rtf.templateid=requesttemplate_list.templateid

left join categorydefinition cdef on rtf.categoryid=cdef.categoryid
left join subcategorydefinition subcdef on cdef.categoryid=subcdef.categoryid
left join itemdefinition itemdef on subcdef.subcategoryid=itemdef.subcategoryid

where  requesttemplate_list.IS_CATALOG_TEMPLATE = 'true' and requesttemplate_list.status='ACTIVE'
order by 1