Seismic_Entl_Itm_N_Shape

CREATE OR REPLACE FORCE VIEW Seismic_Entl_Itm_N_Shape(ENTITLEMENT_NAME, JOB_NUMBER, LICENSE_ID, RECEIVER_ID, SELECTOR_ID, DATE_ISSUED, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, EXISTENCE_KIND, GUID, ID, VERSION, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, ACQUISITION_2D_ID, ACQUISITION_3D_ID, GEOPHYSICAL_INVENTORY_ID, SEISMIC_DATASET_ID, SEISMIC_LINE_ID, SURVEY_3D_ID, ENTITLEMENT_ID, LICENSE_ENTITY_DESCRIPTION, LICENSE_ENTITY_ID, LICENSE_ENTITY_NAME, INSERT_DATE, INSERT_USER, SHAPE) AS SELECT SEISMIC_ENTLMNT.NAME,
          SEISMIC_ENTLMNT.job_number,
          SEISMIC_ENTLMNT.license_id,
          SEISMIC_ENTLMNT.receiver_id,
          SEISMIC_ENTLMNT.selector_id,
          SEISMIC_ENTLMNT.date_issued,
          SEISMIC_ENTLMNT_ITEM.produced_by,
          SEISMIC_ENTLMNT_ITEM.sdat_label,
          SEISMIC_ENTLMNT_ITEM.update_date,
          SEISMIC_ENTLMNT_ITEM.update_user,
          SEISMIC_ENTLMNT_ITEM.existence_kind,
          SEISMIC_ENTLMNT_ITEM.guid,
          
SEISMIC_ENTLMNT.ID,
          SEISMIC_ENTLMNT_ITEM.VERSION,
          SEISMIC_ENTLMNT_ITEM.NAME,
          SEISMIC_ENTLMNT_ITEM.original_source,
          SEISMIC_ENTLMNT_ITEM.remarks,
          SEISMIC_ENTLMNT_ITEM.SOURCE,
          SEISMIC_ENTLMNT_ITEM.acquisition_2d_id,
          SEISMIC_ENTLMNT_ITEM.acquisition_3d_id,
          SEISMIC_ENTLMNT_ITEM.geophysical_inventory_id,
          SEISMIC_ENTLMNT_ITEM.seismic_dataset_id,
          SEISMIC_ENTLMNT_ITEM.seismic_line_id,
          SEISMIC_ENTLMNT_ITEM.survey_3d_id,
          SEISMIC_ENTLMNT_ITEM.entitlement_id,
          SEISMIC_ENTLMNT_ITEM.license_entity_description,
          SEISMIC_ENTLMNT_ITEM.license_entity_id,
          SEISMIC_ENTLMNT_ITEM.license_entity_name,
          SEISMIC_ENTLMNT_ITEM.insert_date,
          SEISMIC_ENTLMNT_ITEM.insert_user,
          AREA.shape
     FROM SEISMIC_ENTLMNT,
          SEISMIC_ENTLMNT_ITEM,
          SEISMIC_ENTLMNT_BOUNDARY,
          AREA
    WHERE SEISMIC_ENTLMNT.ID = 
SEISMIC_ENTLMNT_ITEM.ENTITLEMENT_ID(+)
      AND SEISMIC_ENTLMNT_ITEM.ID = SEISMIC_ENTLMNT_BOUNDARY.ENTITLEMENT_ITEM_ID(+)
      AND SEISMIC_ENTLMNT_BOUNDARY.POLYGON_GEOMETRY_ID = AREA.ID(+)