CREATE TABLE cst_qty_cons_advice_line_gt (
    EXTERNAL_SYSTEM_REFERENCE        VARCHAR2(240),
    CONSUMPTION_ADVICE_LINE_ID       NUMBER(18, 0),
    NET_OWNERSHIP_CHANGE_QTY         NUMBER       ,
    TOTAL_INVOICED_QTY               NUMBER       ,
    TFR_TO_REG_CURRENCY_CONV_RATE    NUMBER       ,
    OWNERSHIP_CHANGE_DATE            TIMESTAMP(6) ,
    PRICE_CHANGE_EFFECTIVE_DATE      TIMESTAMP(6) ,
    CMR_ROOT_RCV_TXN_ID              NUMBER(18, 0),
    CMR_PO_DISTRIBUTION_ID           NUMBER(18, 0),
    EXTERNAL_SYSTEM_REFERENCE        VARCHAR2(240),
    CONSUMPTION_ADVICE_LINE_ID       NUMBER(18, 0),
    NET_OWNERSHIP_CHANGE_QTY         NUMBER       ,
    TOTAL_INVOICED_QTY               NUMBER       ,
    TFR_TO_REG_CURRENCY_CONV_RATE    NUMBER       ,
    OWNERSHIP_CHANGE_DATE            TIMESTAMP(6) ,
    PRICE_CHANGE_EFFECTIVE_DATE      TIMESTAMP(6) ,
    CMR_ROOT_RCV_TXN_ID              NUMBER(18, 0),
    CMR_PO_DISTRIBUTION_ID           NUMBER(18, 0),
    CONSTRAINT pk_cst_qty_cons_advice_line_gt PRIMARY KEY (EXTERNAL_SYSTEM_REFERENCE, CONSUMPTION_ADVICE_LINE_ID, EXTERNAL_SYSTEM_REFERENCE, CONSUMPTION_ADVICE_LINE_ID)
);
