DBA Data[Home] [Help]

APPS.WIP_BOMROUTING_PVT dependencies on WIP_OPERATION_RESOURCES

Line 422: delete from wip_operation_resources

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
423: where wip_entity_id = p_wipEntityID
424: and organization_id = p_orgID;
425:
426: delete from wip_sub_operation_resources

Line 449: delete from wip_operation_resources

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
450: where wip_entity_id = p_wipEntityID
451: and organization_id = p_orgID;
452:
453: delete from wip_sub_operation_resources

Line 576: delete from WIP_OPERATION_RESOURCES

572: and wdj.wip_entity_id = p_wipEntityID;
573: end if;
574:
575: -- Should delete the Phantom Resources since it will be re-exploded again during BOM explosion.
576: delete from WIP_OPERATION_RESOURCES
577: where wip_entity_id = p_wipEntityID
578: and organization_id = p_orgID
579: and phantom_flag = 1;
580:

Line 663: update wip_operation_resources

659: last_unit_completion_date = p_startDate
660: where organization_id = p_orgID
661: and wip_entity_id = p_wipEntityID;
662:
663: update wip_operation_resources
664: set start_date = p_startDate,
665: completion_date = p_startDate
666: where organization_id = p_orgID
667: and wip_entity_id = p_wipEntityID;