Beklemede Kalan Kaynak İşlemleri İçin Yapılması Gerekenler

UPDATE wip_discrete_jobs wdj
   SET wdj.date_released = (SELECT MIN (wpb.creation_date)
                              FROM wip_period_balances wpb
                             WHERE wpb.wip_entity_id = p_wip_entity_id)
 WHERE wdj.wip_entity_id = p_wip_entity_id
   AND wdj.date_released IS NULL
   AND wdj.status_type IN (3, 4, 5, 6, 7, 14, 15);

UPDATE wip_discrete_jobs wdj SET wdj.date_released = (SELECT MIN (wpb.creation_date) FROM wip_period_balances wpb WHERE wpb.wip_entity_id = p_wip_entity_id) WHERE wdj.wip_entity_id = p_wip_entity_id AND wdj.date_released IS NULL AND wdj.status_type IN (3, 4, 5, 6, 7, 14, 15);