DBA Data[Home] [Help]

APPS.WIP_BOMROUTING_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 268: from wip_requirement_operations

264: l_usePhantomRouting number;
265: cursor c_phantoms is
266: select inventory_item_id,
267: -1*operation_seq_num operation_seq_num
268: from wip_requirement_operations
269: where organization_id = p_orgID
270: and wip_entity_id = p_wipEntityID
271: and operation_seq_num < 0
272: and wip_supply_type = wip_constants.phantom;

Line 467: delete from wip_requirement_operations

463: end if;
464: end if;
465:
466: if ( l_expBomRequired ) then
467: delete from wip_requirement_operations
468: where wip_entity_id = p_wipEntityID
469: and organization_id = p_orgID;
470:
471: if ( l_jobType = wip_constants.standard ) then

Line 556: update wip_requirement_operations wro

552: where organization_id = p_orgID
553: and wip_entity_id = p_wipEntityID;
554:
555: -- need to adjust the data required field
556: update wip_requirement_operations wro
557: set wro.date_required = (select nvl(max(wo.first_unit_start_date), l_startDate)
558: from wip_operations wo
559: where wo.organization_id = wro.organization_id
560: and wo.wip_entity_id = wro.wip_entity_id