CREATE TABLE cjm_programs_utilized_stage (
    UTILIZATION_STAGE_ID           NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    UTILIZATION_ID                 NUMBER(18, 0) ,
    UTILIZATION_TYPE               VARCHAR2(120) ,
    ADJUSTMENT_TYPE                VARCHAR2(120) ,
    ADJUSTMENT_TYPE_ID             NUMBER(18, 0) ,
    VENDOR_ID                      NUMBER(18, 0) ,
    VENDOR_SITE_ID                 NUMBER(18, 0) ,
    VENDOR_NAME                    VARCHAR2(1440),
    VENDOR_SITE_CODE               VARCHAR2(960) ,
    PROGRAM_HEADER_ID              NUMBER(18, 0) ,
    ITEM_LEVEL_CODE                VARCHAR2(120) ,
    ITEM_ID                        NUMBER(18, 0) ,
    TRANSACTION_CURR_AMOUNT        NUMBER        ,
    TRANSACTION_CURR_AMOUNT_REM    NUMBER        ,
    TRANSACTION_CURRENCY_CODE      VARCHAR2(60)  ,
    ACCTD_AMOUNT                   NUMBER        ,
    ACCTD_AMOUNT_REMAINING         NUMBER        ,
    EXCHANGE_RATE_TYPE             VARCHAR2(120) ,
    EXCHANGE_RATE_DATE             DATE          ,
    EXCHANGE_RATE                  NUMBER        ,
    PROGRAM_AMOUNT                 NUMBER        ,
    PROGRAM_AMOUNT_REMAINING       NUMBER        ,
    PROGRAM_CURRENCY_CODE          VARCHAR2(60)  ,
    YEAR_ID                        NUMBER        ,
    SEEDED_PROGRAM_TYPE_CODE       VARCHAR2(120) ,
    UTILIZATION_STAGE_ID           NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    UTILIZATION_ID                 NUMBER(18, 0) ,
    UTILIZATION_TYPE               VARCHAR2(120) ,
    ADJUSTMENT_TYPE                VARCHAR2(120) ,
    ADJUSTMENT_TYPE_ID             NUMBER(18, 0) ,
    VENDOR_ID                      NUMBER(18, 0) ,
    VENDOR_SITE_ID                 NUMBER(18, 0) ,
    VENDOR_NAME                    VARCHAR2(1440),
    VENDOR_SITE_CODE               VARCHAR2(960) ,
    PROGRAM_HEADER_ID              NUMBER(18, 0) ,
    ITEM_LEVEL_CODE                VARCHAR2(120) ,
    ITEM_ID                        NUMBER(18, 0) ,
    TRANSACTION_CURR_AMOUNT        NUMBER        ,
    TRANSACTION_CURR_AMOUNT_REM    NUMBER        ,
    TRANSACTION_CURRENCY_CODE      VARCHAR2(60)  ,
    ACCTD_AMOUNT                   NUMBER        ,
    ACCTD_AMOUNT_REMAINING         NUMBER        ,
    EXCHANGE_RATE_TYPE             VARCHAR2(120) ,
    EXCHANGE_RATE_DATE             DATE          ,
    EXCHANGE_RATE                  NUMBER        ,
    PROGRAM_AMOUNT                 NUMBER        ,
    PROGRAM_AMOUNT_REMAINING       NUMBER        ,
    PROGRAM_CURRENCY_CODE          VARCHAR2(60)  ,
    YEAR_ID                        NUMBER        ,
    SEEDED_PROGRAM_TYPE_CODE       VARCHAR2(120) ,
    CONSTRAINT pk_cjm_programs_utilized_stage PRIMARY KEY (UTILIZATION_STAGE_ID, UTILIZATION_STAGE_ID)
);
