﻿<?xml version="1.0"?>
<objects xmlns="http://www.springframework.net"
				 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
				 xmlns:quartz="http://www.opensymphony.com/quartz/JobSchedulingData"
				 xsi:schemaLocation="http://www.springframework.net http://www.springframework.net/xsd/spring-objects.xsd" >
  <object type="Sleis.Export.ExportGroup" id="AgencyReleasePointExport">
    <property name="Name" value="Agency_ReleasePoint">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="ReleasePoints" value="SELECT
	                                          rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                          rp.REL_PT_DESC AS REL_PT_DESC,
	                                          rpt.REL_PT_TYPE_DESC AS REL_PT_TYPE_DESC,
	                                          rps.REL_PT_STAT_DESC AS REL_PT_STATUS,
	                                          rp.REL_PT_STAT_CD_DATE AS REL_PT_STATUS_DATE,
	                                          rp.REL_PT_STK_HGT_MEAS AS REL_PT_STK_HGT_MEAS,
	                                          shu.STD_UOM_DESC AS REL_PT_STK_HGT_UOM,
	                                          rp.REL_PT_STK_DIA_MEAS AS REL_PT_STK_DIA_MEAS,
	                                          sdu.STD_UOM_DESC AS REL_PT_STK_DIA_UOM,
	                                          rp.REL_PT_FGTV_HGT_MEAS AS REL_PT_FGTV_HGT_MEAS,
	                                          fhu.STD_UOM_DESC AS REL_PT_FGTV_HGT_UOM,
	                                          rp.REL_PT_FGTV_WID_MEAS AS REL_PT_FGTV_WID_MEAS,
	                                          fwu.STD_UOM_DESC AS REL_PT_FGTV_WID_UOM,
	                                          rp.REL_PT_FGTV_LEN_MEAS AS REL_PT_FGTV_LEN_MEAS,
	                                          fwu.STD_UOM_DESC AS REL_PT_FGTV_LEN_UOM,
	                                          rp.REL_PT_FGTV_ANGLE_MEAS AS REL_PT_FGTV_ANGLE_MEAS,
	                                          rp.REL_PT_EXIT_GAS_TMP_MEAS AS REL_PT_EXIT_GAS_TMP_MEAS,
	                                          rp.REL_PT_GAS_FLOW_RATE_MEAS AS REL_PT_GAS_FLOW_RATE_MEAS,
	                                          gfru.REL_PT_GAS_FLOW_RATE_DESC AS REL_PT_GAS_FLOW_RATE_UOM,
	                                          rp.REL_PT_GAS_VEL_MEAS AS REL_PT_GAS_VEL_MEAS,
	                                          gvu.REL_PT_GAS_VEL_UOM_DESC AS REL_PT_GAS_VEL_UOM,
	                                          rp.REL_PT_FNC_LINE_DIST_MEAS AS REL_PT_FNC_LINE_DIST_MEAS,
	                                          fldu.STD_UOM_DESC AS REL_PT_FNC_LINE_DIST_UOM,
	                                          rp.REL_PT_CMNT AS REL_PT_CMNT,
	                                          CASE rp.FAC_SITE_LOC_IND
		                                          WHEN 1 THEN 'Yes'
		                                          WHEN 0 Then 'No'
	                                          END AS USE_FAC_SITE_LOC_FLAG,
	                                          rp.LAT_MEAS AS LAT_MEAS,
	                                          rp.LONG_MEAS AS LONG_MEAS,
	                                          rp.UTM_EASTING AS UTM_EASTING,
	                                          rp.UTM_NORTHING AS UTM_NORTHING,
	                                          rp.UTM_ZONE AS UTM_ZONE,
	                                          hcm.HORZ_COLL_MTHD_DESC AS HORZ_COLL_MTHD_DESC,
	                                          rp.DATA_COLL_DATE AS COLL_DATE,
	                                          grp.GEO_REF_PT_DESC AS GEO_REF_PT_DESC,
	                                          hrd.HORZ_REF_DATUM_DESC AS HORZ_REF_DATUM_DESC
                                          FROM
	                                          M_REL_PT rp
	                                          INNER JOIN M_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
	                                          INNER JOIN M_AGN_RPT ar ON fs.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                          INNER JOIN E_REL_PT_TYPE rpt ON rp.E_REL_PT_TYPE_CD = rpt.E_REL_PT_TYPE_CD
	                                          INNER JOIN E_REL_PT_STAT rps ON rp.E_REL_PT_STAT_CD = rps.E_REL_PT_STAT_CD	
	
	                                          LEFT JOIN A_STD_UOM shu ON rp.REL_PT_STK_HGT_UOM_CD = shu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM sdu ON rp.REL_PT_STK_DIA_UOM_CD = sdu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM fhu ON rp.REL_PT_FGTV_HGT_UOM_CD = fhu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM fwu ON rp.REL_PT_FGTV_WID_UOM_CD = fwu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM flu ON rp.REL_PT_FGTV_LEN_UOM_CD = flu.A_STD_UOM_CD
	                                          LEFT JOIN E_REL_PT_GAS_FLOW_RATE_UOM gfru ON rp.E_REL_PT_GAS_FLOW_RATE_UOM_CD = gfru.E_REL_PT_GAS_FLOW_RATE_UOM_CD
	                                          LEFT JOIN E_REL_PT_GAS_VEL_UOM gvu ON rp.E_REL_PT_GAS_VEL_UOM_CD = gvu.E_REL_PT_GAS_VEL_UOM_CD
	                                          LEFT JOIN A_STD_UOM fldu ON rp.REL_PT_FNC_LINE_DIST_UOM_CD = fldu.A_STD_UOM_CD
	                                          LEFT JOIN E_HORZ_COLL_MTHD hcm ON rp.E_HORZ_COLL_MTHD_CD = hcm.E_HORZ_COLL_MTHD_CD
	                                          LEFT JOIN E_GEO_REF_PT grp ON rp.E_GEO_REF_PT_CD = grp.E_GEO_REF_PT_CD
	                                          LEFT JOIN E_HORZ_REF_DATUM hrd ON rp.E_HORZ_REF_DATUM_CD = hrd.E_HORZ_REF_DATUM_CD
                                          WHERE
	                                          ar.AGN_RPT_ID = :reportId --current report being reported on
                                          ORDER BY
	                                          rp.REL_PT_IDEN ASC" />
        <entry key="AdditionalInformation" value="SELECT
	                                                  rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                                  rp.REL_PT_DESC AS REL_PT_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  M_REL_PT_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN M_REL_PT rp ON cfv.REL_PT_ID = rp.REL_PT_ID
	                                                  INNER JOIN M_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
	                                                  INNER JOIN M_AGN_RPT ar ON fs.AGN_RPT_ID = ar.AGN_RPT_ID
                                                  WHERE
	                                                  ar.AGN_RPT_ID = :reportId --current report being reported
                                                  ORDER BY
	                                                  rp.REL_PT_IDEN ASC,
	                                                  cf.FLD_LABEL ASC" />

      </dictionary>
    </property>
  </object>
  <object type="Sleis.Export.ExportGroup" id="MasterReleasePointExport">
    <property name="Name" value="Master_ReleasePoint">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="ReleasePoints" value="SELECT
	                                          rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                          rp.REL_PT_DESC AS REL_PT_DESC,
	                                          rpt.REL_PT_TYPE_DESC AS REL_PT_TYPE_DESC,
	                                          rps.REL_PT_STAT_DESC AS REL_PT_STATUS,
	                                          rp.REL_PT_STAT_CD_DATE AS REL_PT_STATUS_DATE,
	                                          rp.REL_PT_STK_HGT_MEAS AS REL_PT_STK_HGT_MEAS,
	                                          shu.STD_UOM_DESC AS REL_PT_STK_HGT_UOM,
	                                          rp.REL_PT_STK_DIA_MEAS AS REL_PT_STK_DIA_MEAS,
	                                          sdu.STD_UOM_DESC AS REL_PT_STK_DIA_UOM,
	                                          rp.REL_PT_FGTV_HGT_MEAS AS REL_PT_FGTV_HGT_MEAS,
	                                          fhu.STD_UOM_DESC AS REL_PT_FGTV_HGT_UOM,
	                                          rp.REL_PT_FGTV_WID_MEAS AS REL_PT_FGTV_WID_MEAS,
	                                          fwu.STD_UOM_DESC AS REL_PT_FGTV_WID_UOM,
	                                          rp.REL_PT_FGTV_LEN_MEAS AS REL_PT_FGTV_LEN_MEAS,
	                                          fwu.STD_UOM_DESC AS REL_PT_FGTV_LEN_UOM,
	                                          rp.REL_PT_FGTV_ANGLE_MEAS AS REL_PT_FGTV_ANGLE_MEAS,
	                                          rp.REL_PT_EXIT_GAS_TMP_MEAS AS REL_PT_EXIT_GAS_TMP_MEAS,
	                                          rp.REL_PT_GAS_FLOW_RATE_MEAS AS REL_PT_GAS_FLOW_RATE_MEAS,
	                                          gfru.REL_PT_GAS_FLOW_RATE_DESC AS REL_PT_GAS_FLOW_RATE_UOM,
	                                          rp.REL_PT_GAS_VEL_MEAS AS REL_PT_GAS_VEL_MEAS,
	                                          gvu.REL_PT_GAS_VEL_UOM_DESC AS REL_PT_GAS_VEL_UOM,
	                                          rp.REL_PT_FNC_LINE_DIST_MEAS AS REL_PT_FNC_LINE_DIST_MEAS,
	                                          fldu.STD_UOM_DESC AS REL_PT_FNC_LINE_DIST_UOM,
	                                          rp.REL_PT_CMNT AS REL_PT_CMNT,
	                                          CASE rp.FAC_SITE_LOC_IND
		                                          WHEN 1 THEN 'Yes'
		                                          WHEN 0 Then 'No'
	                                          END AS USE_FAC_SITE_LOC_FLAG,
	                                          rp.LAT_MEAS AS LAT_MEAS,
	                                          rp.LONG_MEAS AS LONG_MEAS,
	                                          rp.UTM_EASTING AS UTM_EASTING,
	                                          rp.UTM_NORTHING AS UTM_NORTHING,
	                                          rp.UTM_ZONE AS UTM_ZONE,
	                                          hcm.HORZ_COLL_MTHD_DESC AS HORZ_COLL_MTHD_DESC,
	                                          rp.DATA_COLL_DATE AS COLL_DATE,
	                                          grp.GEO_REF_PT_DESC AS GEO_REF_PT_DESC,
	                                          hrd.HORZ_REF_DATUM_DESC AS HORZ_REF_DATUM_DESC
                                          FROM
	                                          M_REL_PT rp
	                                          INNER JOIN M_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
	                                          INNER JOIN E_REL_PT_TYPE rpt ON rp.E_REL_PT_TYPE_CD = rpt.E_REL_PT_TYPE_CD
	                                          INNER JOIN E_REL_PT_STAT rps ON rp.E_REL_PT_STAT_CD = rps.E_REL_PT_STAT_CD
	                                          LEFT JOIN A_STD_UOM shu ON rp.REL_PT_STK_HGT_UOM_CD = shu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM sdu ON rp.REL_PT_STK_DIA_UOM_CD = sdu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM fhu ON rp.REL_PT_FGTV_HGT_UOM_CD = fhu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM fwu ON rp.REL_PT_FGTV_WID_UOM_CD = fwu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM flu ON rp.REL_PT_FGTV_LEN_UOM_CD = flu.A_STD_UOM_CD
	                                          LEFT JOIN E_REL_PT_GAS_FLOW_RATE_UOM gfru ON rp.E_REL_PT_GAS_FLOW_RATE_UOM_CD = gfru.E_REL_PT_GAS_FLOW_RATE_UOM_CD
	                                          LEFT JOIN E_REL_PT_GAS_VEL_UOM gvu ON rp.E_REL_PT_GAS_VEL_UOM_CD = gvu.E_REL_PT_GAS_VEL_UOM_CD
	                                          LEFT JOIN A_STD_UOM fldu ON rp.REL_PT_FNC_LINE_DIST_UOM_CD = fldu.A_STD_UOM_CD
	                                          LEFT JOIN E_HORZ_COLL_MTHD hcm ON rp.E_HORZ_COLL_MTHD_CD = hcm.E_HORZ_COLL_MTHD_CD
	                                          LEFT JOIN E_GEO_REF_PT grp ON rp.E_GEO_REF_PT_CD = grp.E_GEO_REF_PT_CD
	                                          LEFT JOIN E_HORZ_REF_DATUM hrd ON rp.E_HORZ_REF_DATUM_CD = hrd.E_HORZ_REF_DATUM_CD
                                          WHERE
	                                          fs.FAC_SITE_ID = :facilityId
	                                          AND fs.FAC_SITE_MSTR_IND = 1
                                          ORDER BY
	                                          rp.REL_PT_IDEN ASC" />
        <entry key="AdditionalInformation" value="SELECT
	                                                  rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                                  rp.REL_PT_DESC AS REL_PT_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  M_REL_PT_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN M_REL_PT rp ON cfv.REL_PT_ID = rp.REL_PT_ID
	                                                  INNER JOIN M_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
                                                  WHERE
	                                                  fs.FAC_SITE_ID = :facilityId --current facility
	                                                  AND fs.FAC_SITE_MSTR_IND = 1
                                                  ORDER BY
	                                                  rp.REL_PT_IDEN ASC,
	                                                  cf.FLD_LABEL ASC" />
        <entry key="Identifiers" value="SELECT
	                                        rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                        rp.REL_PT_DESC AS REL_PT_DESC,
	                                        rpi.REL_PT_IDEN AS ALT_REL_PT_IDEN,
	                                        rpi.A_PROG_SYS_CD AS ALT_REL_PT_IDEN_SYS_CD,
	                                        rpi.EFF_DATE AS ALT_REL_PT_IDEN_EFF_DATE
                                        FROM
	                                        M_REL_PT_IDEN rpi
	                                        INNER JOIN M_REL_PT rp ON rpi.REL_PT_ID = rp.REL_PT_ID
	                                        INNER JOIN M_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
                                        WHERE
	                                        fs.FAC_SITE_ID = :facilityId --current facility
	                                        AND fs.FAC_SITE_MSTR_IND = 1
                                        ORDER BY
	                                        rp.REL_PT_IDEN ASC" />
        <entry key="Comments" value="SELECT
	                                      rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                      rp.REL_PT_DESC AS REL_PT_DESC,
	                                      rpc.CMNT_TXT,
	                                      CASE 
		                                      WHEN rpc.CMNT_BY_USER_ID IS NULL THEN 'Agency Editor'
		                                      ELSE s.USER_FULL_NAME
	                                      END AS CMNT_BY,
	                                      rpc.CMNT_DATE AS CMNT_DATE
                                      FROM
	                                      M_REL_PT_CMNT rpc
	                                      INNER JOIN M_REL_PT rp ON rpc.REL_PT_ID = rp.REL_PT_ID
	                                      INNER JOIN M_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
	
	                                      LEFT JOIN SEC_USER s ON rpc.CMNT_BY_USER_ID = s.SEC_USER_ID
                                      WHERE
	                                      fs.FAC_SITE_ID = :facilityId --current facility
	                                      AND fs.FAC_SITE_MSTR_IND = 1
                                      ORDER BY
	                                      rp.REL_PT_IDEN ASC" />

      </dictionary>
    </property>
  </object>
  <object type="Sleis.Export.ExportGroup" id="PublicReleasePointExport">
    <property name="Name" value="Public_ReleasePoint">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="ReleasePoints" value="SELECT
	                                          rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                          rp.REL_PT_DESC AS REL_PT_DESC,
	                                          rpt.REL_PT_TYPE_DESC AS REL_PT_TYPE_DESC,
	                                          rps.REL_PT_STAT_DESC AS REL_PT_STATUS,
	                                          rp.REL_PT_STAT_CD_DATE AS REL_PT_STATUS_DATE,
	                                          rp.REL_PT_STK_HGT_MEAS AS REL_PT_STK_HGT_MEAS,
	                                          shu.STD_UOM_DESC AS REL_PT_STK_HGT_UOM,
	                                          rp.REL_PT_STK_DIA_MEAS AS REL_PT_STK_DIA_MEAS,
	                                          sdu.STD_UOM_DESC AS REL_PT_STK_DIA_UOM,
	                                          rp.REL_PT_FGTV_HGT_MEAS AS REL_PT_FGTV_HGT_MEAS,
	                                          fhu.STD_UOM_DESC AS REL_PT_FGTV_HGT_UOM,
	                                          rp.REL_PT_FGTV_WID_MEAS AS REL_PT_FGTV_WID_MEAS,
	                                          fwu.STD_UOM_DESC AS REL_PT_FGTV_WID_UOM,
	                                          rp.REL_PT_FGTV_LEN_MEAS AS REL_PT_FGTV_LEN_MEAS,
	                                          fwu.STD_UOM_DESC AS REL_PT_FGTV_LEN_UOM,
	                                          rp.REL_PT_FGTV_ANGLE_MEAS AS REL_PT_FGTV_ANGLE_MEAS,
	                                          rp.REL_PT_EXIT_GAS_TMP_MEAS AS REL_PT_EXIT_GAS_TMP_MEAS,
	                                          rp.REL_PT_GAS_FLOW_RATE_MEAS AS REL_PT_GAS_FLOW_RATE_MEAS,
	                                          gfru.REL_PT_GAS_FLOW_RATE_DESC AS REL_PT_GAS_FLOW_RATE_UOM,
	                                          rp.REL_PT_GAS_VEL_MEAS AS REL_PT_GAS_VEL_MEAS,
	                                          gvu.REL_PT_GAS_VEL_UOM_DESC AS REL_PT_GAS_VEL_UOM,
	                                          rp.REL_PT_FNC_LINE_DIST_MEAS AS REL_PT_FNC_LINE_DIST_MEAS,
	                                          fldu.STD_UOM_DESC AS REL_PT_FNC_LINE_DIST_UOM,
	                                          rp.REL_PT_CMNT AS REL_PT_CMNT,
	                                          CASE rp.FAC_SITE_LOC_IND
		                                          WHEN 1 THEN 'Yes'
		                                          WHEN 0 Then 'No'
	                                          END AS USE_FAC_SITE_LOC_FLAG,
	                                          rp.LAT_MEAS AS LAT_MEAS,
	                                          rp.LONG_MEAS AS LONG_MEAS,
	                                          rp.UTM_EASTING AS UTM_EASTING,
	                                          rp.UTM_NORTHING AS UTM_NORTHING,
	                                          rp.UTM_ZONE AS UTM_ZONE,
	                                          hcm.HORZ_COLL_MTHD_DESC AS HORZ_COLL_MTHD_DESC,
	                                          rp.DATA_COLL_DATE AS COLL_DATE,
	                                          grp.GEO_REF_PT_DESC AS GEO_REF_PT_DESC,
	                                          hrd.HORZ_REF_DATUM_DESC AS HORZ_REF_DATUM_DESC
                                          FROM
	                                          P_REL_PT rp
	                                          INNER JOIN P_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
	                                          INNER JOIN P_FAC_EMIS_RPT fer ON fs.FAC_EMIS_RPT_ID = fer.FAC_EMIS_RPT_ID
	                                          INNER JOIN M_AGN_RPT ar ON fer.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                          INNER JOIN E_REL_PT_TYPE rpt ON rp.E_REL_PT_TYPE_CD = rpt.E_REL_PT_TYPE_CD
	                                          INNER JOIN E_REL_PT_STAT rps ON rp.E_REL_PT_STAT_CD = rps.E_REL_PT_STAT_CD	
	
	                                          LEFT JOIN A_STD_UOM shu ON rp.REL_PT_STK_HGT_UOM_CD = shu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM sdu ON rp.REL_PT_STK_DIA_UOM_CD = sdu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM fhu ON rp.REL_PT_FGTV_HGT_UOM_CD = fhu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM fwu ON rp.REL_PT_FGTV_WID_UOM_CD = fwu.A_STD_UOM_CD
	                                          LEFT JOIN A_STD_UOM flu ON rp.REL_PT_FGTV_LEN_UOM_CD = flu.A_STD_UOM_CD
	                                          LEFT JOIN E_REL_PT_GAS_FLOW_RATE_UOM gfru ON rp.E_REL_PT_GAS_FLOW_RATE_UOM_CD = gfru.E_REL_PT_GAS_FLOW_RATE_UOM_CD
	                                          LEFT JOIN E_REL_PT_GAS_VEL_UOM gvu ON rp.E_REL_PT_GAS_VEL_UOM_CD = gvu.E_REL_PT_GAS_VEL_UOM_CD
	                                          LEFT JOIN A_STD_UOM fldu ON rp.REL_PT_FNC_LINE_DIST_UOM_CD = fldu.A_STD_UOM_CD
	                                          LEFT JOIN E_HORZ_COLL_MTHD hcm ON rp.E_HORZ_COLL_MTHD_CD = hcm.E_HORZ_COLL_MTHD_CD
	                                          LEFT JOIN E_GEO_REF_PT grp ON rp.E_GEO_REF_PT_CD = grp.E_GEO_REF_PT_CD
	                                          LEFT JOIN E_HORZ_REF_DATUM hrd ON rp.E_HORZ_REF_DATUM_CD = hrd.E_HORZ_REF_DATUM_CD
                                          WHERE
	                                          ar.AGN_RPT_ID = :reportId --current report being reported on
                                          ORDER BY
	                                          rp.REL_PT_IDEN ASC
                                          " />
        <entry key="AdditionalInformation" value="SELECT
	                                                  rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                                  rp.REL_PT_DESC AS REL_PT_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  P_REL_PT_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN P_REL_PT rp ON cfv.REL_PT_ID = rp.REL_PT_ID
	                                                  INNER JOIN P_FAC_SITE fs ON rp.FAC_SITE_ID = fs.FAC_SITE_ID
	                                                  INNER JOIN P_FAC_EMIS_RPT fer ON fs.FAC_EMIS_RPT_ID = fer.FAC_EMIS_RPT_ID
	                                                  INNER JOIN M_AGN_RPT ar ON fer.AGN_RPT_ID = ar.AGN_RPT_ID
                                                  WHERE
	                                                  ar.AGN_RPT_ID = :reportId --current report being reported
                                                  ORDER BY
	                                                  rp.REL_PT_IDEN ASC,
	                                                  cf.FLD_LABEL ASC" />

      </dictionary>
    </property>
  </object>
</objects>
