Operation Details
Description: Reads all facilities that are NOT provided at the specified location based on the locale.
Sterotype: nsmulti
SQL 

SELECT
  code
INTO
  :typeCode 
FROM
  codetableitem 
WHERE tableName = :tablename 
  AND localeIdentifier= :localeCode
  AND isenabled = '1'
  AND code NOT in 
  ( 
  SELECT
    typeCode 
  FROM
    LocationFacilities 
  WHERE providerLocationID = :providerLocationID 
  )