--ABS-86015
ALTER TABLE SQ_WEEKLY_REVENUE ADD (INVOICELINETYPE_ID NUMBER DEFAULT NULL,
INVOICELINESUBTYPE NUMBER DEFAULT NULL);

ALTER TABLE SQ_WEEKLY_REVENUE
  DROP CONSTRAINT UK1_WEEKLY_REVENUE CASCADE;
ALTER TABLE SQ_WEEKLY_REVENUE
  ADD CONSTRAINT UK1_WEEKLY_REVENUE UNIQUE (INVOICEBUSINESSUNIT_ID, INVOICEYEAR, INVOICEWEEK, DELTOCUSTOMER_LINK_ID, TURNOVERGROUP_ID, INVOICELINE_CODE, INVOICELINE_DESC, SIZECODE, FINISHINGMETHODCODE, INVOICELINETYPE_ID, INVOICELINESUBTYPE);
ALTER TABLE SQ_WEEKLY_REVENUE
  DROP CONSTRAINT UK2_WEEKLY_REVENUE CASCADE;
ALTER TABLE SQ_WEEKLY_REVENUE
  ADD CONSTRAINT UK2_WEEKLY_REVENUE UNIQUE (INVOICEBUSINESSUNIT_ID, SQ_DATE, DELTOCUSTOMER_LINK_ID, TURNOVERGROUP_ID, INVOICELINE_CODE, INVOICELINE_DESC, SIZECODE, FINISHINGMETHODCODE, INVOICELINETYPE_ID, INVOICELINESUBTYPE);