EBS修改工单发放日期

        INSERT INTO WIP_PERIOD_BALANCES 
                (ACCT_PERIOD_ID, WIP_ENTITY_ID, 
                REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE, 
                LAST_UPDATED_BY, CREATION_DATE, 
                CREATED_BY, LAST_UPDATE_LOGIN, 
                ORGANIZATION_ID, CLASS_TYPE, 
                TL_RESOURCE_IN, TL_OVERHEAD_IN, 
                TL_OUTSIDE_PROCESSING_IN, PL_MATERIAL_IN, 
                PL_MATERIAL_OVERHEAD_IN, PL_RESOURCE_IN, 
                PL_OVERHEAD_IN, PL_OUTSIDE_PROCESSING_IN, 
                TL_MATERIAL_OUT, TL_MATERIAL_OVERHEAD_OUT, TL_RESOURCE_OUT, 
                TL_OVERHEAD_OUT, TL_OUTSIDE_PROCESSING_OUT, 
                PL_MATERIAL_OUT, PL_MATERIAL_OVERHEAD_OUT, 
                PL_RESOURCE_OUT, PL_OVERHEAD_OUT, 
                PL_OUTSIDE_PROCESSING_OUT, 
                PL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR, 
                PL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR, 
                PL_OVERHEAD_VAR, TL_MATERIAL_VAR, TL_MATERIAL_OVERHEAD_VAR, 
                TL_RESOURCE_VAR, TL_OUTSIDE_PROCESSING_VAR, 
                TL_OVERHEAD_VAR) 
 SELECT 
                OAP.acct_period_id, WDJ.WIP_ENTITY_ID, 
                NULL, SYSDATE, 
                0, SYSDATE, 
                0, 0, 
                WDJ.ORGANIZATION_ID, WAC.CLASS_TYPE, 
                0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 
        FROM    WIP_ACCOUNTING_CLASSES WAC, 
                ORG_ACCT_PERIODS OAP, 
                WIP_DISCRETE_JOBS WDJ 
        WHERE   WDJ.STATUS_TYPE IN (3, 4, 5, 6, 7, 14, 15) 
        AND     WAC.CLASS_CODE = WDJ.CLASS_CODE 
        AND     WDJ.ORGANIZATION_ID = WAC.ORGANIZATION_ID  
        AND     OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID 
        AND     OAP.OPEN_FLAG = 'Y' 
        AND     OAP.PERIOD_CLOSE_DATE IS NULL 
        AND     OAP.SCHEDULE_CLOSE_DATE >= NVL(WDJ.DATE_RELEASED, 
                WDJ.CREATION_DATE) 
        AND     WAC.CLASS_TYPE != 2 
        and    WDJ.WIP_ENTITY_ID = 82051
        AND     NOT EXISTS 
                ( 
                SELECT 'X' FROM WIP_PERIOD_BALANCES WPB 
                WHERE  WPB.REPETITIVE_SCHEDULE_ID IS NULL 
                       AND   WPB.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID 
                       AND   WPB.ORGANIZATION_ID = WDJ.ORGANIZATION_ID 
                       AND   WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID);

ebs修改工单发放日期提前之后需要在此table中insert数据，不然移动时会报错