eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_PERS_QUERIES dependencies on MSC_ITEM_ATTRIBUTES

Line 621: from msc_item_attributes

617: p_query_id IN NUMBER) IS
618:
619: cursor item_exist(p_item number, p_org number, p_inst number) IS
620: select 1
621: from msc_item_attributes
622: where simulation_set_id = -1
623: and plan_id = -1
624: and inventory_item_id = p_item
625: and organization_id = p_org

Line 670: update msc_item_attributes

666: fetch cat_id into p_cat;
667: close cat_id;
668:
669: if p_exist = 1 then
670: update msc_item_attributes
671: set criticality_category = p_cat
672: where inventory_item_id = v_item_id(j)
673: and organization_id = v_org_id(j)
674: and sr_instance_id = v_inst_id(j)

Line 678: insert into msc_item_attributes(simulation_set_id,

674: and sr_instance_id = v_inst_id(j)
675: and simulation_set_id = -1
676: and plan_id = -1;
677: else
678: insert into msc_item_attributes(simulation_set_id,
679: inventory_item_id, organization_id,
680: sr_instance_id, last_update_date,
681: last_updated_by, creation_date, created_by,
682: criticality_category, plan_id, updated_columns_count