CREATE TABLE cjm_programs_all_b (
    PROGRAM_HEADER_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),
    PROGRAM_CODE                      VARCHAR2(120)     NOT NULL,
    PROGRAM_TYPE_ID                   NUMBER(18, 0)     NOT NULL,
    PROGRAM_TYPE_CODE                 VARCHAR2(120)     NOT NULL,
    OWNER_ID                          NUMBER(18, 0)     NOT NULL,
    USER_STATUS_ID                    NUMBER(18, 0)     NOT NULL,
    VENDOR_ID                         NUMBER(18, 0) ,
    VENDOR_SITE_ID                    NUMBER(18, 0) ,
    INITIATED_BY_CODE                 VARCHAR2(80)  ,
    CONTACT_ID                        NUMBER(18, 0) ,
    AUTHORIZATION_NUMBER              VARCHAR2(120) ,
    QUOTE_NUMBER                      VARCHAR2(120) ,
    OVERRIDE_PROGRAM                  VARCHAR2(4)   ,
    STATUS_CODE                       VARCHAR2(120)     NOT NULL,
    STATUS_CHANGE_DATE                DATE          ,
    DISCOUNT_APPLIED_TO_CODE          VARCHAR2(120)     NOT NULL,
    CURRENCY_CODE                     VARCHAR2(60)  ,
    COMMITTED_AMOUNT                  NUMBER        ,
    ACCOUNT_CLOSED_FLAG               VARCHAR2(4)   ,
    VOLUME_PROGRAM_TYPE               VARCHAR2(120) ,
    RETROACTIVE                       VARCHAR2(4)   ,
    CALCULATION_METHOD_CODE           VARCHAR2(120) ,
    ENABLE_BENEFICIARY                VARCHAR2(4)   ,
    BENEFICIARY_TYPE_CODE             VARCHAR2(120) ,
    BENEFICIARY_VALUE_CODE            NUMBER        ,
    HEADER_DYNAMIC_MATRIX_ID          NUMBER(18, 0) ,
    COMMON_DYNAMIC_MATRIX_ID          NUMBER(18, 0) ,
    HEADER_MATRIX_RULE_ID             NUMBER(18, 0) ,
    COMMON_MATRIX_RULE_ID             NUMBER(18, 0) ,
    SOLD_BY_SALES_METHOD_CODE         VARCHAR2(4)   ,
    BU_ID                             NUMBER(18, 0)     NOT NULL,
    PROGRAM_ACTIVATION_DATE           DATE          ,
    START_DATE                        DATE          ,
    END_DATE                          DATE          ,
    PRICING_DATE_TYPE_CODE            VARCHAR2(120)     NOT NULL,
    PRICING_DATE_FROM                 DATE          ,
    PRICING_DATE_TO                   DATE          ,
    DISPLAY_ON_ORDER_FLAG             VARCHAR2(4)   ,
    REQUEST_ONLY_FLAG                 VARCHAR2(4)   ,
    GRACE_PERIOD_IN_DAYS              NUMBER(18, 0) ,
    LAST_RUN_DATE                     DATE          ,
    LAST_PERIOD_END_DATE              DATE          ,
    CUSTOMER_TYPE_CODE                VARCHAR2(120) ,
    CUSTOMER_ID                       NUMBER(18, 0) ,
    LUMPSUM_AMOUNT                    NUMBER        ,
    LUMPSUM_DISTRIB_TYPE_CODE         VARCHAR2(120) ,
    ESTIMATED_AMOUNT                  NUMBER        ,
    ACCOUNTED_ESTIMATED_AMOUNT        NUMBER        ,
    ACCOUNTED_LUMPSUM_AMOUNT          NUMBER        ,
    EXCHANGE_RATE_TYPE                VARCHAR2(120) ,
    EXCHANGE_RATE_DATE                DATE          ,
    EXCHANGE_RATE                     NUMBER        ,
    COMMENTS_FOR_APPROVERS            VARCHAR2(4000),
    SUBMITTED_BY                      NUMBER(18, 0) ,
    SUBMITTED_DATE                    DATE          ,
    APPROVED_DATE                     DATE          ,
    REJECTED_DATE                     DATE          ,
    OWNER_USER_ID                     NUMBER(18, 0) ,
    ELIGIBLE_FOR_ALL_CUSTOMERS        VARCHAR2(4)   ,
    SHIP_FROM_DIST_INV_FLAG           VARCHAR2(4)   ,
    ACCRUE_BASED_ON_POS_FLAG          VARCHAR2(4)   ,
    SPA_REQUEST_TYPE_CODE             VARCHAR2(120) ,
    SPA_OUTCOME_CODE                  VARCHAR2(120) ,
    DISTRIBUTOR_BILL_TO_ACCOUNT_ID    NUMBER(18, 0) ,
    DISTRIBUTOR_BILL_TO_CONTACT_ID    NUMBER(18, 0) ,
    END_CUSTOMER_PARTY_ID             NUMBER(18, 0) ,
    END_CUSTOMER_CONTACT              VARCHAR2(4000),
    END_CUSTOMER_CONTACT_EMAIL        VARCHAR2(4000),
    END_CUSTOMER_CONTACT_PHONE        VARCHAR2(640) ,
    END_CUST_CONTACT_COUNTRY_CODE     VARCHAR2(160) ,
    END_CUST_CONTACT_PHONE_EXT        VARCHAR2(320) ,
    COMPETITOR_PARTY_ID               NUMBER(18, 0) ,
    COMPETITOR_CONTACT                VARCHAR2(4000),
    COMPETITOR_CONTACT_EMAIL          VARCHAR2(4000),
    COMPETITOR_CONTACT_PHONE          VARCHAR2(640) ,
    COMPETITOR_CONTACT_CTRY_CODE      VARCHAR2(160) ,
    COMPETITOR_CONTACT_PHONE_EXT      VARCHAR2(320) ,
    GROUP_ACCRLS_FOR_CLM_ACT_FLAG     VARCHAR2(4)   ,
    ATTRIBUTE_CATEGORY                VARCHAR2(120) ,
    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        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_NUMBER6                 NUMBER        ,
    ATTRIBUTE_NUMBER7                 NUMBER        ,
    ATTRIBUTE_NUMBER8                 NUMBER        ,
    ATTRIBUTE_NUMBER9                 NUMBER        ,
    ATTRIBUTE_NUMBER10                NUMBER        ,
    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)  ,
    CUSTOMER_ATTRIBUTE_CATEGORY       VARCHAR2(120) ,
    CUSTOMER_ATTRIBUTE_CHAR1          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR2          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR3          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR4          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR5          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR6          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR7          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR8          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR9          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR10         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR11         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR12         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR13         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR14         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR15         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR16         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR17         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR18         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR19         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR20         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_DATE1          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE2          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE3          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE4          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE5          DATE          ,
    CUSTOMER_ATTRIBUTE_NUMBER1        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER2        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER3        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER4        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER5        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER6        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER7        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER8        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER9        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER10       NUMBER        ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP1     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP2     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP3     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP4     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP5     TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_CATEGORY            VARCHAR2(120) ,
    SPA_ATTRIBUTE_CHAR1               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR2               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR3               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR4               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR5               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR6               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR7               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR8               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR9               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR10              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR11              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR12              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR13              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR14              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR15              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR16              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR17              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR18              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR19              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR20              VARCHAR2(600) ,
    SPA_ATTRIBUTE_DATE1               DATE          ,
    SPA_ATTRIBUTE_DATE2               DATE          ,
    SPA_ATTRIBUTE_DATE3               DATE          ,
    SPA_ATTRIBUTE_DATE4               DATE          ,
    SPA_ATTRIBUTE_DATE5               DATE          ,
    SPA_ATTRIBUTE_NUMBER1             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER2             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER3             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER4             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER5             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER6             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER7             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER8             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER9             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER10            NUMBER        ,
    SPA_ATTRIBUTE_TIMESTAMP1          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP2          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP3          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP4          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP5          TIMESTAMP(6)  ,
    PROGRAM_HEADER_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),
    PROGRAM_CODE                      VARCHAR2(120)     NOT NULL,
    PROGRAM_TYPE_ID                   NUMBER(18, 0)     NOT NULL,
    PROGRAM_TYPE_CODE                 VARCHAR2(120)     NOT NULL,
    OWNER_ID                          NUMBER(18, 0)     NOT NULL,
    USER_STATUS_ID                    NUMBER(18, 0)     NOT NULL,
    VENDOR_ID                         NUMBER(18, 0) ,
    VENDOR_SITE_ID                    NUMBER(18, 0) ,
    AUTHORIZATION_NUMBER              VARCHAR2(120) ,
    QUOTE_NUMBER                      VARCHAR2(120) ,
    OVERRIDE_PROGRAM                  VARCHAR2(4)   ,
    STATUS_CODE                       VARCHAR2(120)     NOT NULL,
    STATUS_CHANGE_DATE                DATE          ,
    DISCOUNT_APPLIED_TO_CODE          VARCHAR2(120)     NOT NULL,
    CURRENCY_CODE                     VARCHAR2(60)  ,
    COMMITTED_AMOUNT                  NUMBER        ,
    ACCOUNT_CLOSED_FLAG               VARCHAR2(4)   ,
    VOLUME_PROGRAM_TYPE               VARCHAR2(120) ,
    RETROACTIVE                       VARCHAR2(4)   ,
    ENABLE_BENEFICIARY                VARCHAR2(4)   ,
    BENEFICIARY_TYPE_CODE             VARCHAR2(120) ,
    BENEFICIARY_VALUE_CODE            NUMBER        ,
    HEADER_DYNAMIC_MATRIX_ID          NUMBER(18, 0) ,
    COMMON_DYNAMIC_MATRIX_ID          NUMBER(18, 0) ,
    HEADER_MATRIX_RULE_ID             NUMBER(18, 0) ,
    COMMON_MATRIX_RULE_ID             NUMBER(18, 0) ,
    SOLD_BY_SALES_METHOD_CODE         VARCHAR2(4)   ,
    BU_ID                             NUMBER(18, 0)     NOT NULL,
    PROGRAM_ACTIVATION_DATE           DATE          ,
    START_DATE                        DATE          ,
    END_DATE                          DATE          ,
    PRICING_DATE_TYPE_CODE            VARCHAR2(120)     NOT NULL,
    PRICING_DATE_FROM                 DATE          ,
    PRICING_DATE_TO                   DATE          ,
    DISPLAY_ON_ORDER_FLAG             VARCHAR2(4)   ,
    REQUEST_ONLY_FLAG                 VARCHAR2(4)   ,
    ATTRIBUTE_CATEGORY                VARCHAR2(120) ,
    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        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_NUMBER6                 NUMBER        ,
    ATTRIBUTE_NUMBER7                 NUMBER        ,
    ATTRIBUTE_NUMBER8                 NUMBER        ,
    ATTRIBUTE_NUMBER9                 NUMBER        ,
    ATTRIBUTE_NUMBER10                NUMBER        ,
    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)  ,
    GRACE_PERIOD_IN_DAYS              NUMBER(18, 0) ,
    CALCULATION_METHOD_CODE           VARCHAR2(120) ,
    LAST_RUN_DATE                     DATE          ,
    LAST_PERIOD_END_DATE              DATE          ,
    INITIATED_BY_CODE                 VARCHAR2(80)  ,
    CONTACT_ID                        NUMBER(18, 0) ,
    CUSTOMER_ATTRIBUTE_CATEGORY       VARCHAR2(120) ,
    CUSTOMER_ATTRIBUTE_CHAR1          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR2          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR3          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR4          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR5          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR6          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR7          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR8          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR9          VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR10         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR11         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR12         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR13         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR14         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR15         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR16         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR17         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR18         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR19         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_CHAR20         VARCHAR2(600) ,
    CUSTOMER_ATTRIBUTE_DATE1          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE2          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE3          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE4          DATE          ,
    CUSTOMER_ATTRIBUTE_DATE5          DATE          ,
    CUSTOMER_ATTRIBUTE_NUMBER1        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER2        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER3        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER4        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER5        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER6        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER7        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER8        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER9        NUMBER        ,
    CUSTOMER_ATTRIBUTE_NUMBER10       NUMBER        ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP1     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP2     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP3     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP4     TIMESTAMP(6)  ,
    CUSTOMER_ATTRIBUTE_TIMESTAMP5     TIMESTAMP(6)  ,
    CUSTOMER_TYPE_CODE                VARCHAR2(120) ,
    CUSTOMER_ID                       NUMBER(18, 0) ,
    LUMPSUM_AMOUNT                    NUMBER        ,
    LUMPSUM_DISTRIB_TYPE_CODE         VARCHAR2(120) ,
    ESTIMATED_AMOUNT                  NUMBER        ,
    ACCOUNTED_ESTIMATED_AMOUNT        NUMBER        ,
    ACCOUNTED_LUMPSUM_AMOUNT          NUMBER        ,
    EXCHANGE_RATE_TYPE                VARCHAR2(120) ,
    EXCHANGE_RATE_DATE                DATE          ,
    EXCHANGE_RATE                     NUMBER        ,
    COMMENTS_FOR_APPROVERS            VARCHAR2(4000),
    SUBMITTED_BY                      NUMBER(18, 0) ,
    SUBMITTED_DATE                    DATE          ,
    APPROVED_DATE                     DATE          ,
    REJECTED_DATE                     DATE          ,
    OWNER_USER_ID                     NUMBER(18, 0) ,
    ELIGIBLE_FOR_ALL_CUSTOMERS        VARCHAR2(4)   ,
    SHIP_FROM_DIST_INV_FLAG           VARCHAR2(4)   ,
    ACCRUE_BASED_ON_POS_FLAG          VARCHAR2(4)   ,
    SPA_REQUEST_TYPE_CODE             VARCHAR2(120) ,
    SPA_OUTCOME_CODE                  VARCHAR2(120) ,
    DISTRIBUTOR_BILL_TO_ACCOUNT_ID    NUMBER(18, 0) ,
    DISTRIBUTOR_BILL_TO_CONTACT_ID    NUMBER(18, 0) ,
    END_CUSTOMER_PARTY_ID             NUMBER(18, 0) ,
    END_CUSTOMER_CONTACT              VARCHAR2(4000),
    END_CUSTOMER_CONTACT_EMAIL        VARCHAR2(4000),
    END_CUSTOMER_CONTACT_PHONE        VARCHAR2(640) ,
    END_CUST_CONTACT_COUNTRY_CODE     VARCHAR2(160) ,
    END_CUST_CONTACT_PHONE_EXT        VARCHAR2(320) ,
    COMPETITOR_PARTY_ID               NUMBER(18, 0) ,
    COMPETITOR_CONTACT                VARCHAR2(4000),
    COMPETITOR_CONTACT_EMAIL          VARCHAR2(4000),
    COMPETITOR_CONTACT_PHONE          VARCHAR2(640) ,
    COMPETITOR_CONTACT_CTRY_CODE      VARCHAR2(160) ,
    COMPETITOR_CONTACT_PHONE_EXT      VARCHAR2(320) ,
    SPA_ATTRIBUTE_CATEGORY            VARCHAR2(120) ,
    SPA_ATTRIBUTE_CHAR1               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR2               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR3               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR4               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR5               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR6               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR7               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR8               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR9               VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR10              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR11              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR12              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR13              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR14              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR15              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR16              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR17              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR18              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR19              VARCHAR2(600) ,
    SPA_ATTRIBUTE_CHAR20              VARCHAR2(600) ,
    SPA_ATTRIBUTE_DATE1               DATE          ,
    SPA_ATTRIBUTE_DATE2               DATE          ,
    SPA_ATTRIBUTE_DATE3               DATE          ,
    SPA_ATTRIBUTE_DATE4               DATE          ,
    SPA_ATTRIBUTE_DATE5               DATE          ,
    SPA_ATTRIBUTE_NUMBER1             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER2             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER3             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER4             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER5             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER6             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER7             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER8             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER9             NUMBER        ,
    SPA_ATTRIBUTE_NUMBER10            NUMBER        ,
    SPA_ATTRIBUTE_TIMESTAMP1          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP2          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP3          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP4          TIMESTAMP(6)  ,
    SPA_ATTRIBUTE_TIMESTAMP5          TIMESTAMP(6)  ,
    GROUP_ACCRLS_FOR_CLM_ACT_FLAG     VARCHAR2(4)   ,
    CONSTRAINT pk_cjm_programs_all_b PRIMARY KEY (PROGRAM_HEADER_ID, PROGRAM_HEADER_ID)
);
