CREATE TABLE cjm_programs_utilized_all_b (
    UTILIZATION_ID                   NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    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) ,
    REQUEST_ID                       NUMBER(18, 0) ,
    JOB_DEFINITION_NAME              VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE           VARCHAR2(3600),
    BU_ID                            NUMBER(18, 0)     NOT NULL,
    PROGRAM_HEADER_ID                NUMBER(18, 0) ,
    PROGRAM_LINE_ID                  NUMBER(18, 0) ,
    UTILIZATION_TYPE                 VARCHAR2(120) ,
    ADJUSTMENT_TYPE                  VARCHAR2(120) ,
    ADJUSTMENT_TYPE_ID               NUMBER(18, 0) ,
    OBJECT_TYPE                      VARCHAR2(120) ,
    OBJECT_ID                        NUMBER(18, 0) ,
    OBJECT_LINE_ID                   NUMBER(18, 0) ,
    CHARGE_DEFINITION_CODE           VARCHAR2(480) ,
    PRICE_PERIODICITY_CODE           VARCHAR2(480) ,
    PRICE_ELEMENT_CODE               VARCHAR2(480) ,
    PRICING_SOURCE_TYPE_CODE         VARCHAR2(120) ,
    PRICING_SOURCE_ID                VARCHAR2(120) ,
    ITEM_LEVEL_CODE                  VARCHAR2(120) ,
    ITEM_ID                          NUMBER(18, 0) ,
    TRANSACTION_CURR_AMOUNT          NUMBER        ,
    TRANSACTION_CURR_AMOUNT_REM      NUMBER        ,
    TRANSACTION_CURRENCY_CODE        VARCHAR2(60)  ,
    EXCHANGE_RATE_TYPE               VARCHAR2(120) ,
    EXCHANGE_RATE_DATE               DATE          ,
    EXCHANGE_RATE                    NUMBER        ,
    ACCTD_AMOUNT                     NUMBER        ,
    ACCTD_AMOUNT_REMAINING           NUMBER        ,
    PROGRAM_AMOUNT                   NUMBER        ,
    PROGRAM_AMOUNT_REMAINING         NUMBER        ,
    PROGRAM_CURRENCY_CODE            VARCHAR2(60)  ,
    GL_DATE                          DATE          ,
    REQUESTED_GL_DATE                DATE          ,
    MANUAL_ADJUSTMENT_ID             NUMBER(18, 0) ,
    INVOICE_SOURCE_CODE              VARCHAR2(200) ,
    GL_POSTED_FLAG                   VARCHAR2(4)   ,
    ADJUSTMENT_DATE                  DATE          ,
    PARTY_ID                         NUMBER(18, 0) ,
    CUST_ACCOUNT_ID                  NUMBER(18, 0) ,
    BILL_TO_CUSTOMER_ID              NUMBER(18, 0) ,
    BILL_TO_SITE_USE_ID              NUMBER(18, 0) ,
    SHIP_TO_PARTY_SITE_ID            NUMBER(18, 0) ,
    PERIOD_NAME                      VARCHAR2(60)  ,
    BILL_TO_LOCATION_ID              NUMBER(18, 0) ,
    SHIP_TO_LOCATION_ID              NUMBER(18, 0) ,
    VENDOR_ID                        NUMBER(18, 0) ,
    VENDOR_SITE_ID                   NUMBER(18, 0) ,
    ACCRUAL_QTY                      NUMBER        ,
    ACCRUAL_UOM                      VARCHAR2(60)  ,
    REFERENCE_TYPE                   VARCHAR2(120) ,
    REFERENCE_ID                     NUMBER(18, 0) ,
    INVOICE_SOURCE_APPLICATION       VARCHAR2(120) ,
    INVOICE_DATE                     DATE          ,
    INVOICE_ID                       NUMBER(18, 0) ,
    INVOICE_NUMBER                   VARCHAR2(200) ,
    INVOICE_LINE_NUMBER              NUMBER        ,
    WAYBILL_NUMBER                   VARCHAR2(120) ,
    BILL_OF_LADING_NUMBER            VARCHAR2(480) ,
    ACCRUAL_TYPE                     VARCHAR2(120) ,
    BENEFICIARY_TYPE                 VARCHAR2(120) ,
    SHIPMENT_DATE                    DATE          ,
    SHIPMENT_NUMBER                  VARCHAR2(120) ,
    ORIG_UTILIZATION_ID              NUMBER(18, 0) ,
    YEAR_ID                          NUMBER(18, 0) ,
    DISCOUNT_TYPE                    VARCHAR2(120) ,
    DISCOUNT_AMOUNT                  NUMBER        ,
    CUSTOMER_TRX_LINE_ID             NUMBER(18, 0) ,
    ADJUSTMENT_REASON_ID             NUMBER(18, 0) ,
    TP_ITEM_ID                       NUMBER(18, 0) ,
    DOCUMENT_PROGRAM_ID              NUMBER(18, 0) ,
    ACCRUAL_TRX_TYPE                 VARCHAR2(120) ,
    TRANSACTION_UNIT_PRICE           NUMBER        ,
    PROGRAM_LINE_UOM_CODE            VARCHAR2(12)  ,
    ACCRUAL_QTY_IN_PROG_LINE_UOM     NUMBER        ,
    EARNED_ACCRUALS_EVENT            VARCHAR2(120) ,
    RECEIPT_ID                       NUMBER(18, 0) ,
    RECEIPT_NUMBER                   VARCHAR2(200) ,
    PO_HEADER_ID                     NUMBER(18, 0) ,
    PO_NUMBER                        VARCHAR2(120) ,
    TRANSACTION_ID                   NUMBER(18, 0) ,
    PO_LINE_LOCATION_ID              NUMBER(18, 0) ,
    MATCH_OPTION                     VARCHAR2(100) ,
    SEEDED_PROGRAM_TYPE_CODE         VARCHAR2(120) ,
    DISTRIBUTOR_SITE_ID              NUMBER(18, 0) ,
    ACCRUAL_QTY_IN_INV_UOM           NUMBER        ,
    CATEGORY_ID                      NUMBER(18, 0) ,
    SOURCE_TRX_AMOUNT_IN_PRG_CURR    NUMBER        ,
    SOURCE_TRX_AMOUNT_IN_TRX_CURR    NUMBER        ,
    SOURCE_TRX_ACCTD_AMOUNT          NUMBER        ,
    DISTRIBUTOR_ID                   NUMBER(18, 0) ,
    ATTRIBUTE_CATEGORY               VARCHAR2(600) ,
    ATTRIBUTE_CHAR1                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR2                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR3                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR4                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR5                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR6                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR7                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR8                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR9                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR10                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR11                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR12                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR13                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR14                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR15                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR16                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR17                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR18                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR19                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR20                 VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER2                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER3                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER4                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER5                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER6                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER7                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER8                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER9                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER10               NUMBER(22, 0) ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    ATTRIBUTE_TIMESTAMP1             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5             TIMESTAMP(6)  ,
    UTILIZATION_ID                   NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    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) ,
    REQUEST_ID                       NUMBER(18, 0) ,
    JOB_DEFINITION_NAME              VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE           VARCHAR2(3600),
    BU_ID                            NUMBER(18, 0)     NOT NULL,
    BILL_TO_BU_ID                    NUMBER(18, 0) ,
    LEGAL_ENTITY_ID                  NUMBER(18, 0) ,
    PROGRAM_HEADER_ID                NUMBER(18, 0) ,
    PROGRAM_LINE_ID                  NUMBER(18, 0) ,
    BUDGET_ID                        NUMBER(18, 0) ,
    UTILIZATION_TYPE                 VARCHAR2(120) ,
    ADJUSTMENT_TYPE                  VARCHAR2(120) ,
    ADJUSTMENT_TYPE_ID               NUMBER(18, 0) ,
    OBJECT_TYPE                      VARCHAR2(120) ,
    OBJECT_ID                        NUMBER(18, 0) ,
    OBJECT_LINE_ID                   NUMBER(18, 0) ,
    CHARGE_DEFINITION_CODE           VARCHAR2(480) ,
    PRICE_PERIODICITY_CODE           VARCHAR2(480) ,
    PRICE_ELEMENT_CODE               VARCHAR2(480) ,
    PRICING_SOURCE_TYPE_CODE         VARCHAR2(120) ,
    PRICING_SOURCE_ID                VARCHAR2(120) ,
    ITEM_LEVEL_CODE                  VARCHAR2(120) ,
    ITEM_ID                          NUMBER(18, 0) ,
    TRANSACTION_CURR_AMOUNT          NUMBER        ,
    TRANSACTION_CURR_AMOUNT_REM      NUMBER        ,
    TRANSACTION_CURRENCY_CODE        VARCHAR2(60)  ,
    EXCHANGE_RATE_TYPE               VARCHAR2(120) ,
    EXCHANGE_RATE_DATE               DATE          ,
    EXCHANGE_RATE                    NUMBER        ,
    ACCTD_AMOUNT                     NUMBER        ,
    ACCTD_AMOUNT_REMAINING           NUMBER        ,
    PROGRAM_AMOUNT                   NUMBER        ,
    PROGRAM_AMOUNT_REMAINING         NUMBER        ,
    PROGRAM_CURRENCY_CODE            VARCHAR2(60)  ,
    BUDGET_AMOUNT                    NUMBER        ,
    BUDGET_AMOUNT_REMAINING          NUMBER        ,
    BUDGET_CURRENCY_CODE             VARCHAR2(60)  ,
    GL_DATE                          DATE          ,
    REQUESTED_GL_DATE                DATE          ,
    MANUAL_ADJUSTMENT_ID             NUMBER(18, 0) ,
    INVOICE_SOURCE_CODE              VARCHAR2(200) ,
    GL_POSTED_FLAG                   VARCHAR2(4)   ,
    ADJUSTMENT_DATE                  DATE          ,
    PARTY_ID                         NUMBER(18, 0) ,
    CUST_ACCOUNT_ID                  NUMBER(18, 0) ,
    BILL_TO_CUSTOMER_ID              NUMBER(18, 0) ,
    BILL_TO_SITE_USE_ID              NUMBER(18, 0) ,
    SHIP_TO_PARTY_SITE_ID            NUMBER(18, 0) ,
    VENDOR_ID                        NUMBER(18, 0) ,
    VENDOR_SITE_ID                   NUMBER(18, 0) ,
    ACCRUAL_QTY                      NUMBER        ,
    ACCRUAL_UOM                      VARCHAR2(60)  ,
    REFERENCE_TYPE                   VARCHAR2(120) ,
    REFERENCE_ID                     NUMBER(18, 0) ,
    INVOICE_DATE                     DATE          ,
    INVOICE_ID                       NUMBER(18, 0) ,
    INVOICE_NUMBER                   VARCHAR2(200) ,
    INVOICE_LINE_NUMBER              NUMBER        ,
    WAYBILL_NUMBER                   VARCHAR2(120) ,
    BILL_OF_LADING_NUMBER            VARCHAR2(480) ,
    ACCRUAL_TYPE                     VARCHAR2(120) ,
    BENEFICIARY_TYPE                 VARCHAR2(120) ,
    SHIPMENT_DATE                    DATE          ,
    SHIPMENT_NUMBER                  VARCHAR2(120) ,
    ORIG_UTILIZATION_ID              NUMBER(18, 0) ,
    YEAR_ID                          NUMBER(18, 0) ,
    COST_PRICE                       NUMBER        ,
    COST_PRICE_CURRENCY_CODE         VARCHAR2(60)  ,
    DISCOUNT_TYPE                    VARCHAR2(120) ,
    DISCOUNT_AMOUNT                  NUMBER        ,
    DISCOUNT_AMOUNT_CURRENCY_CODE    VARCHAR2(60)  ,
    CUSTOMER_TRX_LINE_ID             NUMBER(18, 0) ,
    ATTRIBUTE_CATEGORY               VARCHAR2(600) ,
    ATTRIBUTE_CHAR1                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR2                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR3                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR4                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR5                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR6                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR7                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR8                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR9                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR10                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR11                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR12                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR13                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR14                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR15                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR16                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR17                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR18                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR19                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR20                 VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER2                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER3                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER4                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER5                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER6                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER7                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER8                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER9                NUMBER(22, 0) ,
    ATTRIBUTE_NUMBER10               NUMBER(22, 0) ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    ATTRIBUTE_TIMESTAMP1             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4             TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5             TIMESTAMP(6)  ,
    ADJUSTMENT_REASON_ID             NUMBER(18, 0) ,
    TP_ITEM_ID                       NUMBER(18, 0) ,
    INVOICE_SOURCE_APPLICATION       VARCHAR2(120) ,
    DOCUMENT_PROGRAM_ID              NUMBER(18, 0) ,
    ACCRUAL_TRX_TYPE                 VARCHAR2(120) ,
    TRANSACTION_UNIT_PRICE           NUMBER        ,
    PROGRAM_LINE_UOM_CODE            VARCHAR2(12)  ,
    ACCRUAL_QTY_IN_PROG_LINE_UOM     NUMBER        ,
    EARNED_ACCRUALS_EVENT            VARCHAR2(120) ,
    RECEIPT_ID                       NUMBER(18, 0) ,
    RECEIPT_NUMBER                   VARCHAR2(200) ,
    PO_HEADER_ID                     NUMBER(18, 0) ,
    PO_NUMBER                        VARCHAR2(120) ,
    TRANSACTION_ID                   NUMBER(18, 0) ,
    PO_LINE_LOCATION_ID              NUMBER(18, 0) ,
    MATCH_OPTION                     VARCHAR2(100) ,
    SEEDED_PROGRAM_TYPE_CODE         VARCHAR2(120) ,
    DISTRIBUTOR_SITE_ID              NUMBER(18, 0) ,
    ACCRUAL_QTY_IN_INV_UOM           NUMBER        ,
    PERIOD_NAME                      VARCHAR2(60)  ,
    BILL_TO_LOCATION_ID              NUMBER(18, 0) ,
    SHIP_TO_LOCATION_ID              NUMBER(18, 0) ,
    CATEGORY_ID                      NUMBER(18, 0) ,
    SOURCE_TRX_AMOUNT_IN_PRG_CURR    NUMBER        ,
    SOURCE_TRX_AMOUNT_IN_TRX_CURR    NUMBER        ,
    SOURCE_TRX_ACCTD_AMOUNT          NUMBER        ,
    DISTRIBUTOR_ID                   NUMBER(18, 0) ,
    CONSTRAINT pk_cjm_programs_utilized_all_b PRIMARY KEY (UTILIZATION_ID, UTILIZATION_ID)
);
