CREATE TABLE CUX.XX_APS_ITEM_CONFIG

CREATE TABLE CUX.XX_APS_ITEM_CONFIG
(
  INVENTORY_ITEM_ID   NUMBER,
  PRODUCT_LINE        VARCHAR2(2 BYTE),
  DEMANTRA_ITEM_TYPE  VARCHAR2(1 BYTE),
  CREATION_DATE       DATE,
  CREATED_BY          NUMBER,
  LAST_UPDATE_LOGIN   NUMBER,
  LAST_UPDATED_BY     NUMBER,
  LAST_UPDATE_DATE    DATE
)

CREATE INDEX CUX.XX_APS_ITEM_CONFIG_N1 ON CUX.XX_APS_ITEM_CONFIG
(INVENTORY_ITEM_ID)

DROP SYNONYM APPS.XX_APS_ITEM_CONFIG;

CREATE SYNONYM APPS.XX_APS_ITEM_CONFIG FOR CUX.XX_APS_ITEM_CONFIG;

GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON CUX.XX_APS_ITEM_CONFIG TO APPS;