CREATE GLOBAL TEMPORARY TABLE CAPBATABC(
   CAP_ORD_NO    VARCHAR2(35) NOT NULL,
   CRD_NO        VARCHAR2(35) NOT NULL,
   NEW_CRD_NO    VARCHAR2(35) DEFAULT '',
   TXN_AMT       NUMBER(13,2) DEFAULT '',
   IN_OUT_SIGN   VARCHAR2(2)  DEFAULT '',
   TRSP_CD       VARCHAR2(4)  DEFAULT '',
   TTXN_ST       VARCHAR2(2)  DEFAULT '',
   TRSP_MSG      VARCHAR2(30) DEFAULT '',
   TM_SMP        VARCHAR2(26) DEFAULT SYSDATE not null,
CONSTRAINT CAPBATABC_PK PRIMARY KEY (CAP_ORD_NO,CRD_NO)
)
ON COMMIT PRESERVE ROWS;