--ENSURE NDC_1 SCRIPT HAS BEEN RUN FIRST TO CREATE TEMP_EPL_NDCS TABLE BEFORE RUNNING UPDATE!!--

DROP TABLE ppsnepl.epl_package_sizes;

CREATE TABLE ppsnepl.epl_package_sizes
(
   epl_id                 NUMBER (30, 0) NOT NULL ENABLE
  ,package_size           NUMBER (13, 6) NOT NULL ENABLE
  ,ndf_package_size_ien   NUMBER (30, 0)
  ,created_by             VARCHAR2 (50 BYTE) NOT NULL ENABLE
  ,created_dtm            TIMESTAMP (6) NOT NULL ENABLE
  ,last_modified_by       VARCHAR2 (50 BYTE)
  ,last_modified_dtm      TIMESTAMP (6)
)
TABLESPACE ppsnepl_data;

CREATE UNIQUE INDEX ppsnepl.epl_package_sizes_pki
   ON ppsnepl.epl_package_sizes (epl_id)
TABLESPACE ppsnepl_data;

ALTER TABLE ppsnepl.epl_package_sizes ADD (
  CONSTRAINT epl_package_sizes_pk
  PRIMARY KEY   (epl_id)
  USING INDEX ppsnepl.epl_package_sizes_pki
  ENABLE VALIDATE);