WIP Kaynak İşlemleri Yayın Tarihinden Önce Gelir Hatası

UPDATE wip_cost_txn_interface i
   SET transaction_date = (SELECT date_released + 0.05
                             FROM wip_discrete_jobs b
                            WHERE wip_entity_id = i.wip_entity_id)
 WHERE 1 = 1 --PROCESS_STATUS = 3
   AND transaction_date = (SELECT date_released + 0.05
                             FROM apps.wip_discrete_jobs b
                            WHERE wip_entity_id = i.wip_entity_id)

UPDATE wip_cost_txn_interface i SET transaction_date = (SELECT date_released + 0.05 FROM wip_discrete_jobs b WHERE wip_entity_id = i.wip_entity_id) WHERE 1 = 1 --PROCESS_STATUS = 3 AND transaction_date = (SELECT date_released + 0.05 FROM apps.wip_discrete_jobs b WHERE wip_entity_id = i.wip_entity_id)