APPS.EAM_OPERATIONS_JSP dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv

2614: begin
2615:
2616: select 1, wro.operation_seq_num,wro.department_id,msikfv.description
2617: into l_material_exists, l_existing_operation, l_existing_department, l_existing_description
2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv
2619: where wro.inventory_item_id = l_inventory_item_id
2620: and wro.organization_id = p_organization_id
2621: and wro.wip_entity_id = p_wip_entity_id
2622: and wro.organization_id = msikfv.organization_id

Line 2785: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new

2781: end if;
2782:
2783: ELSE
2784:
2785: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new
2786: -- entry into WIP_REQUIREMENT_OPERATIONS
2787:
2788: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2789: l_eam_mat_req_rec.wip_entity_id := p_wip_entity_id;

Line 2786: -- entry into WIP_REQUIREMENT_OPERATIONS

2782:
2783: ELSE
2784:
2785: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new
2786: -- entry into WIP_REQUIREMENT_OPERATIONS
2787:
2788: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2789: l_eam_mat_req_rec.wip_entity_id := p_wip_entity_id;
2790: l_eam_mat_req_rec.organization_id := p_organization_id;

Line 4434: from wip_requirement_operations

4430: where wip_entity_id = l_wip_entity_id and ( prior_operation = p_operation_seq_num or next_operation = p_operation_seq_num);
4431:
4432: select count(*)
4433: into l_count_mat
4434: from wip_requirement_operations
4435: where wip_entity_id = l_wip_entity_id
4436: and operation_seq_num = l_operation_seq_num;
4437:
4438: select count(*)