超越 Oracle EBS

超越 Oracle EBS


DROP TABLE CUX.XX_AP_INVOICES_ALL CASCADE CONSTRAINTS;

CREATE TABLE CUX.XX_AP_INVOICES_ALL
(
  ORG_ID                    NUMBER(15),
  LAST_UPDATE_DATE          DATE                NOT NULL,
  LAST_UPDATED_BY           NUMBER              NOT NULL,
  CREATION_DATE             DATE                NOT NULL,
  CREATED_BY                NUMBER              NOT NULL,
)

COMMENT ON COLUMN CUX.XX_AP_INVOICES_ALL.SALES_NAME IS '20111229由80改為240';


CREATE INDEX CUX.XX_AP_INVOICES_ALL_N1 ON CUX.XX_AP_INVOICES_ALL
(BATCH_ID, HEADER_ID)

CREATE INDEX CUX.XX_AP_INVOICES_ALL_N2 ON CUX.XX_AP_INVOICES_ALL
(PREPAYMENT_INV_ID)

DROP SYNONYM APPS.XX_AP_INVOICES_ALL;

CREATE SYNONYM APPS.XX_AP_INVOICES_ALL FOR CUX.XX_AP_INVOICES_ALL;


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