CREATE TABLE cml_online_association_reqs (
    RUN_ID                         NUMBER(18, 0),
    INVOICE_ID                     NUMBER(18, 0),
    INVOICE_LINE_NUMBER            VARCHAR2(160),
    TROP_CHARGE_ID                 NUMBER(18, 0),
    ASSOC_INV_START_DATE           TIMESTAMP(6) ,
    ASSOC_INV_END_DATE             TIMESTAMP(6) ,
    ASSOC_INV_FOR_CODE             VARCHAR2(256),
    CHARGE_LINES_FOR_CODE          VARCHAR2(256),
    CHARGE_LINES_FOR_START_DATE    TIMESTAMP(6) ,
    CHARGE_LINES_FOR_END_DATE      TIMESTAMP(6) ,
    REVIEW_AUTO_ASSOC_FLAG         VARCHAR2(4)  ,
    INCL_CLOSED_TROP_FLAG          VARCHAR2(4)  ,
    INCL_INACTIVE_TROP_FLAG        VARCHAR2(4)  ,
    TIMEOUT                        NUMBER(9, 0)     NOT NULL,
    STATUS                         VARCHAR2(120)    NOT NULL,
    BLOCKING_RUN_ID                NUMBER(18, 0),
    TIMEOUT_RUN_ID                 NUMBER(18, 0),
    CREATED_BY                     VARCHAR2(256)    NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128),
    RUN_ID                         NUMBER(18, 0),
    INVOICE_ID                     NUMBER(18, 0),
    INVOICE_LINE_NUMBER            VARCHAR2(160),
    TROP_CHARGE_ID                 NUMBER(18, 0),
    ASSOC_INV_START_DATE           TIMESTAMP(6) ,
    ASSOC_INV_END_DATE             TIMESTAMP(6) ,
    ASSOC_INV_FOR_CODE             VARCHAR2(256),
    CHARGE_LINES_FOR_CODE          VARCHAR2(256),
    CHARGE_LINES_FOR_START_DATE    TIMESTAMP(6) ,
    CHARGE_LINES_FOR_END_DATE      TIMESTAMP(6) ,
    REVIEW_AUTO_ASSOC_FLAG         VARCHAR2(4)  ,
    INCL_CLOSED_TROP_FLAG          VARCHAR2(4)  ,
    INCL_INACTIVE_TROP_FLAG        VARCHAR2(4)  ,
    TIMEOUT                        NUMBER(9, 0)     NOT NULL,
    STATUS                         VARCHAR2(120)    NOT NULL,
    BLOCKING_RUN_ID                NUMBER(18, 0),
    TIMEOUT_RUN_ID                 NUMBER(18, 0),
    CREATED_BY                     VARCHAR2(256)    NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128),
    CONSTRAINT pk_cml_online_association_reqs PRIMARY KEY (RUN_ID, INVOICE_ID, INVOICE_LINE_NUMBER, TROP_CHARGE_ID, RUN_ID, INVOICE_ID, INVOICE_LINE_NUMBER, TROP_CHARGE_ID)
);
