APPS.AHL_MM_CANNIBALIZATION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 58

  SELECT asm.inventory_item_id, asm.visit_id, asm.visit_task_id,
  asm.requested_quantity, awo.workorder_id, awo.wip_entity_id, awo.workorder_name
  , vst.item_instance_id,asm.organization_id
  FROM ahl_schedule_materials asm,ahl_workorders awo, ahl_visits_b vst
  WHERE asm.status = 'ACTIVE'
  AND   asm.AOG_FLAG = 'Y'
  AND   asm.visit_task_id = awo.visit_task_id
  AND   awo.status_code in ('1','3','6')
  AND   asm.visit_id = vst.visit_id
  AND   asm.scheduled_material_id = c_asm_id;

Line: 71

  SELECT cis.inventory_item_id
  FROM csi_item_instances cis, csi_ii_relationships cir
  WHERE cis.instance_id = cir.subject_id
  AND cir.relationship_type_code = 'COMPONENT-OF'
  AND cis.instance_id  = c_instance_id
  AND NVL(cir.active_end_date,sysdate) >= sysdate
  START WITH cir.object_id IN
            (SELECT item_instance_id FROM ahl_visits_b
            WHERE visit_id = c_visit_id)
  CONNECT BY cir.object_id = PRIOR cir.subject_id
  UNION
  SELECT cis.inventory_item_id
  FROM csi_item_instances cis
  WHERE cis.instance_id = c_instance_id;

Line: 89

  SELECT 'X'
  FROM ahl_mc_relationships
  WHERE mc_header_id = c_mc_header_id
  AND position_key = c_position_key;

Line: 96

 SELECT mtl.primary_uom_code
 FROM mtl_system_items_kfv mtl, hr_organization_units hou, mtl_parameters mtlp
 WHERE mtl.organization_id = hou.organization_id
 AND mtlp.organization_id = hou.organization_id
 AND mtlp.eam_enabled_flag = 'Y'
 AND hou.organization_id =  c_org_id
 AND mtl.inventory_item_id  = c_item_id;

Line: 106

  SELECT vts.visit_task_id,  awo.workorder_id , awo.wip_entity_id, wop.operation_sequence_num, wop.workorder_operation_id, vts.start_date_time, awo.workorder_name
  FROM ahl_visit_tasks_b vts, ahl_workorders awo, ahl_workorder_operations wop
  WHERE vts.visit_task_id = awo.visit_task_id
  AND   awo.workorder_id = wop.workorder_id
  AND   vts.task_type_code = 'PLANNED'
  AND vts.service_request_id = c_sr_id
  AND vts.visit_id = c_visit_id;

Line: 613

    SELECT  unit_effectivity_id
    FROM AHL_UNIT_EFFECTIVITIES_B
    WHERE cs_incident_id  = p_incident_id;

Line: 619

    SELECT   WO.visit_task_id
    FROM   AHL_WORKORDERS WO
    WHERE   WO.workorder_id = c_nonroutine_wo_id;

Line: 625

   SELECT  sr_incident_ovn, sr_incident_type_id, sr_problem_summary
   FROM ahl_sr_non_routines_v
   WHERE sr_incident_id = c_sr_incident_id;

Line: 661

    SELECT START_DATE_TIME FROM AHL_VISITS_B WHERE VISIT_ID = C_VISIT_ID;

Line: 798

      SELECT visit_task_id,object_version_number INTO l_upd_rts_task_tbl(1).visit_task_id,l_upd_rts_task_tbl(1).object_version_number
      FROM ahl_visit_tasks_b
      WHERE service_request_id = l_create_task_tbl(1).service_request_id
      AND  task_type_code = 'PLANNED';

Line: 873

    SELECT workorder_id INTO l_temp_wo_id
    FROM ahl_workorders
    WHERE visit_task_id =
               ( SELECT visit_task_id
                 FROM ahl_visit_tasks_b
                 WHERE service_request_id = l_create_task_tbl(1).service_request_id
                 AND  task_type_code = 'PLANNED'
               );

Line: 898

  AHL_PRD_WORKORDER_PVT.update_job
  (
    p_api_version           => 1.0,
    p_init_msg_list         => FND_API.G_FALSE,
    p_commit                 =>  FND_API.G_FALSE,
    p_validation_level      => p_validation_level,
    p_default                 =>  FND_API.G_FALSE,
    p_module_type          =>  'SR',
    x_return_status         => l_return_status,
    x_msg_count             => l_msg_count,
    x_msg_data              => l_msg_data,
    p_wip_load_flag        => 'Y',
    p_x_prd_workorder_rec => l_prd_workorder_rec,
    p_x_prd_workoper_tbl   => l_prd_workoper_tbl
  );