APPS.EAM_MAINT_ATTRIBUTES_PUB SQL Statements

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

Line: 114

     eam_org_maint_defaults_pvt.insert_row
     (
       p_api_version           => 1.0
      ,p_object_type           => 50
      ,p_object_id             => p_instance_id
      ,p_organization_id       => l_org_id
      ,p_owning_department_id  => p_owning_department_id
      ,p_accounting_class_code => p_accounting_class_code
      ,p_area_id               => p_area_id
      ,x_return_status         => x_return_status
      ,x_msg_count             => x_msg_count
      ,x_msg_data              => x_msg_data
     );

Line: 135

           SELECT cii.serial_number, cii.inventory_item_id, cii.last_vld_organization_id
             INTO l_sn_1, l_inv_id_1, l_org_id_1
             FROM csi_item_instances cii, mtl_system_items msi
            WHERE cii.instance_id = p_instance_id AND cii.inventory_item_id = msi.inventory_item_id
              AND cii.last_vld_organization_id = msi.organization_id AND msi.eam_item_type in (1,3)
              AND msi.serial_number_control_code <> 1;

Line: 148

           SELECT cii.serial_number, cii.inventory_item_id, cii.last_vld_organization_id
             INTO l_sn_2, l_inv_id_2, l_org_id_2
             FROM csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
            WHERE cii.instance_id = p_parent_instance_id AND cii.inventory_item_id = msi.inventory_item_id
              AND cii.last_vld_organization_id = msi.organization_id AND msi.eam_item_type in (1,3)
              AND msi.serial_number_control_code <> 1 AND  msi.organization_id = mp.organization_id
              AND mp.maint_organization_id = l_org_id;

Line: 215

   PROCEDURE update_maint_attributes
   (
      p_api_version           IN  NUMBER
     ,p_init_msg_list         IN  VARCHAR2 := fnd_api.g_false
     ,p_commit                IN  VARCHAR2 := fnd_api.g_false
     ,p_validation_level      IN  NUMBER   := fnd_api.g_valid_level_full
     ,p_instance_id           IN  NUMBER
     ,p_owning_department_id  IN  NUMBER
     ,p_accounting_class_code IN  VARCHAR2
     ,p_area_id               IN  NUMBER
     ,x_return_status         OUT NOCOPY VARCHAR2
     ,x_msg_count             OUT NOCOPY NUMBER
     ,x_msg_data              OUT NOCOPY VARCHAR2
   ) IS

     l_api_name       CONSTANT VARCHAR2(30) := 'update_maint_attributes';

Line: 286

     eam_org_maint_defaults_pvt.update_insert_row
     (
       p_api_version           => 1.0
      ,p_object_type           => 50
      ,p_object_id             => p_instance_id
      ,p_organization_id       => l_org_id
      ,p_owning_department_id  => p_owning_department_id
      ,p_accounting_class_code => p_accounting_class_code
      ,p_area_id               => p_area_id
      ,x_return_status         => x_return_status
      ,x_msg_count             => x_msg_count
      ,x_msg_data              => x_msg_data
     );

Line: 333

   END update_maint_attributes;

Line: 383

     SELECT count(instance_id) INTO l_count FROM csi_item_instances cii, mtl_system_items msi
      WHERE cii.instance_id = p_instance_id AND cii.inventory_item_id = msi.inventory_item_id
        AND cii.last_vld_organization_id = msi.organization_id AND msi.eam_item_type in (1,3)
	AND msi.serial_number_control_code <> 1;

Line: 394

     SELECT mp.maint_organization_id INTO x_org_id FROM csi_item_instances cii, mtl_parameters mp
      WHERE cii.instance_id = p_instance_id AND cii.last_vld_organization_id = mp.organization_id;

Line: 406

           SELECT count(department_id) INTO l_count FROM bom_departments
            WHERE department_id = p_owning_department_id AND organization_id = x_org_id
              AND nvl(disable_date, sysdate+1) >= sysdate;

Line: 421

           SELECT count(*) INTO l_count FROM wip_accounting_classes
            WHERE class_code = p_accounting_class_code AND class_type = 6
              AND organization_id = x_org_id;

Line: 436

           SELECT count(*) INTO l_count FROM mtl_eam_locations
            WHERE location_id = p_area_id AND organization_id = x_org_id
              AND sysdate BETWEEN nvl(start_date, sysdate-1) AND nvl(end_date, sysdate+1);