CREATE TABLE cst_acq_cost_adjustment_dtls (
    ADJUSTMENT_TRANSACTION_ID    NUMBER(18, 0) ,
    COST_COMPONENT_CODE          VARCHAR2(120) ,
    COST_COMPONENT_ID            NUMBER(18, 0) ,
    NEW_COST                     NUMBER        ,
    OLD_COST                     NUMBER        ,
    NEW_ACQ_AMOUNT               NUMBER        ,
    OLD_ACQ_AMOUNT               NUMBER        ,
    NEW_ENTERED_AMOUNT           NUMBER        ,
    OLD_ENTERED_AMOUNT           NUMBER        ,
    SOURCE_DOC_CURR_CODE         VARCHAR2(60)  ,
    SOURCE_DOC_CURR_CONV_TYPE    VARCHAR2(120) ,
    SOURCE_DOC_CURR_CONV_DATE    TIMESTAMP(6)  ,
    SOURCE_DOC_CURR_CONV_RATE    NUMBER        ,
    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),
    ADJUSTMENT_TRANSACTION_ID    NUMBER(18, 0) ,
    COST_COMPONENT_CODE          VARCHAR2(120) ,
    COST_COMPONENT_ID            NUMBER(18, 0) ,
    NEW_COST                     NUMBER        ,
    OLD_COST                     NUMBER        ,
    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),
    SOURCE_DOC_CURR_CODE         VARCHAR2(60)  ,
    SOURCE_DOC_CURR_CONV_TYPE    VARCHAR2(120) ,
    SOURCE_DOC_CURR_CONV_DATE    TIMESTAMP(6)  ,
    SOURCE_DOC_CURR_CONV_RATE    NUMBER        ,
    NEW_ACQ_AMOUNT               NUMBER        ,
    OLD_ACQ_AMOUNT               NUMBER        ,
    NEW_ENTERED_AMOUNT           NUMBER        ,
    OLD_ENTERED_AMOUNT           NUMBER        ,
    CONSTRAINT pk_cst_acq_cost_adjustment_dtls PRIMARY KEY (ADJUSTMENT_TRANSACTION_ID, COST_COMPONENT_ID, ADJUSTMENT_TRANSACTION_ID, COST_COMPONENT_ID)
);
