APPS.WIP_BOMROUTINGUTIL_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 630: from wip_requirement_operations

626:
627: cursor c_phantoms is
628: select inventory_item_id,
629: -1*operation_seq_num operation_seq_num
630: from wip_requirement_operations
631: where organization_id = p_orgID
632: and wip_entity_id = p_wipEntityID
633: and nvl(repetitive_schedule_id, -1) = nvl(p_repSchedID, -1)
634: and operation_seq_num < 0

Line 795: from wip_requirement_operations wro

791: end if;
792:
793: select count(distinct nvl(basis_type, 1)), min(distinct nvl(basis_type, 1) )
794: into l_diff_basis, l_basis
795: from wip_requirement_operations wro
796: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id
797: and wro.organization_id = p_orgID
798: and wro.wip_entity_id = p_wipEntityID
799: and wro.operation_seq_num = l_wro_op;

Line 806: update wip_requirement_operations wro

802: raise fnd_api.g_exc_unexpected_error;
803: elsif( l_diff_basis = 1 ) then
804: if( (l_compTbl(l_count).basis_type is null and l_basis = 1 )
805: or l_compTbl(l_count).basis_type = l_basis ) then
806: update wip_requirement_operations wro
807: set wro.quantity_per_assembly = l_compTbl(l_count).primary_quantity + wro.quantity_per_assembly,/*Bug 13527184*/
808: wro.required_quantity = round( l_compTbl(l_count).primary_quantity*l_multipleFactor/l_compTbl(l_count).component_yield_factor,
809: wip_constants.max_displayed_precision) + wro.required_quantity /*Bug 13527184*/
810: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id

Line 815: update wip_requirement_operations wro

811: and wro.organization_id = p_orgID
812: and wro.wip_entity_id = p_wipEntityID
813: and wro.operation_seq_num = l_wro_op;
814:
815: update wip_requirement_operations wro
816: /*Fix for bug 7486594*/
817: set wro.component_yield_factor = decode(wro.quantity_per_assembly,0,1,round( wro.quantity_per_assembly * l_multipleFactor / wro.required_quantity,
818: wip_constants.max_displayed_precision))
819: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id

Line 839: insert into wip_requirement_operations

835: end if;
836: else /* --> end of bug fix 4688276 */
837:
838:
839: insert into wip_requirement_operations
840: (inventory_item_id,
841: organization_id,
842: wip_entity_id,
843: operation_seq_num,

Line 934: update wip_requirement_operations wro

930: end if;
931:
932: -- bug 5527438 end of changes for this fix
933:
934: update wip_requirement_operations wro
935: set (date_required,
936: department_id,
937: wip_supply_type) =
938: (select nvl(max(wo.first_unit_start_date), wro.date_required),

Line 1129: update wip_requirement_operations

1125: and wip_entity_id = p_wipEntityID;
1126:
1127: if ( l_minOp = fnd_api.g_miss_num ) then
1128: /* Fix bug 9540544 */
1129: update wip_requirement_operations
1130: set required_quantity = decode(basis_type,
1131: 2, /* basis is lot */
1132: round(quantity_per_assembly/nvl(component_yield_factor,1), 6),/*For Component Yield Enhancement(Bug 4369064) */
1133: round(quantity_per_assembly/nvl(component_yield_factor,1) * p_qty, 6))

Line 1209: update wip_requirement_operations

1205: set scheduled_quantity = p_qty
1206: where organization_id = p_orgID
1207: and wip_entity_id = p_wipEntityID;
1208:
1209: update wip_requirement_operations
1210: set required_quantity = decode(basis_type,
1211: 2, /* basis is lot */
1212: round(quantity_per_assembly/nvl(component_yield_factor,1), 6),/*For Component Yield Enhancement(Bug 4369064) */
1213: round(quantity_per_assembly/nvl(component_yield_factor,1) * p_qty, 6))