Friday, November 4, 2011

Update STKT to M when we have activity

update ${JDE_SCHEMA}.F4102 set ibstkt = 'M'
WHERE ibstkt = 'P'
and exists (SELECT 'X'
            FROM proddta.F4111
            WHERE ilmcu = ibmcu
            AND ilitm = ibitm
            AND ildct = 'IC');

No comments:

Post a Comment