APPS.WIP_BOMROUTINGUTIL_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 604: from wip_requirement_operations

600:
601: cursor c_phantoms is
602: select inventory_item_id,
603: -1*operation_seq_num operation_seq_num
604: from wip_requirement_operations
605: where organization_id = p_orgID
606: and wip_entity_id = p_wipEntityID
607: and nvl(repetitive_schedule_id, -1) = nvl(p_repSchedID, -1)
608: and operation_seq_num < 0

Line 744: from wip_requirement_operations wro

740: end if;
741:
742: select count(distinct nvl(basis_type, 1)), min(distinct nvl(basis_type, 1) )
743: into l_diff_basis, l_basis
744: from wip_requirement_operations wro
745: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id
746: and wro.organization_id = p_orgID
747: and wro.wip_entity_id = p_wipEntityID
748: and wro.operation_seq_num = l_wro_op;

Line 755: update wip_requirement_operations wro

751: raise fnd_api.g_exc_unexpected_error;
752: elsif( l_diff_basis = 1 ) then
753: if( (l_compTbl(l_count).basis_type is null and l_basis = 1 )
754: or l_compTbl(l_count).basis_type = l_basis ) then
755: update wip_requirement_operations wro
756: set wro.quantity_per_assembly = round( l_compTbl(l_count).primary_quantity + wro.quantity_per_assembly,
757: wip_constants.max_displayed_precision),
758: wro.required_quantity = round( round(l_compTbl(l_count).primary_quantity,
759: wip_constants.max_displayed_precision)

Line 767: update wip_requirement_operations wro

763: and wro.organization_id = p_orgID
764: and wro.wip_entity_id = p_wipEntityID
765: and wro.operation_seq_num = l_wro_op;
766:
767: update wip_requirement_operations wro
768: /*Fix for bug 7486594*/
769: set wro.component_yield_factor = decode(wro.quantity_per_assembly,0,1,round( wro.quantity_per_assembly * l_multipleFactor / wro.required_quantity,
770: wip_constants.max_displayed_precision))
771: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id

Line 791: insert into wip_requirement_operations

787: end if;
788: else /* --> end of bug fix 4688276 */
789:
790:
791: insert into wip_requirement_operations
792: (inventory_item_id,
793: organization_id,
794: wip_entity_id,
795: operation_seq_num,

Line 886: update wip_requirement_operations wro

882: end if;
883:
884: -- bug 5527438 end of changes for this fix
885:
886: update wip_requirement_operations wro
887: set (date_required,
888: department_id,
889: wip_supply_type) =
890: (select nvl(max(wo.first_unit_start_date), wro.date_required),

Line 1111: update wip_requirement_operations

1107: set scheduled_quantity = p_qty
1108: where organization_id = p_orgID
1109: and wip_entity_id = p_wipEntityID;
1110:
1111: update wip_requirement_operations
1112: set required_quantity = decode(basis_type,
1113: 2, /* basis is lot */
1114: round(quantity_per_assembly/nvl(component_yield_factor,1), 6),/*For Component Yield Enhancement(Bug 4369064) */
1115: round(quantity_per_assembly/nvl(component_yield_factor,1) * p_qty, 6))