APPS.WIP_BOMROUTING_PVT dependencies on WIP_OPERATIONS

Line 193: from wip_operations wo

189:
190: -- need to adjust the data required field
191: update wip_requirement_operations wro
192: set wro.date_required = (select nvl(max(wo.first_unit_start_date),l_startDate)
193: from wip_operations wo
194: where wo.organization_id = wro.organization_id
195: and wo.wip_entity_id = wro.wip_entity_id
196: and wo.operation_seq_num = abs(wro.operation_seq_num))
197: where wro.wip_entity_id = p_wipEntityID

Line 418: delete from wip_operations

414: wip_update_setup_resources.delete_setup_resources_pub(
415: p_wip_entity_id => p_wipEntityID,
416: p_organization_id => p_orgID);
417:
418: delete from wip_operations
419: where wip_entity_id = p_wipEntityID
420: and organization_id = p_orgID;
421:
422: delete from wip_operation_resources

Line 445: delete from wip_operations

441: wip_update_setup_resources.delete_setup_resources_pub(
442: p_wip_entity_id => p_wipEntityID,
443: p_organization_id => p_orgID);
444:
445: delete from wip_operations
446: where wip_entity_id = p_wipEntityID
447: and organization_id = p_orgID;
448:
449: delete from wip_operation_resources

Line 635: from wip_operations wo

631: end if;
632:
633: update wip_requirement_operations wro
634: set wro.date_required = (select nvl(max(wo.first_unit_start_date),l_startDate)
635: from wip_operations wo
636: where wo.organization_id = wro.organization_id
637: and wo.wip_entity_id = wro.wip_entity_id
638: and wo.operation_seq_num = abs(wro.operation_seq_num))
639: where wro.wip_entity_id = p_wipEntityID

Line 655: update wip_operations

651: and wdj.wip_entity_id = p_wipEntityID;
652: end if;
653:
654:
655: update wip_operations
656: set first_unit_start_date = p_startDate,
657: first_unit_completion_date = p_startDate,
658: last_unit_start_date = p_startDate,
659: last_unit_completion_date = p_startDate

Line 678: from wip_operations wo

674:
675: -- need to adjust the data required field
676: update wip_requirement_operations wro
677: set wro.date_required = (select nvl(max(wo.first_unit_start_date),l_startDate)
678: from wip_operations wo
679: where wo.organization_id = wro.organization_id
680: and wo.wip_entity_id = wro.wip_entity_id
681: and wo.operation_seq_num = abs(wro.operation_seq_num))
682: where wro.wip_entity_id = p_wipEntityID