APPS.EAM_PM_SUPPRESSIONS SQL Statements

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

Line: 7

   * This should be called before the record is actually inserted into the table.
   */
  function check_no_loop(p_parent_assoc_id in number,
                         p_child_assoc_id  in number) return boolean is
    cursor C is
      select child_association_id
        from eam_suppression_relations
       where parent_association_id = p_child_assoc_id;

Line: 46

   * This should be called before the record is actually inserted into the table.
   */
  function is_supp_rule_maintained(p_parent_assoc_id in number,
                                   p_child_assoc_id  in number) return boolean is
    x_num number;

Line: 52

    select count(*) into x_num
      from eam_suppression_relations sup,
--           eam_pm_schedulings pms,
           mtl_eam_asset_activities eaa
     where sup.child_association_id = p_child_assoc_id
--       and sup.child_association_id = pms.activity_association_id
       and sup.child_association_id = eaa.activity_association_id
--       and nvl(pms.from_effective_date, sysdate-1) < sysdate
--       and nvl(pms.to_effective_date, sysdate+1) > sysdate
       and nvl(eaa.start_date_active, sysdate-1) < sysdate
       and nvl(eaa.end_date_active, sysdate+1) > sysdate;

Line: 91

    select  supp.parent_association_id, supp.child_association_id,
            msn.inventory_item_id
    from    mtl_serial_numbers msn, eam_suppression_relations supp,
            mtl_eam_asset_activities meaa
    where   msn.gen_object_id = p_maintenance_object_id and
            supp.tmpl_flag = 'Y' and
            meaa.tmpl_flag = 'Y' and
            supp.parent_association_id = meaa.activity_association_id and
            meaa.inventory_item_id = msn.inventory_item_id;  */

Line: 102

 select  supp.parent_association_id, supp.child_association_id,
            cii.inventory_item_id
    from    csi_item_instances cii, eam_suppression_relations supp,
            mtl_eam_asset_activities meaa
    where   cii.instance_id = p_maintenance_object_id and
            supp.tmpl_flag = 'Y' and
            meaa.tmpl_flag = 'Y' and
            supp.parent_association_id = meaa.activity_association_id and
            meaa.maintenance_object_id = cii.inventory_item_id
	    and meaa.maintenance_object_type=2;

Line: 199

    select * from eam_suppression_relations
    where parent_association_id = p_parent_association_id
    and child_association_id = p_child_association_id;

Line: 204

    select meaa_an.activity_association_id into l_parent_assoc_id
    from mtl_eam_asset_activities meaa_an,
         mtl_eam_asset_activities meaa_ag
    where meaa_ag.activity_association_id = p_parent_association_id
    and meaa_ag.asset_activity_id = meaa_an.asset_activity_id
    and meaa_an.maintenance_object_id = p_maintenance_object_id;

Line: 211

    select meaa_an.activity_association_id into l_child_assoc_id
    from mtl_eam_asset_activities meaa_an,
         mtl_eam_asset_activities meaa_ag
    where meaa_ag.activity_association_id = p_child_association_id
    and meaa_ag.asset_activity_id = meaa_an.asset_activity_id
    and meaa_an.maintenance_object_id = p_maintenance_object_id;

Line: 222

      insert into eam_suppression_relations(
      parent_association_id,
      child_association_id,
      description,
	  tmpl_flag,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15)
      values(
      l_parent_assoc_id,
      l_child_assoc_id,
      supp_rec.description,
  	  'N',
      sysdate,
      fnd_global.user_id,
      sysdate,
      fnd_global.user_id,
   	  fnd_global.login_id,
      supp_rec.attribute_category,
      supp_rec.attribute1,
      supp_rec.attribute2,
      supp_rec.attribute3,
      supp_rec.attribute4,
      supp_rec.attribute5,
      supp_rec.attribute6,
      supp_rec.attribute7,
      supp_rec.attribute8,
      supp_rec.attribute9,
      supp_rec.attribute10,
      supp_rec.attribute11,
      supp_rec.attribute12,
      supp_rec.attribute13,
      supp_rec.attribute14,
      supp_rec.attribute15 );