APPS.MSC_PERS_QUERIES dependencies on MSC_ITEM_ATTRIBUTES

Line 561: from msc_item_attributes

557: p_query_id IN NUMBER) IS
558:
559: cursor item_exist(p_item number, p_org number, p_inst number) IS
560: select 1
561: from msc_item_attributes
562: where simulation_set_id = -1
563: and plan_id = -1
564: and inventory_item_id = p_item
565: and organization_id = p_org

Line 610: update msc_item_attributes

606: fetch cat_id into p_cat;
607: close cat_id;
608:
609: if p_exist = 1 then
610: update msc_item_attributes
611: set criticality_category = p_cat
612: where inventory_item_id = v_item_id(j)
613: and organization_id = v_org_id(j)
614: and sr_instance_id = v_inst_id(j)

Line 618: insert into msc_item_attributes(simulation_set_id,

614: and sr_instance_id = v_inst_id(j)
615: and simulation_set_id = -1
616: and plan_id = -1;
617: else
618: insert into msc_item_attributes(simulation_set_id,
619: inventory_item_id, organization_id,
620: sr_instance_id, last_update_date,
621: last_updated_by, creation_date, created_by,
622: criticality_category, plan_id, updated_columns_count