1710:
1711: UPDATE bom_operation_resources a
1712: SET activity_id =
1713: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
1714: FROM cst_activities
1715: WHERE activity_id = a.activity_id),
1716: schedule_flag =
1717: (SELECT DECODE (c.unit_of_measure,
1718: NULL, 2,
1953:
1954: UPDATE bom_sub_operation_resources a
1955: SET activity_id =
1956: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
1957: FROM cst_activities
1958: WHERE activity_id = a.activity_id),
1959: schedule_flag =
1960: (SELECT DECODE (c.unit_of_measure,
1961: NULL, 2,
3608:
3609: UPDATE bom_operation_resources a
3610: SET activity_id =
3611: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
3612: FROM cst_activities
3613: WHERE activity_id = a.activity_id),
3614: schedule_flag =
3615: (SELECT DECODE (c.unit_of_measure,
3616: NULL, 2,
3853:
3854: UPDATE bom_sub_operation_resources a
3855: SET activity_id =
3856: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
3857: FROM cst_activities
3858: WHERE activity_id = a.activity_id),
3859: schedule_flag =
3860: (SELECT DECODE (c.unit_of_measure,
3861: NULL, 2,