What table in SQL holds the Location information for Request Offerings?

Version 1

    Details

    When in a Request Offering, the 4th tab shows the publishing information. What table in SQL corresponds to the "Location" (usually Default) that a particular Request Offering is published to?


     


    Resolution

    Request Offering published Location information is stored in the ServiceReqTemplateEntityAccess table. 


    ServiceReqTemplateEntityAccess joins the ServiceReqTemplate table (Request Offerings) via the ServiceReqTemplateLink_RecID field to the Location table via the FusionLink table. 

    On the FusionLink table, the Location's RecID is in the TargetID column.
    On the FusionLink table, the ServiceReqTemplateEntityAccess is referenced in the SourceID column.