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

CREATE INDEX ppsnepl.epl_ndc_pckg_size_fk_idx
   ON ppsnepl.epl_ndcs (package_size_id_fk);
--   TABLESPACE ppsnepl_data;

ALTER TABLE epl_ndcs ADD FOREIGN KEY(package_size_id_fk)
REFERENCES epl_package_sizes (epl_id);

DROP SEQUENCE ppsnepl.package_size_sequence;